Data Warehouse Developer II

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 112

Compensation Range:

$70, $105,295.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 General Purpose provides a concise, high level overview of the role, level, and scope of responsibility consisting of 3-4 sentences. It provides a basic understanding of the job and a concise summary of why the job exists and how it makes an impact

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.

ESSENTIAL FUNCTIONS

• Essential Function
• 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.

MINIMUM EDUCATION & EXPERIENCE

• 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
• Experience with healthcare information systems preferred
  Experience with Epic Systems preferred

KNOWLEDGE, SKILLS AND ABILITIES

• 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

LICENSES AND CERTIFICATIONS

• EPIC - EPIC Certification upon hire preferred

The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the University's Mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.

Salary : $105,295