UR Ventures

Ensuring University of Rochester innovations enrich our community, improve our society, and make the world ever better

Senior Data Warehouse Developer

Full TimeRemoteTeam 11-50H1B No SponsorCompany SiteLinkedIn

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

Related Categories

Related Job Pages