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