Senior Data Warehouse Developer Job at University of Rochester (Brighton)

Job Description

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.

Job Responsibility

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

Requirements

Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required
5 years of related experience required
Multiple project experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence lifecycles required
Experience with dimensional data models required
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
Analytical mindset with strong problem solving abilities required
Proficiency in developing data transformation packages/stored procedures required

Nice to have

Master’s degree preferred
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
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
Epic Systems Cogito or Clarity and Caboodle
Cogito Fundamentals and a Cogito Data Model certification obtained within the first year of employment

University of Rochester - All Job Offers

Select Country

Senior Data Warehouse Developer

Job Description

Job Responsibility

Requirements

Nice to have

Looking for more opportunities?

Senior Data Warehouse Developer

Data Warehouse Architect - Senior ETL/BI Developer

Senior Data / Data Warehouse (DWH) Engineer

Senior Data Engineer (Data Warehouse)

Senior Data Warehouse Lead

Senior Oracle Data Warehouse / Apex Consultant

Senior Oracle Data Warehouse / Apex Consultant

Data Warehouse Specialist Developer - PACS/RIS

Senior Engineer, Data Warehouse

Our AI answers in your language