Department Name: H3997:EVPHA Information Technology
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.
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.
Position Time Status: Full-Time
Required Related Experience:
Required License/Registration/Certification :
Master's degree preferred.
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.
Adjacent to downtown Lexington, UK is nestled in the scenic heart of the beautiful Bluegrass Region of Kentucky. UK's campus covers more than 814 acres, with more than 30,700 students and 13,500 full-time employees, including nearly 2,400 full-time faculty and librarians.