Senior Data Warehouse Architect & ETL Lead

University of Rochester; City of Rochester (NY); On-site; USD 86,482 - 129,723; Full time

Job summary

The University of Rochester seeks a Senior Data Warehouse Developer to design and implement solutions for its enterprise data warehouse. Responsibilities include managing data integration across cloud sources and mentoring junior staff. Ideal candidates will hold a Bachelor's degree, possess 5 years of relevant experience, and demonstrate proficiency in data warehousing tools like Informatica and SQL. This role is flexible to work on various BI projects and offers a comprehensive compensation range of $86,482 to $129,723 annually.

Qualifications

• Minimum 5 years of related experience and knowledge of Data Warehousing/Business Intelligence lifecycles.
• Experience with dimensional data models and ETL technologies required.
• Understanding of cloud data platforms (AWS, GCP, Azure) preferred.

Responsibilities

• Architects, designs, develops, and supports components for the enterprise data warehouse.
• Mentors staff and demonstrates best practices.
• Collaborates with team members using project management disciplines.

Skills

Strong Analytical and Problem-solving abilities

Excellent written communication skills

Proficiency in developing data transformation packages/stored procedures

Education

Bachelor's degree in Computer Science, Business, Mathematics, Statistics, Science or Engineering

Master’s degree

Tools

Oracle Data Integrator

Boomi Atmosphere

Informatica

SQL

Python

MSSQL Server

Job description

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address):

30 Corporate Woods, Brighton, New York, United States of America, 14623

Opening

Worker Subtype:

Regular

Time Type

Full time

Scheduled Weekly Hours

40

Department

900081 ISD Analytics

Work Shift

UR - Day (United States of America)

Range

UR URG 114

Compensation Range

$86,482.00 - $129,723.00

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Responsibilities

The Senior Data Warehouse Developer is responsible for architecting, designing, developing, implementing and supporting various components for the enterprise data warehouse and associated data sources. Works independently and provides support for reporting projects, as well as process and architectural recommendations. Responsible for mentoring staff, demonstrating best practices, planning for business continuity and sustainability and working on projects that support Business Intelligence and Data Warehousing functions as assigned.

Essential Functions

• Works with the user community and reporting team to understand business data and data transformation requirements. Converts those requirements to functional/technical specifications for database and integration design. Manages requests and/or components of larger projects with appropriate documentation and status reports
• Architects data integration and transformation processes across on premise and cloud data sources. Provides leadership and is a subject matter expert depending on area of focus.
• Develops data integration and transformation processes across on premise and cloud data sources using tools including Oracle Data Integrator, Boomi Atmosphere, Informatica as determined by the environment.
• Develops data models and database designs that leverage their knowledge of data warehouse modeling best practices.
• Collaborates with other team members using scrum processes or other project management disciplines depending on area of focus. Follows best practices for change and code management. Provides supporting technical documentation that is written, organized and maintained.
• Participates in ongoing stabilization, support and maintenance. Provides on call support as needed for business continuity and operations. Attends webinars, reads case studies and white papers, and participates in opportunities to further refine skills and stay apprised on functional area topics. Maintains current knowledge of technology, equipment, and/or systems and advises on newer technologies.
• Other duties as assigned
  
  

Minimum Education & Experience

• 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.
• Multiple project experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence lifecycles required.
• Experience with dimensional data models required
• Understanding in Python, SQL, and familiarity with cloud data platforms (e.g. AWS, GCP, Azure) preferred
• Proven ability to work professionally and progressively in a matrix organization preferred
• Strong TSQL experience (MSSQL Server) preferred
• Proven development skills (SDLC) preferred
• Report Development experience (one or more of SQL, SSRS, , Tableau, Spotfire) preferred
• Healthcare information systems experience preferred
• Experience with Epic Systems preferred
• Informatica IDMC experience preferred
• Denodo Virtual Data Platform
  
  

Knowledge, Skills And Abilities

• Strong Analytical and Problem-solving abilities required
• Ability to actively participate and collaborate on a team required
• Excellent written communication skills. Ability to translate functional business requirements into documented system requirements and designs required
• Understanding of data warehouse and agile software development processes preferred
• Ability and initiative to learn new technologies preferred
• Proven Ability to work under pressure in a fast-paced environment preferred
• Analytical mindset with strong problem solving abilities required
• Proficiency in developing data transformation packages/stored procedures required
  
  

LICENSES AND CERTIFICATIONS (Preferred)

• Epic Systems Cogito or Clarity and Caboodle
• Cogito Fundamentals and a Cogito Data Model certification obtained within the first year of employment.
  
  

The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the University’s Mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.