Test lead (Spotfire)

Expertise in Data Testing (ETL/BI Testing), Spotfire, Snowflake, DBT for technology experience

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

• 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.