Software Development Engineer

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​

Role Overview

Key Responsibilities

• - Design, develop, and maintain ETL/ELT pipelines for large-scale data ingestion, transformation, and loading
• - Build and optimize data warehouse solutions in Snowflake for analytics and reporting use cases
• - Work with AWS services including:
• - AWS Glue
• - AWS Lambda
• - AWS SNS
• - AWS S3
• - Support integration with additional cloud technologies and data platforms as needed
• - Develop and manage event-driven and streaming workflows using Kafka (basic to medium level)
• - Implement and maintain Snowflake capabilities such as: - RBAC and ABAC - Snowpipes - Dynamic Tables - Write efficient SQL queries for transformation, validation, and analytics - Develop Python-based automation scripts and data processing logic - Build and orchestrate workflows using Airflow /Step Functions - Ensure data quality, consistency, and operational reliability across pipelines - Troubleshoot production issues and improve system performance, scalability, and maintainability - Collaborate with cross-functional teams to gather requirements and implement practical technical solutions - Document data architecture, process flows, and operational procedures

Required Skills

• - 2–4 years of experience in software development, data engineering, or related roles
• - Strong understanding of ETL/ELT processes and data warehousing concepts
• - Hands-on knowledge of:
• - AWS Glue
• - AWS Lambda
• - AWS SNS
• - AWS S3
• - Working knowledge of Kafka (basic to medium level)
• - Proficiency in SQL and Python
• - Fundamentals of Snowflake:
• - RBAC
• - ABAC
• - Snowpipes
• - Dynamic Tables
• - Experience with Airflow for workflow orchestration
• - Basic to moderate exposure to other cloud technologies and services
• - Strong analytical, debugging, and problem-solving abilities
• - Strong critical thinking and a team-first mindset
• Desired Skills (Not Mandatory)
• - Familiarity with Pentaho for ETL/data integration workflows
• - Exposure to additional cloud services such as:
• - AWS EMR
• - Redshift
• - Athena
• - Step Functions
• - IAM / CloudWatch / EventBridge
• - Familiarity with distributed systems, data lakes, and streaming architectures
• - Understanding of data governance, security, and access controls in cloud environments

Behavioral Competencies

Educational Qualification

• - Bachelor’s degree in Computer Science , Information Technology, Engineering, or a 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 .
• 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.