Job Title: Data Testing Specialist Test Lead
Location: Boston, MA
Lead comprehensive data testing and validation for Snowflake, DBT, and MDM solutions. Ensure data accuracy, consistency, and trustworthiness across pipelines, models, and enterprise systems using automation tools like DVS, Power Queries, and VBS.
Skill Priority: Spotfire, Snowflake, dbt (mandatory)
Role Summary
You will architect endtoend testing strategies for complex data pipelines, validate Snowflake/DBT transformations, MDM solutions, and data quality using advanced automation tools. This role demands handson expertise in Snowflake and DBT, with strong collaboration across data engineers, analysts, and stakeholders to drive data governance and quality.
Key Responsibilities
- Execute comprehensive, endtoend testing of data pipelines, transformations, and integrations to guarantee data accuracy, reliability, and consistency.
- Validate data against defined business rules, requirements, and expected outputs, proactively identifying gaps and improvement opportunities.
- Detect, document, and report on data quality issues, inconsistencies, and anomalies, driving timely resolution.
- Test and validate data pipelines and transformations developed in Snowflake and DBT, ensuring alignment with performance, scalability, and quality standards.
- Assess and validate DBT data models, confirming correct implementation of complex business logic.
- Conduct rigorous testing and validation of MDM solutions, ensuring adherence to data governance and quality standards.
- Verify master data accuracy and consistency across multiple enterprise systems.
- Utilize automation tools (DVS, Power Queries, VBS) to maximize efficiency and coverage of data testing processes.
- Design, implement, and maintain robust automated test scripts, reducing manual effort and supporting continuous integration.
- Collaborate closely with data engineers, analysts, and business stakeholders to fully understand data requirements and deliver optimal testing solutions.
- Develop and maintain thorough documentation of test cases, results, and data quality reports to promote transparency and organizational learning.
- Provide actionable feedback and recommendations to enhance data quality and testing methodologies.
- Architect comprehensive data validation and testing strategies for complex data pipelines and integration projects.
- Leverage Tableau and Power BI for data validation, visualization, and reporting.
- Automate complex data comparisons and validations between source and target systems, utilizing accelerators and bestinclass automation tools.
- Manage code versioning, branching, and reviews through Git and Bitbucket.
- Actively participate in Agile ceremonies; use JIRA and Confluence to track progress and maintain project documentation.
- Champion a culture of continuous improvement by systematically documenting, analyzing, and addressing test cases, results, and data quality issues.
Required Skills and Experience
- Must be based in Boston, MA.
- Demonstrated, handson expertise with Snowflake and DBT (DBT is mandatory).
- Strong command of Master Data Management (MDM) concepts and bestinclass validation methodologies.
- Proven experience in data profiling, validation, and automated data comparison.
- Advanced proficiency with automation tools, including Data Validation Suite, Power Queries, VBS, Tableau, or Power BI.
- Practical knowledge of Git/Bitbucket for version control, branching, and code review.
- Working familiarity with Agile methodologies and tools such as JIRA and Confluence.
- Exceptional analytical, problemsolving, and communication abilities; able to convey complex data quality issues to both technical and nontechnical audiences.
Preferred Qualifications
- Experience in cloudbased data environments (e.g., AWS, Azure, Google Cloud Platform).
- Exposure to enterprise data governance and data quality frameworks.
Keywords: Data Testing Specialist, Test Lead, Snowflake, dbt, Data Build Tool, Spotfire, Master Data Management, MDM, data pipelines, data transformations, data integrations, data accuracy, data quality, data validation, business rules, data profiling, automated data comparison, Data Validation Suite, DVS, Power Queries, VBS, Visual Basic Scripting, Tableau, Power BI, Git, Bitbucket, version control, code review, Agile, JIRA, Confluence, data governance, data quality frameworks, cloud data, AWS, Azure, Google Cloud Platform, end-to-end testing, test scripts, continuous integration, stakeholder collaboration, data quality reports, problem-solving, communication
About VDart Group
VDart Group is a global leader in technology, product, and talent solutions, serving Fortune 500 clients in 13 countries. With over 4,000 professionals worldwide, we deliver innovation, operational excellence, and measurable outcomes across industries. Guided by our commitment to People, Purpose, and Planet, VDart is recognized with an EcoVadis Bronze Medal and as a UN Global Compact member, reflecting our dedication to sustainable practices.