Data Testing Specialist – Test Lead

Role: Data Testing Specialist Test Lead.

Location: Boston MA (Onsite).
Duration: Long Term Contract.

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 end to end testing strategies for complex data pipelines validate Snowflake/DBT transformations MDM solutions and data quality using advanced automation tools. This role demands hands on expertise in Snowflake and DBT with strong collaboration across data engineers analysts and stakeholders to drive data governance and quality.

Key Responsibilities:

• Execute comprehensive end to end 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 best in class 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 hands on expertise with Snowflake and DBT (DBT is mandatory).
• Strong command of Master Data Management (MDM) concepts and best in class 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 problem solving and communication abilities; able to convey complex data quality issues to both technical and non technical audiences.

Preferred Qualifications:

• Experience in cloud based data environments (e.g. AWS Azure GCP).
• Exposure to enterprise data governance and data quality frameworks.