Job Title : Data Engineer
Department : Data Engineering
Location: 100% remote available
As a LabCorp Employer Services Data Engineer you will be a highly versatile backend developer for our information systems, supporting data needs of our web applications, ETL processes, data orchestration, automation and report development. You will work closely with operational teams across the business to support client onboarding data activities and reporting configuration, as well as design, build and release new features and functionality in strong collaboration with the software engineering and QA teams. You are a collaborative, open-minded and strategic problem solver who excels at learning new skills and putting them to use, including leveraging new design paradigms, languages and Cloud services.
As a member of a cross-functional Agile delivery team you will closely collaborate with your team and product stakeholders to deliver scalable data solutions ready to meet the rapid demands of our growing business.
What You Will Be Doing:
Design and develop data report extracts, processes and comprehensive systems to support the needs of the business and functionality of web applications.
Build automated data ingestion and ETL processes utilizing SSIS, T-SQL, SQL agent jobs, Python and Azure Cloud Services.
Develop and maintain complex matching logic systems and stored procedures for merging inbound patient results data from flat files or staging tables to existing patient profile records.
Continuously fine tune and optimize data integration systems to promote stability and eliminate exceptions requiring human intervention.
Work with business and client liaisons to create standardized approaches to data sharing and integration.
Quickly identify and resolve production issues related to data matching, ingestion merge or reporting export.
Document data workflow diagrams for major services.
Build and manage monitoring systems and tests for production data quality.
Build data systems and processes to enable easy troubleshooting and exception reconciliation by the Data Ops team.
Develop procedures to enhance reporting and query capabilities to improve efficiency and accuracy.
Design and build data visualizations, interactive dashboards and report extracts to support the internal business and clients.
Collaborate with application development team on database architecture and processes to support various LabCorp Employer Services internal and client facing applications.