Data Warehouse Developer II

University of Rochester•City of Rochester, NY

About The Position

Responsible for the design, development, implementation, and support of various components for the enterprise data warehouse and associated data sources. Provides support for reporting projects and works on projects as assigned. Interacts with multiple disciplines to ensure data services needs are met. Works collaboratively to build a foundation for integrated analytical applications/extracts in SQL tools (SSIS/SSRS/T-SQL) as well as ETL development using Informatica, Virtual and Physical data warehousing, Epic Systems and reporting BI tools. Supports additional projects and requests to perform analysis and/or programming addressing challenging tasks as needed. Acts as a resource for lower level staff.

Requirements

Associate's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering and4 years of relevant experience required
TSQL experience (MSSQL Server) required
ETL Development experience (Informatica), some report development (SSRS, Tableau) required
Ability to work professionally and progressively in a matrix organization and to work under pressure in a fast-paced environment, as well as the ability and initiative to learn new technologies required
Development, analytical and problem solving skills required
Good customer service orientation and communication skills required
Knowledge of relational data bases and star schemas required
Skills with Microsoft Office (Including Office & Visio). Must be proficient in Microsoft SQL Server Management Studio required

Nice To Haves

Experience with healthcare information systems preferred
Experience with Epic Systems preferred
EPIC - EPIC Certification upon hire preferred

Responsibilities

Develops SQL Server by understanding the security model and schema objects, including tables, indexes and applied constraints, functions, and stored procedures. Views and advances T-SQL programming.
Implements ETL (Informatica) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse with guidance.
Performs proper testing and validation techniques to ensure accuracy and integrity of reported or extracted data and document the unit test and validation processes used.
Develops new and supports maintenance of existing reports and data sets contributing to maintaining the report inventory.
Utilizes EMR workflows to translate between the transactional systems and the data repository.
Utilizes standard dimensional data model optimized for performance and ease of reporting.
Provides development support for integrated administration tools for managing and monitoring the Data Warehouse.
Learns new technologies related to virtual data warehousing.
Works with clinical, financial, and business requirements related to reporting applications support for the eco-system of applications.
Manages requests and/or components of larger projects with appropriate documentation and status reports.
Assists Senior Developers with requests and/or components of larger projects with appropriate documentation and status reports.
Obtains and maintains Data Model and/or reporting tools certifications or training as needed.
Maintains current knowledge via self-study for reporting tools and reporting programming techniques.
Responds promptly to all problems, keeping in mind the computing environment supports a user community that requires access to critical patient care and business information 24 hours a day, 7 days a week.
Other duties as assigned.