Sr. Data Warehouse Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

University of Rochester · 4 weeks ago

Sr. Data Warehouse Developer

positionRochester, NY
timeFull-time
remoteOnsite
senioritySenior Level
money$86K/yr - $130K/yr
date5+ years exp

The University of Rochester is committed to fostering an inclusive and welcoming culture. They are seeking a Senior Data Warehouse Developer to architect, design, develop, implement, and support various components for the enterprise data warehouse and associated data sources, while also mentoring staff and providing leadership in business intelligence and data warehousing functions.

Health CareMedicalUniversities
check
H1B Sponsor Likelynote

Responsibilities

Architects, designs, develops, implements and supports various components for the enterprise data warehouse and associated data sources
Provides support for reporting projects, as well as process and architectural recommendations
Mentors staff, demonstrates best practices, plans for business continuity and sustainability and works on projects that support Business Intelligence and Data Warehousing functions
Develops data integration and transformation processes across on premise and cloud data sources using tools, including Oracle Data Integrator, Boomi Atomsphere, Informatica, as determined by the environment
Works with the user community and reporting team to understand business data and data transformation requirements
Converts requirements to functional and technical specifications for database and integration design
Manages requests and/or components of larger projects with appropriate documentation and status reports
Develops data models and database designs that leverage knowledge of data warehouse modeling best practices
Architects data integration and transformation processes across on premise and cloud data sources
Provides leadership and serves as a subject matter expert
Collaborates with other team members using scrum processes or other project management disciplines
Follows best practices for change and code management
Provides supporting technical documentation that is well 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

Data Warehousing ETLDimensional data modelsSQLOracle Data IntegratorDell Boomi AtomspherePl/SQLUNIX scriptingAnalytical skillsAgile processesWeb services developmentService oriented architectureEPIC CertificationTeam collaborationWritten communication

Required

Bachelor's degree and 5 years of relevant 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
In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) required
Proficiency in developing data transformation packages/stored procedures required

Preferred

Master's degree preferred
Experience with integrating data warehouses with business intelligence metadata tools preferred
Experience with service oriented architecture and enterprise information integration preferred
Experience with the development of web services preferred
Experience with Dell Boomi Atomsphere preferred
Experience with Oracle Data Integrator preferred
EPIC - EPIC Certification upon hire preferred

Company

University of Rochester

twittertwittertwitter
Glassdoor4.0
company-logo
The University of Rochester is a private research university located in Rochester, New York.
dateFounded in 1921
location
Rochester, New York, USA
people-size10001+ employees
web-link
https://www.urmc.rochester.edu

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 Stage
Total Funding
$20.43M
Key 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

leader-logo
David Linehan
Chief Executive Officer
linkedin

Recent News

BioSpace
Indivumed and University of Rochester Medical Center expand collaboration for patient-centric discovery of novel therapeutics
2025-12-10
thefly.com
GE HealthCare, URMC announce care alliance
2025-12-04
PharmiWeb
University of Rochester Medical Center and GE HealthCare form seven-year Care Alliance to build advanced capabilities across system
2025-12-03
Company data provided by crunchbase