Data Engineer Lead

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. Job SummaryThe 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 SkillsProficiency in Structured Query Language (SQL)Experience working with EMR\EHR 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 toolsProficient working knowledge of database principles, processes, technologies and toolsExcellent analytical and troubleshooting skills.Strong sense of customer service to consistently and effectively address client needs.Excellent communication, leadership, and problem-solving skillsMentor 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 experienceExperience with processing HL7 messages, CCD documents, and EDI X12 Claims files.Familiarity with development methodologies, including the AGILE development approachesAbility to code and comprehend code around technologies that deal with acquiring dataWorking experience with Hadoop and other Big Data TechnologiesExperience in Microsoft Azure cloud solutions, architecture, and related technologiesEducation & Relevant ExperienceBachelor’s degree in technology, business, or healthcare related degree5+ 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.