- Data: integrate data in a flexible, open & scalable platform to power healthcare’s digital transformation
- Analytics: deliver analytic applications & services that generate insight on how to measurably improve
- Expertise: provide clinical, financial & operational experts who enable & accelerate improvement
- Engagement: attract, develop and retain world-class team members by being a best place to work
Job Description
Job Title: Sr Data Engineer- Integrations
Department: Data Platform Operations & Engineering
Status: Full-time
Job Summary
This role should be able to design and implement scalable data warehouse solutions by integrating client data with the Ignite platform, aligning to Health Catalyst architecture and standards. Lead SQL Server to Databricks migrations, including schema mapping, query optimization, and data validation. Develop and maintain data products using dbt, ensuring high data quality, documentation, and alignment with client analytics needs. Communicate project status and risks effectively to stakeholders and leadership, ensuring successful implementation outcomes. Drive knowledge transfer and training for client teams while supporting internal tooling improvements and onboarding data engineers.
Required Skills
Must possess deep technical experience with several technical competencies; data query (SQL), data movement (ETL), data modeling, and working within cloud environments.
Ability to profile large datasets and interpret and analyze multiple data models quickly.
Strong communication, collaboration, and negotiation skills; ability to anticipate, diffuse and/or manage conflict resolution. Ability to guide and support other resources through tenuous situations.
Strong experience as a Data Engineer, Analytics Director, Technical Director, or similar role.
Advanced data modeling skills. Working knowledge of dimensional, 3rd Normal, and other data modeling standards and possess the ability to explain these concepts to technical and non-technical audiences.
Ability to interpret complex customer requests and implement them using Health Catalyst tools including DOS Marts, SAMs, SAM Designer, Source Mart Designer, Databricks, Visual Studio Code, etc.
Exceptional interpersonal, problem solving and time management skills.
Ability to learn new software tools/technologies quickly and ask for help or training when necessary.
Ability to make sound decisions on behalf of clients or peer groups aligned with the organization’s current goals, mission, and strategic priorities.
Experience migrating workloads from SQL Server to Databricks, including Spark SQL query translation, performance tuning, and data validation practices.
Hands-on experience with dbt for building, testing, and documenting data models; familiarity with dbt on Databricks preferred.
Desired Skills
DBA-experience optimizing Execution Plans.
Query profiling and optimization.
PowerShell scripting experience.
TSQL and/or procedure/function scripting experience.
Experience with Snowflake. (Note: Databricks experience is now a Required Skill.)
Python/Pyspark knowledge and experience
Education & Relevant Experience
Any Bachelors/master’s degree
Minimum 4–7 years relevant or equivalent 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.
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.
Studies show that candidates from underrepresented groups are less likely to apply for roles if they don’t have 100% of the qualifications shown in the job posting. While each of our roles have core requirements, please thoughtfully consider your skills and experience and decide if you are interested in the position. If you feel you may be a good fit for the role, even if you don’t meet all of the qualifications, we hope you will apply. If you feel you are lacking the core requirements for this position, we encourage you to continue exploring our careers page for other roles for which you may be a better fit.
At Health Catalyst, we appreciate the opportunity to benefit from the diverse backgrounds and experiences of others. Because of our deep commitment to respect every individual, Health Catalyst is an equal opportunity employer.
Skills Required
- Deep technical experience with data query (SQL), data movement (ETL), data modeling, and cloud environments
- Experience migrating workloads from SQL Server to Databricks including Spark SQL query translation, performance tuning, and data validation
- Hands-on experience building, testing, and documenting data models using dbt
- Ability to profile large datasets and interpret and analyze multiple data models quickly
- Advanced data modeling skills (dimensional, 3rd normal, other standards) and ability to explain concepts to technical and non-technical audiences
- Proficiency with Databricks and Spark (Databricks experience is required)
- Experience using Health Catalyst tools (DOS Marts, SAMs, SAM Designer, Source Mart Designer) and Visual Studio Code
- Strong communication, collaboration, negotiation, interpersonal, problem solving and time management skills
- Minimum 4-7 years relevant or equivalent experience
- Bachelor's or Master's degree
- DBA experience optimizing execution plans and query profiling/optimization
- PowerShell scripting experience
- T-SQL and stored procedure/function scripting experience
- Experience with Snowflake
- Python / PySpark knowledge and experience
- Familiarity with dbt on Databricks
Health Catalyst Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Health Catalyst and has not been reviewed or approved by Health Catalyst.
-
Healthcare Strength — Health coverage is described as comprehensive, including medical, dental, vision, mental-health support, wellness reimbursements, and programs like gym subsidies and fitness options. Feedback suggests the company manages plans proactively (including self-insurance) to enhance benefits such as primary care access and wellness incentives.
-
Leave & Time Off Breadth — Time off provisions are expansive, with flexible or unlimited PTO, a large holiday calendar, and paid volunteer and family leave. Feedback suggests the remote-first approach and supportive norms make it easier to take needed time without stigma.
-
Parental & Family Support — Family support includes paid parental leave and adoption assistance, with additional leave options that extend beyond typical offerings. Feedback suggests these policies help employees balance caregiving with work demands.
Health Catalyst Insights
What We Do
Health Catalyst is dedicated to enabling health care organizations to fundamentally improve care by building the most comprehensive and fully integrated suite of healthcare data warehousing and process improvement solutions available. Health Catalyst was formed by a group of healthcare veterans with vast data warehousing and quality improvement experience. Our founders and executives collaborated for nearly a decade to revolutionize clinical process models using analytics. During development, they faced numerous hurdles in the quest to develop a data warehouse that could handle the complexities unique to healthcare data. After determining that the predominant approaches to data modeling weren’t effective for healthcare data, they discovered the solution, which is now known as the Adaptive Data Architecture. Using a late-binding bus architecture, Catalyst’s adaptive data model is agile, flexible, and can be implemented in a matter of weeks compared to the months or years traditional approaches require. Today at Health Catalyst, you’ll work with a team of experts who know that healthcare needs to change—and have made the change it needs a reality. Transforming healthcare is our passion.
