Jobs · Engineering · California

Senior Software Development Engineer in Test (SDET), Data

Ellipsis Health · San Francisco, CA · 1 wk ago
HybridEngineeringFull-time

Key Responsibilities

  • Perform both manual (functional) testing and automation for data pipelines, APIs, and AI-driven workflows
  • Understand business logic using SQL and scripting (e.g., Python) to design comprehensive test scenarios
  • Design, develop, and execute functional test plans, test cases, and test scripts for ETL pipelines, ensuring data accuracy, integrity, and completeness
  • Build and maintain automation frameworks for ETL, API, and workflow testing to improve coverage and efficiency
  • Validate data transformations, mappings, and data loads across all stages of the ETL lifecycle
  • Conduct manual validation for critical workflows and edge cases where automation is not sufficient
  • Identify, document, and track defects; collaborate closely with engineering teams to resolve issues
  • Conduct root cause analysis for data discrepancies and contribute to quality metrics and reporting
  • Lead functional validation efforts and support test environment setup for data pipelines and workflows
  • Collaborate with Implementation/Onboarding teams to triage production data issues and improve test coverage
  • Validate healthcare-specific data models for compliance with regulatory and business requirements
  • Participate in Agile ceremonies, providing QA input during sprint planning, grooming, and retrospectives
  • Support production releases, hotfix validation, and post-deployment verification, ensuring minimal impact to customers

Required Qualifications

  • 5+ years of experience in SDET or QA roles with a strong mix of functional testing and automation
  • Strong understanding of ETL testing, data validation, and data quality assurance practices
  • Proficiency in SQL for data validation, reconciliation, and test design
  • Hands-on experience with Databricks, Apache Spark, or similar data platforms
  • Experience with DAG/workflow orchestration tools such as Apache Airflow or Databricks Workflows
  • Experience building and maintaining test automation frameworks (e.g., Playwright, Cypress, Selenium)
  • Experience with API testing tools such as Postman, RestAssured, or similar
  • Strong knowledge of QA methodologies, test design techniques, and defect tracking processes
  • Experience working in Agile/Scrum environments
  • Experience testing systems that incorporate Machine Learning models, Speech-to-Text, or Text-to-Speech systems
  • Strong analytical and problem-solving skills with attention to detail
  • Excellent communication and collaboration skills
  • Experience creating test plans, test strategies, and quality processes for data/ETL releases
  • Basic understanding of LLMs and AI-driven features, including how to test them effectively

Nice to Have

  • Experience in healthcare or regulated environments, especially with ETL workflows
  • Knowledge of healthcare data standards such as HIPAA, HL7, or FHIR
  • Strong experience with PostgreSQL and database testing for reporting and ETL validation
  • Familiarity with cloud data platforms such as Snowflake, Redshift, or BigQuery
  • Exposure to monitoring and logging tools like Splunk, Datadog, or similar
  • Experience with data visualization tools like Tableau, Power BI, or Looker for validating reporting layers
  • Experience using scripting (e.g., Python, Shell) for automation and data validation
  • Familiarity with testing considerations for LLMs and GenAI systems

Similar jobs