Software Development Engineer in Test, Sr

About Us

We are Health Catalyst, a leading provider of data and analytics technology and services to healthcare organizations. Our mission is to be the catalyst for massive, measurable, data‑informed healthcare improvement. We partner with health systems, hospitals, and other healthcare entities to help them use data to make smarter decisions, improve clinical outcomes, reduce costs, and enhance patient experience. Joining Health Catalyst means becoming part of a team dedicated to transforming healthcare through innovation, collaboration, and a relentless focus on value.

Automation Test Engineer (SDET)

We are seeking an Automation Test Engineer (SDET) to ensure the quality, reliability, and accuracy of both application and data platform solutions. This role goes beyond traditional QA, with a strong focus on data validation, ETL testing, and database integrity within a scalable healthcare SaaS environment. You will work closely with data engineers, developers, and product teams to validate complex data pipelines, ensuring high‑quality data delivery across systems.

Key Responsibilities

• Design and implement automated tests across web, API, and data platforms
• Validate data pipelines, ETL/ELT processes, and data integrations, ensuring accuracy and completeness
• Perform deep database testing, including schema validation, transformation logic, and stored procedure validation
• Write complex SQL queries for data validation, reconciliation, and root cause analysis
• Define and execute data quality checks, including data consistency, lineage, and reporting accuracy
• Test data ingestion, mapping logic, and downstream data consumption across systems
• Collaborate with engineering and product teams to translate business requirements into testable data scenarios and validation rules
• Identify, investigate, and resolve complex data issues across large‑scale datasets
• Build and maintain automation frameworks for API, ETL, and end‑to‑end workflows
• Integrate tests into CI/CD pipelines to enable continuous testing
• Contribute to test data management, environment setup, and documentation
• Promote quality best practices with a focus on scalability, reliability, and data integrity

Required Qualifications

• 4+ years of experience in QA with strong focus on test automation and data testing
• Strong SQL expertise, including joins, aggregations, and data validation across large datasets
• Hands‑on experience with database testing (RDBMS systems like SQL Server, PostgreSQL, etc.)
• Experience testing ETL/ELT pipelines and data workflows
• Experience with automation tools (Selenium, Cypress, Playwright, etc.)
• Experience with API testing (Postman, REST Assured, etc.)
• Programming experience (Java, C#, or JavaScript)
• Familiarity with CI/CD tools and Git
• Understanding of Agile/Scrum methodologies

Nice to Have

• Experience testing data products and analytics platforms
• Hands‑on experience with Databricks, Spark, or big data ecosystems
• Exposure to data warehousing concepts and large‑scale OLTP/OLAP systems
• Experience with cloud platforms (Azure/AWS)
• Knowledge of healthcare data standards (HL7, FHIR)
• Performance or data pipeline testing experience
• Familiarity with data mapping, transformation validation, and pipeline monitoring

What We Value

• Strong analytical and problem‑solving skills, especially with complex data
• Attention to detail and passion for data accuracy
• Ability to work across engineering and data teams
• Ownership mindset with focus on end‑to‑end quality
• Continuous learning and improvement

Equal Employment Opportunity

Equal Employment Opportunity has been, and will continue to be, a fundamental principle at Health Catalyst, where employment is based upon personal capabilities and qualification without discrimination or harassment on the basis of race, color, national origin, religion, sex, sexual orientation, gender identity, age, disability, citizenship status, marital status, creed, genetic predisposition or carrier status, sexual orientation or any other characteristic protected by law. Health Catalyst is committed to a work environment where all individuals are treated with respect and dignity.