University of Rochester Lead AP ETL Developer in Rochester, New York


Full Time 40 hours Grade 055 Info Systems SMH


8 AM-5 PM


Position Summary:

As a Lead AP ETL Developer for the URMC Enterprise Data Management team you will be responsible for the design, development, implementation, and support of various components for the data warehouse. Provide support for reporting projects as they relate to the URMC's Clinical and Revenue Cycle Data and other data, as well as, providing architectural recommendations, mentor staff, and work on projects as assigned by the Enterprise Data Management Team Lead.

This position will interact with multiple disciplines of the Medical Center including, but not limited to Clinical, Financial, Quality, Operations to insure data services needs are met. Primary responsibilities include administration of enterprise data systems by working closely with Application Reporting Leads, Data Analysts and IT Server Admins to build a foundation for integrated analytical applications/extracts in Crystal Reports, SQL tools (SSIS/SSRS/f-SQL), Epic Systems and reporting tools and/or Tableau and Tibco SpotFire. 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.


Database Development:

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

Extract/Data Set Development

  • Perform proper testing and validation techniques to insure accuracy and integrity of reported or extracted data and document the unit test and validation processes used
  • Develop new and support maintenance of existing reports and data sets contributing to maintaining the report inventory

Data Warehouse Design and Development

  • Understand and learn EMR workflows to translate between the transactional systems and the data repository
  • Develop standard dimensional data model optimized for performance and ease of reporting
  • Develop integrated administration tools for managing and monitoring the Data Warehouse

Independently Managing Projects and Requests

  • Works with clinical, financial and business requirements related to reporting applications support for the UR Medicine eco-system of applications
  • Manage requests and/or components of larger projects with appropriate documentation and status reports
  • Responds to, solves and makes decisions on more complex/non-routine business requests with limited to moderate risk
  • Responsible for own work and contributing to the team, department and organizational results
  • Assess and estimate requests to determine scope and efforts
  • Respond 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 Responsibilities:

  • Obtain and maintain 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
  • Provide on call support as needed for business continuity and operations


Bachelor's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering, and 4-5 years of related experience, preferably 2-3 years in a supervisory capacity; or an equivalent combination of education and experience

Preferred Qualifications:

  • 5 years relevant work experience
  • 5 years of business analysis experience
  • 3 years of report development experience
  • Proven ability to work professionally and progressively in a matrix organization
  • Proven business process design and development skills
  • Proven analytical and problem solving skills
  • Proven customer service orientation and excellent communication skills
  • Proven ability to work under pressure in a fast paced environment
  • Ability and initiative to learn new technologies
  • Must have an understanding of relational data bases and star schemas
  • Possess ability to analyze workflow and process build and changes and utilize technology to perform complex data analysis

Technical Skills

  • All Microsoft Office (including Office and Visio)
  • SQL experience (MSSQL Server) – Required
  • Must be proficient in Microsoft SQL Management and Business Intelligence Studio
  • Report Development experience (SQL, SSRS, Crystal Reports, Tableau, SpotFire preferred)
  • Healthcare information systems experience
  • Experience with Epic Systems preferred

EOE Minorities/Females/Protected Veterans/Disabled

Job Title: Lead AP ETL Developer

Location: Strong Memorial Hospital

Job ID: 211253

Regular/Temporary: Regular

Full/Part Time: Full-Time