> Markdown version of [/jobs/ext/3530135-data-warehouse-developer](https://www.wearedevelopers.com/jobs/ext/3530135-data-warehouse-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Warehouse Developer

- **Company:** The University of Rochester
- **Location:** Brighton, United States
- **Experience:** Expert
- **Salary:** $86,900.0 - $130,300.0
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Amazon Web Services, Microsoft Azure, Health Informatics, Cloud Computing, Information Systems, Databases, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Design, Dimensional Modeling, Hardware Virtualization, Python (Programming Language), Microsoft Software, Microsoft SQL Server, Oracle Data Service Integrator, Scrum Methodology, Systems Development Life Cycle, Cloud Services, Requirements Management, Software Engineering, Software Requirements Analysis, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, Tableau (Software), Transact-SQL, Scripting, Google Cloud, Informatica Powercenter, Boomi, Information Technology, Integration Frameworks, Epic Clarity, Spotfire, Epic Caboodle
- **Published:** October 2, 2026
- **Apply:** https://www.careerbuilder.com/job-details/sr-data-warehouse-developer--566a08c7-0d22-47d0-9980-1b582972d6b7

## About the Role

* 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., Agile Programming Methodologies, Amazon Web Services (AWS), Analysis Skills, Architectural Design, Architectural Services, Best Practices, Business Continuity Planning (BCP), Business Intelligence, Business Operations, Business Support, Cloud Computing, Communication Skills, Computer Science, Data Modeling, Data Warehousing, Data Warehousing Software, Database Design, Database Extract Transform and Load (ETL), Dimensional Modeling, Documentation, Embedded Systems, Epic Caboodle, Epic Clarity, Epic Cogito Data Warehouse, Epic Systems, Functional Requirements Document (FRD), GCP (Good Clinical Practices), Genetics, Hardware Virtualization, Healthcare, Informatica, Information Technology & Information Systems, Leadership, Legal, Mathematics, Matrix Management, Mentoring, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, On Call, Oracle Data Integrator, Organizational Skills, Problem Solving Skills, Project/Program Management, Python Programming/Scripting
Language, Requirements Management, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Scrum Project Management and Software Development, Software Development, Software Development Lifecycle (SDLC), Statistics, Status Reports, Stored Procedures, Support Documentation, Sustainability, Tableau, Technical Support, Technical Writing, Webinar, White Papers, Writing Skills

## 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., * 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


## Related Videos

- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)