Experience Inc. Jobs

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):

Remote Work - New York, Albany, New York, United States of America, 12224

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 111

Compensation Range:

$63,815.00 - $95,723.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:

GENERAL PURPOSE:

A Data Warehouse Engineer I for the URMC Enterprise Data Management team will be responsible for the design, development, implementation, and support of various components for the enterprise data warehouse and associated data sources. Additionally this position provides support for reporting projects as they relate to the URMC’s Clinical, Revenue Cycle Data, Quality and Research areas, and work on projects as assigned by the Enterprise Data Management Team Assistant Director or Manager.

This position will interact with multiple disciplines of the Medical Center including, but not limited to Clinical, Financial, Quality, Research, Operations to insure data services needs are met. Primary responsibilities include support of enterprise data systems by working closely with Data Analysts and IT Server Administrators to build a foundation for integrated analytical applications/extracts in SQL tools (SSIS/SSRS/T-SQL), Virtual and Physical data warehousing, Epic Systems and reporting BI tools. Other responsibilities include adherence to change management and control, service requests intake documentation and process documentation. Assignment of additional projects and requests to perform analysis and programming addressing challenging tasks may be assigned as needed.

ESSENTIAL FUNCTIONS

• Develops SQL Server by understanding the security model and schema objects including tables, indexes and applied constraints, functions, stored procedures, Views and advances T-SQL programming. Implements ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse with guidance.

• Performs proper testing and validation techniques to insure 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 UR Medicine 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 and/or maintain 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.

QUALIFICATIONS

• Associate’s degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required.

• 2 years of relevant experience required.

• Equivalent combination of education and experience required.

• TSQL experience (MSSQL Server) required.

• Report Development experience (one or more of SQL, SSRS, Crystal Reports, Tableau, Spotfire) required.

• Experience with healthcare information systems preferred.

• Experience with Epic Systems preferred.

• 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 Management and Business Intelligence Studio required.

• Epic Systems Cogito or Clarity and Caboodle preferred.

EOE Minorities / Females / Protected Veterans / Disabled:

The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion 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 status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.

Notice: If you are a Current Employee, please log into myURHR to search for and apply to jobs using the Jobs Hub. Your application, if submitted using this portal, cannot be moved forward.

Learn. Discover. Heal. Create.

Located in western New York, Rochester is our namesake and our home. One of the world’s leading research universities, Rochester has a long tradition of breaking boundaries—always pushing and questioning, learning and unlearning. We transform ideas into enterprises that create value and make the world ever better.

If you’re looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goals

At the University of Rochester, we commit to diversity, equity, and inclusion and united by a strong commitment to be ever better—Meliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.