Job Title: Data Engineer
Location: Salt Lake City, UT
Travel: Approximately 10%
Open date: 10/23/18
Close date: TBD
About Health Catalyst
Health Catalyst has been named as one of the 30 Best Workplaces in Technology by Fortune Magazine and a winner of Gallup Great Workplace award. Health Catalyst earned the highest overall score in Healthcare BI by KLAS and, for the sixth year in a row, was named to the Best Places to Work in Healthcare list by Modern Healthcare. Health Catalyst analyzes healthcare records of almost a third of the US population (65 million patients) and recently released the first open source software for healthcare machine learning: healthcare.ai.
Health Catalyst's platform and applications are being used at leading health systems including, John Muir Health, UPMC, MultiCare Health System, Partners HealthCare, Banner Health, Stanford Hospital & Clinics, Texas Children's Hospital, and over 40 others. Health Catalyst products and services are utilized in over 400 hospitals and 4000 clinics, supporting over 90 million patients.
Our team lives the cultural attributes of Smart, Hardworking and Humble. Learn more about working at Health Catalyst here: https://www.healthcatalyst.com/company/careers/key-health-catalyst-values.
The Data Engineer focuses on acquiring data from various sources that are found in a Health System's ecosystem. The Data Engineer leverages the 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
Oversees bringing new source systems into the Catalyst's Data Operating System
Ability to dig into the data and understand business processes within the source system data
Identify ways to innovate and extend functionality into the Catalyst's Data Operating System
Perform data validation tests to ensure quality
Balance tasks and priorities between multiple client projects and internal initiatives; ensure assigned tasks are executed efficiently and according to project requirements and timelines
Work with client's data architects to train and mentor
All other duties as assigned
Intermediate level in Structured Query Language (SQL)
Experience working with EMR\EHR systems and an understanding of the healthcare clinical domain
Exposure to Extract, Transform and Load (ETL) concepts and processes
Excellent analytical and troubleshooting skills
Strong sense of customer service to consistently and effectively address client needs
Ability to coordinate and communicate effectively with other team members
Self-motivated; comfortable working under general direction
Working knowledge of database principles, processes, technologies and tools
Ability to take pride in the quality, details, efficiency, and consistency of the data warehouse components you'll be helping build, deploy, and maintain at scale.
Prior experience with RDBMS (SQL Server, Oracle, etc)
Stored Procedure/T-SQL 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
Experience working with Hadoop and other Big Data Technologies
Exposure to C#
Education & Relevant Experience
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.