Sr Data Engineer- Integrations

Requirements

• 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 .
• 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

Benefits

Additional Information

Join one of the nation's leading and most impactful health care performance improvement companies. Over the years, Health Catalyst has achieved and documented clinical, operational, and financial improvements for many of the nation's leading healthcare organizations. We are also increasingly serving international markets. Our mission is to be the catalyst for massive, measurable, data-informed healthcare improvement through: 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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at healthcatalyst? Share your experience