ETL Developer Principal/UKHC at University of Kentucky

Posted in Information Technology 14 days ago.

This job brought to you by Local Organization

Location: Lexington, Kentucky

Job Description:

University of Kentucky

Equal Employment Opportunity/M/F/disability/protected veteran status.

Posting Details

Job Title

ETL Developer Principal/UKHC

Requisition Number


Working Title

ETL Developer Principal

Department Name

H3997:EVPHA Information Technology

Work Location

Lexington, KY

Grade Level


Salary Range


Type of Position


Position Time Status


Required Education


Click here for more information about equivalencies:

Required Related Experience

7 yrs

Required License/Registration/Certification


Physical Requirements

The physical requirements of this position include: Occasional lifting, pushing, and/or pulling objects up to 50lbs; occasional standing or walking with objects 10-25lbs; intermittently sitting at a computer workstation for extended periods of time with intermittent repetitive motions (such as typing); occasional exposure to loud noises; and occasional job related travel (


Monday through Friday, 8:00 am - 5:00 pm, with some evenings, nights, and weekends required per business needs.

Job Summary

The ETL Developer Principal for UK HealthCare's Performance Analytics Center of Excellence is a critical role in the transformational change at UK HealthCare to enable advanced analytics and business intelligence to function as core infrastructure in support of data as a strategic asset.

The ETL Developer Principal will oversee the effective enterprise-wide data extraction, transformation and loading of data from source systems to the enterprise data warehouse, and from the data warehouse to data marts that are used to provide analytics capabilities to UK HealthCare analytics users. This role is responsible for leading the development, coordination, and implementation of the ETL work activity for projects. The position will include development of technical best practices for data movement, quality, cleansing, and other ETL activities.

This role will also serve as the lead designer of all ETL activities for specific projects; work closely with data architects, database administrators, and BI team members to meet business and data requirements; and coordinate ETL development task plans for PACE projects.

The ETL Developer Principal will lead in the development of the data layer and perform checkpoints and reviews on presentation layer designs and code, ensuring standards are applied in all deliverables. This position reports to the UK HealthCare Performance Analytics Center of Excellence Data Management Director.

UK HealthCare is a comprehensive healthcare system consisting of the medical, nursing, health sciences, public health, dental and pharmacy patient care activities of the University of Kentucky in Lexington, KY, and in several off-site locations. UK HealthCare is expanding through the construction of a new hospital and potential future acquisitions. All UK HealthCare employees commit to providing excellent service and promoting a positive image while adhering to UK HealthCare Behavioral Expectations and Standards which include being customer centered, service focused, quality driven, resource wise, and growth oriented.

Skills / Knowledge / Abilities

The qualified candidate will have demonstrated experience in designing, developing, troubleshooting, and fine-tuning ETL processes in order to satisfy business requirements. Must have experience analyzing business requirements and developing appropriate test cases to perform Quality Assurance on the ETL code developed; and experience writing stored procedures (T- SQL , PL/ SQL ) and complex queries in relational databases. The ideal candidate will have a strong background in the IBM suite of tools for data warehousing, including IBM Infosphere and IBM DataStage, as well as experience with the Microsoft BI stack ( SSIS , SSAS , MS- SQL ). Also has extensive experience in ETL coding and data integration validation; strong written and verbal communication skills; and experience in the healthcare industry and knowledge of regulatory requirements such as HIPAA . Experience with developing ETLs in Epic is preferred.

Does this position have supervisory responsibilities?


Preferred Education/Experience

Master's degree preferred.

Deadline to Apply


University Community of Inclusion

The University of Kentucky is committed to a diverse and inclusive workforce by ensuring all our students, faculty, and staff work in an environment of openness and acceptance. We strive to foster a community where people of all backgrounds, identities, and perspectives can feel secure and welcome. We also value the well-being of each of our employees and are dedicated to creating a healthy place to work, learn and live. In the interest of maintaining a safe and healthy environment for our students, employees, patients and visitors the University of Kentucky is a Tobacco & Drug Free campus.

As an Equal Opportunity Employer, we strongly encourage veterans, individuals with disabilities, women, and all minorities to consider our employment opportunities.

Any candidate offered a position may be required to pass pre-employment screenings as mandated by University of Kentucky Human Resources. These screenings may include a national background check and/or drug screen.

Posting Specific Questions

Required fields are indicated with an asterisk (*).

  1. * Please describe a project where you had to develop a data model based on business needs. What were the barriers to success? What did you do to overcome the barriers?
    (Open Ended Question)
  2. * Please describe an experience working with database management and data modeling.
    (Open Ended Question)
  3. * University of Kentucky HealthCare recognizes a set of values that guide us in our daily interactions. By applying for a position within UK Healthcare, you are indicating your commitment and expressing your agreement to our five values. These values are diversity, innovation, respect, compassion, and teamwork. Please choose one of the UK Healthcare values and give a specific example when you exhibited this quality in your professional experience.
    (Open Ended Question)
  4. * University of Kentucky HealthCare seeks to attract, develop and retain highly skilled and competent employees, to provide the best experience for every patient, every time. If selected for a position, do you agree to abide by the UK HealthCare Values of diversity, innovation, respect, compassion, and teamwork?
    • Yes
    • No
  5. * Where did you first see this position advertised other than on UK's online employment system?
    • (Diverse Issues in Higher Education)
    • (Higher Education Recruitment Consortium)
    • Institute for Diversity in Health Management
    • A Colleague, Friend and/or Family Member
    • None of the Above

Applicant Documents

Required Documents
  1. Resume
  2. Cover Letter
Optional Documents