The University of Rochester is looking to solve business and technical problems related to enterprise data warehouse and associated data sources, including data integration, transformation, and reporting.
Requirements
- Experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence lifecycles required
- Experience with dimensional data models required
- 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
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.
- 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.
- Collaborates with other team members using scrum processes or other project management disciplines.
- Provides supporting technical documentation that is well written, organized and maintained.
- Participates in ongoing stabilization, support and maintenance.
Other
- Bachelor's degree and 5 years of relevant experience required
- Master's degree preferred
- Strong analytical and problem solving abilities required
- Ability to actively participate and collaborate on a team required
- Excellent written communication skills.
