UR Ventures
Ensuring University of Rochester innovations enrich our community, improve our society, and make the world ever better
Senior Data Warehouse Developer
Location
New York
Posted
79 days ago
Salary
$86.5K - $129.7K / year
Bachelor Degree5 yrs expEnglishCloudETLInformaticaOracle
Job Description
• 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 Atmosphere, 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.
• 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.
Job Requirements
- Bachelor's degree and 5 years of relevant experience required
- Master's degree preferred
- Multiple project experience with Data Warehousing ETL technologies 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