Data Test Lead - DBT Automation

Role Overview

We are seeking an experienced Data Test Lead to drive testing strategy and automation for a large-scale Snowflake-based data transformation program within the insurance industry.

You will lead end-to-end data testing across a complex ecosystem integrating 15 source systems into a modern data platform built on Staging, Data Vault, and Consumption layers, with downstream BI in Power BI and Sigma.

This is a hands-on leadership role combining test strategy, automation, and data quality engineering.

Key Responsibilities

• Lead a virtual, multi-cultural testing team, including client-side testers

• Drive implementation and continuous refinement of the data test strategy as the project evolves

• Design and execute comprehensive test plans covering:

  • Data ingestion

  • Data transformation

  • Consumption/reporting layers

• Ensure data completeness, accuracy, and timeliness across the platform

• Own and expand test automation frameworks for data validation

• Integrate automated tests into CI/CD pipelines using GitHub workflows

• Collaborate closely with:

  • Data Engineers

  • Developers

  • DevOps

  • Data Analysts

  • Data Stewards

  • Business stakeholders

• Define test requirements, acceptance criteria, and quality gates

• Coach and guide the testing team on tools, methodologies, and best practices for Snowflake and insurance data environments

Project & Technical Environment

• Data Platform: Snowflake

• Architecture: Staging → Data Vault (Hubs, Links, Satellites) → Consumption

• BI/Analytics: Power BI, Sigma

• Orchestration & DevOps: Airflow, GitHub Actions

• Testing & Data Quality:

  • dbt (core skill) – data build, testing & automation

  • Python (test automation, validation scripts)

  • SQL (advanced querying & validation)

  • Soda Core (data quality checks)

  • DQ Labs (data profiling & monitoring)

  • BDD with Behave

  • Jira (test management), Confluence (documentation)

Required Skills & Experience

• Proven experience as a Test Lead in data transformation / data platform projects

• Strong ability to lead distributed, cross-cultural teams

• Hands-on background in testing and automation

• DBT automation expertise (data models, structures, test implementation)

• Strong SQL and Python skills

• Solid understanding of ETL/ELT processes and Snowflake (no deep engineering required)

• Experience with Data Vault modeling (Hubs, Links, Satellites)

• Familiarity with CI/CD-driven test automation

• Experience working in Agile/DevOps environments