Senior Data Warehouse Architect

001 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, and implement components for the enterprise data warehouse and related data sources. The role involves mentoring staff, guiding BI/ETL best practices, and supporting business intelligence initiatives.

You will develop data models, collaborate with cross-functional teams, and lead data integration across on-premises and cloud environments using tools like Informatica IDMC, Denodo, and Boomi AtomSphere.

Qualifications

• Bachelor's degree in Computer Science, Math, Statistics, Engineering or related field.
• 5+ years of related experience in data warehousing and ETL.
• Master’s degree preferred.
• Experience with data warehousing lifecycles and BI tooling recommended.

Responsibilities

• Architect, design, develop, implement and support components for the enterprise data warehouse.
• Mentor staff and promote best practices in BI/ETL development.
• Lead data integration across on-premises and cloud sources.
• Develop data models and warehouse designs leveraging industry best practices.
• Collaborate with Scrum teams and document changes and progress.
• Provide on-call support for business continuity and operations.

Skills

Analytical skills

Problem solving

Team collaboration

Communication

Data analysis

Education

Bachelor's degree in Computer Science / related fields

Master’s degree preferred

Tools

Informatica IDMC

Denodo

SQL Server

SSIS

Oracle Data Integrator

Boomi AtomSphere

Job description

The University of Rochester is seeking a Senior Data Warehouse Developer to architect, design, and implement components for the enterprise data warehouse and related data sources. The role involves mentoring staff, guiding BI/ETL best practices, and supporting business intelligence initiatives.

You will develop data models, collaborate with cross-functional teams, and lead data integration across on-premises and cloud environments using tools like Informatica IDMC, Denodo, and Boomi AtomSphere.