Data Warehouse/Application Architect

$77,800 - $91,500/Yr

St. John Fisher University - New York, NY

Full-time - Mid Level

New York, NY

1,001-5,000 employees

About the position

The Data Warehouse/Application Architect at St. John Fisher University is responsible for the design, development, and management of a data warehouse environment that supports analytics and reporting. This role involves collaborating with campus stakeholders to create data models and intelligence delivery systems, ensuring the university meets its strategic and tactical goals. The architect will engage in requirements gathering, data mining, and profiling, and will oversee the implementation and maintenance of data warehousing solutions in an agile environment.

Responsibilities

• Engage with stakeholders to gather requirements for reporting and analytic solutions in support of campus initiatives.
• Manage and coordinate the completion and change management of multiple projects simultaneously.
• Create high-level architecture and specifications to ensure feasibility, functionality, and integration.
• Design, develop, and communicate appropriate data structures and architectures including data vault, star schema, and data mining models.
• Develop and test programs using TSQL and other ETL tools to support reporting and extract solutions.
• Support business and technical staff regarding the content and use of data warehouse objects.
• Maintain table structures, programs, scripts, and documentation to ensure alignment with the data warehouse strategy and architecture.
• Conceive and portray the big data picture, initiating, evaluating, and influencing projects from an organizational perspective.
• Complete in-depth data modeling and database design across all phases of data modeling.

Requirements

• Bachelor's degree in computer science, information science, or related field.
• 8-10 years of experience in BI data warehousing or related field with a focus on data modeling and data warehousing.
• Extensive architectural design experience for Business Data Warehouse and Analytics.
• Architecture and deployment experience with IBM BI & Analytical Tools, Oracle's Database, and Microsoft's Server products.
• Experience implementing data governance principles and utilizing commercial tools for data governance and stewardship.
• Proven ability to provide high levels of interpersonal communication in a higher education environment.
• Demonstrated knowledge of data warehousing/business intelligence best practices, methodologies, standards, and architectures.
• Experience with Microsoft SQL Server BI technology stack, specifically T-SQL, SSAS cubes, and Stored Procedures.

Nice-to-haves

• Experience in higher education and their associated data landscapes.
• Substantive experience with Oracle databases and SQL.
• Experience with Banner Higher Education ERP systems preferred.
• Strong communication and collaboration skills.
• Strong Oracle SQL and PL/SQL programming skills.
• Unix Shell scripting experience.

Benefits

• Competitive salary range of $77,800.00-$91,500.00 per year.
• Equal Employment Opportunity policies ensuring a non-discriminatory work environment.