Data Test Lead - DBT Automation

<h3><strong>Role Overview</strong></h3><p>We are seeking an experienced <strong>Data Test Lead</strong> to drive testing strategy and automation for a large-scale <strong>Snowflake-based data transformation program</strong> within the <strong>insurance industry</strong>.</p><p>You will lead end-to-end data testing across a complex ecosystem integrating <strong>15 source systems</strong> into a modern data platform built on <strong>Staging, Data Vault, and Consumption layers</strong>, with downstream BI in <strong>Power BI and Sigma</strong>.</p><p>This is a hands-on leadership role combining <strong>test strategy, automation, and data quality engineering</strong>.</p><h3><strong>Key Responsibilities</strong></h3><ul><li><p>Lead a <strong>virtual, multi-cultural testing team</strong>, including client-side testers</p></li><li><p>Drive implementation and continuous refinement of the <strong>data test strategy</strong> as the project evolves</p></li><li><p>Design and execute <strong>comprehensive test plans</strong> covering:</p><ul><li><p>Data ingestion</p></li><li><p>Data transformation</p></li><li><p>Consumption/reporting layers</p></li></ul></li><li><p>Ensure <strong>data completeness, accuracy, and timeliness</strong> across the platform</p></li><li><p>Own and expand <strong>test automation frameworks</strong> for data validation</p></li><li><p>Integrate automated tests into <strong>CI/CD pipelines</strong> using GitHub workflows</p></li><li><p>Collaborate closely with:</p><ul><li><p>Data Engineers</p></li><li><p>Developers</p></li><li><p>DevOps</p></li><li><p>Data Analysts</p></li><li><p>Data Stewards</p></li><li><p>Business stakeholders</p></li></ul></li><li><p>Define test requirements, acceptance criteria, and quality gates</p></li><li><p>Coach and guide the testing team on tools, methodologies, and best practices for Snowflake and insurance data environments</p></li></ul><h3><strong>Project &amp; Technical Environment</strong></h3><ul><li><p><strong>Data Platform:</strong> Snowflake</p></li><li><p><strong>Architecture:</strong> Staging → Data Vault (Hubs, Links, Satellites) → Consumption</p></li><li><p><strong>BI/Analytics:</strong> Power BI, Sigma</p></li><li><p><strong>Orchestration &amp; DevOps:</strong> Airflow, GitHub Actions</p></li><li><p><strong>Testing &amp; Data Quality:</strong></p><ul><li><p><strong>dbt (core skill)</strong> – data build, testing &amp; automation</p></li><li><p>Python (test automation, validation scripts)</p></li><li><p>SQL (advanced querying &amp; validation)</p></li><li><p>Soda Core (data quality checks)</p></li><li><p>DQ Labs (data profiling &amp; monitoring)</p></li><li><p>BDD with Behave</p></li><li><p>Jira (test management), Confluence (documentation)</p></li></ul></li></ul><h3><strong>Required Skills &amp; Experience</strong></h3><ul><li><p>Proven experience as a <strong>Test Lead in data transformation / data platform projects</strong></p></li><li><p>Strong ability to <strong>lead distributed, cross-cultural teams</strong></p></li><li><p>Hands-on background in <strong>testing and automation</strong></p></li><li><p><strong>DBT automation expertise</strong> (data models, structures, test implementation)</p></li><li><p>Strong <strong>SQL</strong> and <strong>Python</strong> skills</p></li><li><p>Solid understanding of <strong>ETL/ELT processes</strong> and Snowflake (no deep engineering required)</p></li><li><p>Experience with <strong>Data Vault modeling</strong> (Hubs, Links, Satellites)</p></li><li><p>Familiarity with <strong>CI/CD-driven test automation</strong></p></li><li><p>Experience working in <strong>Agile/DevOps environments</strong></p></li></ul>