Posted in Information Technology 14 days ago.
This job brought to you by Local Organization
Location: Lexington, Kentucky
University of Kentucky
Equal Employment Opportunity/M/F/disability/protected veteran status.
ETL Developer Principal/UKHC
ETL Developer Principal
H3997:EVPHA Information Technology
Type of Position
Position Time Status
Click here for more information about equivalencies:
Required Related Experience
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.
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?
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 (*).