Data Test Engineer (Snowflake)
Role summary
A Data Test Engineer is needed for a 6-month remote contract role, working PST hours, for a leading Property Tax & Flood Service Solutions provider. The role focuses on ensuring the quality of data-driven applications and systems. Responsibilities include designing and executing test cases, validating data integrity during ETL and migration, developing automated tests, testing BI reports (Power BI, SSRS), analyzing data issues, and integrating tests into CI/CD pipelines using Azure DevOps within an Agile framework. The ideal candidate will have extensive experience in ETL testing, SQL, and BI tools, along with proficiency in Azure DevOps and Agile methodologies.
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.