University of Rochester · 3 months ago
Sr Data Warehouse Developer - Supply Chain
Rochester, New York Metropolitan Area
Full-time
Onsite
Mid, Senior Level
$86K/yr - $130K/yr
5+ years expThe University of Rochester is committed to fostering an inclusive and welcoming culture, and they are seeking a Senior Data Warehouse Developer to architect, design, develop, implement, and support various components for the enterprise data warehouse. This role involves collaborating with the user community, managing project components, and mentoring staff while ensuring best practices in data integration and transformation processes.
Health CareMedicalUniversities
Responsibilities
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
Qualification
Required
Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering Required
5 years of related experience Required
Equivalent combination of education and 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
Understanding of data warehouse and agile software development processes Required
Proficiency in developing data transformation packages/stored procedures required
Preferred
Master's degree
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
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 Preferred
Epic Systems Cogito or Clarity and Caboodle Preferred
Cogito Fundamentals and a Cogito Data Model certification obtained within the first year of employment. Preferred
Company
University of Rochester
The University of Rochester is a private research university located in Rochester, New York.
10001+ employees
H1B Sponsorship
University of Rochester has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (234)
2024 (126)
2023 (130)
2022 (106)
2021 (100)
2020 (92)
Funding
Current Stage
Late StageTotal Funding
$20.43MKey Investors
National Science FoundationUnitedHealthcareSociety to Improve Diagnosis in Medicine
2023-09-25Grant· $18M
2023-07-26Grant· $0.07M
2022-09-20Grant· $0.05M
Leadership Team
David Linehan
Chief Executive Officer
Recent News
2025-12-04
Company data provided by crunchbase