Sr Data Warehouse Developer

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.

** Job Location (Full Address):*
* 30 Corporate Woods, Brighton, New York, United States of America, 14623

** Opening:*
* Worker Subtype:

Regular

Time Type:

Full time

Scheduled Weekly

Hours:

40

Department:

900081 ISD Analytics

Work Shift:

UR - Day (United States of America)

Range:

UR URG 114

Compensation Range:

$86,482.00 - $

_The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations._

** Responsibilities:*
* The Senior Data Warehouse Developer's responsibilities include architecting, designing, developing, implementing and supporting various components for the enterprise data warehouse and associated data sources.  The Sr Developer works independently and provides support for reporting projects, as well as process and architectural recommendations.  Responsibilities include mentoring staff, demonstrating best practices, planning for business continuity and sustainability and working on projects that support Business Intelligence and Data Warehousing functions as assigned.

** ESSENTIAL FUNCTIONS*
* + Works with the user community and reporting team to understand business data and data transformation requirements. Converts those requirements to functional/technical specifications for database and integration design. Manages requests and/or components of larger projects with appropriate documentation and status reports

+ Architects data integration and transformation processes across on premise and cloud data sources. Provides leadership and is a subject matter expert depending on area of focus.

+ Designs and develops data integration and transformation processes across on-premises and cloud data sources using enterprise tools such as Informatica, Denodo, SQL Server, SSIS, Oracle Data Integrator, and Boomi Atom Sphere, selected based on environment and requirements.

+ Develops data models and database designs that leverage their knowledge of data warehouse modeling best practices.

+ Collaborates with other team members using scrum processes or other project management disciplines depending on area of focus. Follows best practices for change and code management. Provides supporting technical documentation that is 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

** MINIMUM EDUCATION & EXPERIENCE*
* + Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required

+ 5 years of related experience required

+ Equivalent combination of education and experience required.

+ Multiple project experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence life cycles required.

+

Experience with dimensional data models required

+

Experience with OMOP data model 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  Denodo Virtualization Platform preferred

+

Experience with Informatica IDMC, MDM preferred

+

Experience with MS SQL Server Tools…