Data Test Engineer (Snowflake) - Affinity

Data Test Engineer (Snowflake)

Client: Leading Property Tax & Flood Service Solutions

Duration: 6 month contract (Possible extension)

Location: Canada (Remote, PST or EST)

On behalf of our client, Affinity is seeking a Data Test Engineer to play a critical role in ensuring the quality and functionality of data-driven applications and systems. The ideal candidate will have a strong technical background, including experience with ETL tools (e.g., SSIS), Azure DevOps (AzDO), Agile methodologies, and the ability to automate processes to improve efficiency and cycle times. This is a remote contract role with a requirement to work PST hours.

Responsibilities:

• Collaborate with the data team to design, develop, and execute test cases based on data specifications and business requirements.
• Validate data integrity during ETL processes and data migration activities using tools like SSIS.
• Develop and maintain automated test scripts and frameworks for data-driven applications, enhancing efficiency and reducing manual efforts.
• Perform manual and automated testing of Power BI reports, dashboards, and other Business Intelligence tools to ensure alignment with data sources.
• Analyze and troubleshoot data-related issues, providing detailed root cause analysis and implementing solutions to improve cycle times.
• Participate in code reviews and provide feedback to improve data quality and application performance.
• Leverage Azure DevOps to manage testing pipelines and integrate automated tests into CI/CD workflows.
• Follow Agile development methodologies, contributing to sprint planning, retrospectives, and iterative testing improvements.
• Create and maintain documentation for data testing procedures and best practices.

Requirements:

• 6+ years of experience testing ETL processes and data warehouses, with expertise in tools like SSIS.
• 6+ years of SQL experience, including query writing, data validation, and troubleshooting.
• 3+ years of recent experience with Business Intelligence tools (e.g., Power BI, SSRS) and validating dashboards and reports.
• Experience with Azure DevOps for managing testing pipelines and integrating tests into CI/CD workflows.
• Familiarity with Agile development methodologies and tools like Jira or Azure DevOps.
• Strong understanding of database management, data migration testing, and schema designs (e.g., Star Schema, Snowflake).
• Experience with both manual and automated testing practices, including API testing.
• Excellent problem-solving and analytical skills, with a proactive approach to troubleshooting.
• Strong communication skills, with the ability to collaborate across teams and present findings effectively.