Senior Data Warehouse Architect

University of Rochester; United States; On-site; USD 87,000 - 130,000; Full time

Job summary

The University of Rochester is seeking a Senior Data Warehouse Developer to architect, design, develop, and support enterprise data warehouse components and data sources. You will mentor staff, implement best practices, and contribute to BI and data warehousing initiatives.

The role requires experience with ETL, data modeling, and cloud platforms, and involves collaboration with a cross-functional team to ensure data quality and availability for reporting and analytics.

Qualifications

• Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required
• Master's degree preferred
• 5 years of related experience required
• Equivalent combination of education and experience.
• Experience with Data Warehousing ETL technologies and knowledge of BI lifecycles required
• Experience with dimensional data models required
• Python, SQL, and cloud data platforms (AWS, GCP, Azure) preferred
• Strong MSSQL Server T-SQL experience preferred
• Proven development skills (SDLC) preferred

Responsibilities

• Architects data integration and transformation processes across on premise and cloud data sources.
• Develops data models and database designs leveraging data warehouse modeling best practices.
• Collaborates with team using scrum or other PM disciplines and provides documentation.
• Mentors staff, plans for business continuity and sustainability.
• Provides on-call support for business continuity and operations.

Job description

The University of Rochester is seeking a Senior Data Warehouse Developer to architect, design, develop, and support enterprise data warehouse components and data sources. You will mentor staff, implement best practices, and contribute to BI and data warehousing initiatives.

The role requires experience with ETL, data modeling, and cloud platforms, and involves collaboration with a cross-functional team to ensure data quality and availability for reporting and analytics.