Sr. Data Warehouse Developer

University of Rochester•New York, NY

7d•Remote

About The Position

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. 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.

Requirements

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

Nice To Haves

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

Responsibilities

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.