Lead Data Engineer

The healthcare industry is the next great frontier of opportunity for software development, and Health Catalyst is one of the most dynamic and influential companies in this space. We are working on solving national-level healthcare problems, and this is your chance to improve the lives of millions of people, including your family and friends. Health Catalyst is a fast-growing company that values smart, hardworking, and humble individuals. Each product team is a small, mission-critical team focused on developing innovative tools to support Catalyst's mission to improve healthcare performance, cost, and quality.

Health Catalyst is expanding and maintains a large suite of Improvement Apps that contribute to healthcare analytics and process improvement solutions. This includes products that manage the care of health system populations, better serve patients at the point of care, reduce health system costs, and reduce clinician workload.

Job Summary

The Data Engineer focuses on acquiring data from various sources that are found in a Health System's ecosystem. The Data Engineer leverages Catalyst's Data Operating System to acquire this data. Data Engineers become accustomed to both the technical and business details of the source systems and engage with multiple technologies on how to acquire the source data.

Duties & Responsibilities

Required Skills

• Proficiency in Structured Query Language (SQL)
• Experience working with EMREHR systems and an understanding of the healthcare clinical domain.
• Lead the design, development, and maintenance of scalable data pipelines and ETL processes.
• Strong expertise in ETL tools
• Proficient working knowledge of database principles, processes, technologies and tools
• Excellent analytical and troubleshooting skills.
• Strong sense of customer service to consistently and effectively address client needs.
• Excellent communication, leadership, and problem-solving skills
• Mentor and guide a team of data engineers, fostering a culture of continuous learning and improvement.
• Monitor and troubleshoot data infrastructure issues to ensure high availability and performance.
• Ensure data quality, integrity, and security across all data platforms.
• Implement best practices for data governance, lineage, and compliance

Desired Skills

• Prior experience with RDBMS (SQL Server, Oracle, etc.)
• Stored Procedure/T-SQL/SSIS experience
• Experience with processing HL7 messages, CCD documents, and EDI X12 Claims files.
• Familiarity with development methodologies, including the AGILE development approaches
• Ability to code and comprehend code around technologies that deal with acquiring data
• Working experience with Hadoop and other Big Data Technologies
• Experience in Microsoft Azure cloud solutions, architecture, and related technologies

Education & Relevant Experience

• Bachelor's degree in technology, business, or healthcare related degree
• 5+ years of experience in data engineering, with at least 2+ years in a leadership role.
• 2+ years of experience in healthcare/technology related field.

The above statements describe the general nature and level of work being performed in this job function. They are not intended to be an exhaustive list of all duties, and indeed additional responsibilities may be assigned by Health Catalyst.