Senior Data Warehouse Architect & ETL Lead

University of Rochester; United States; A distancia; USD 87.000 - 130.000; Jornada completa

Descripción de la vacante

The University of Rochester is seeking a Senior Data Warehouse Developer to architect, design, and implement enterprise data warehouse components. You will mentor staff, drive data integration across on-premises and cloud sources, and provide technical guidance for BI and data warehousing projects.

You will work with Informatica, Denodo, SQL Server, SSIS, Oracle Data Integrator, and Boomi AtomSphere to deliver robust data solutions. Strong SQL/PLSQL and UNIX scripting skills are essential.

Formación

• Bachelor’s degree plus 5 years of related experience required.
• 5 years of experience in Data Warehousing/ETL environments.
• Experience with dimensional data models required.
• OMOP data model experience preferred.
• Proficient in SQL/PLSQL and UNIX scripting with Oracle/DB2/SQL Server.
• Experience with data integration tools such as Informatica, Denodo, and Boomi.

Responsabilidades

• Architect, design, develop, implement, and support enterprise data warehouse components.
• Mentor staff and promote best practices; contribute to business continuity planning.
• Lead data integration across on‑premise and cloud sources; provide technical documentation.
• Collaborate in SCRUM teams; ensure change control and knowledge sharing.
• Provide on‑call support for operations and stability; stay current with BI/Warehouse trends.

Conocimientos

Analytical ability

Team collaboration

Written communication

Data warehouse knowledge

SQL/PLSQL

UNIX scripting

Educación

Bachelor’s degree in a related field

Master’s degree preferred

Herramientas

Informatica

Denodo

SQL Server

SSIS

Oracle Data Integrator

Boomi AtomSphere

Informatica IDMC

MDM

MS SQL Server Tools

Descripción del empleo

The University of Rochester is seeking a Senior Data Warehouse Developer to architect, design, and implement enterprise data warehouse components. You will mentor staff, drive data integration across on-premises and cloud sources, and provide technical guidance for BI and data warehousing projects.

You will work with Informatica, Denodo, SQL Server, SSIS, Oracle Data Integrator, and Boomi AtomSphere to deliver robust data solutions. Strong SQL/PLSQL and UNIX scripting skills are essential.