Match score not available

Data Test Engineer

extra holidays - extra parental leave
Remote: 
Full Remote
Salary: 
50 - 50K yearly
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

6+ years of experience testing ETL processes, Strong SQL skills with 6+ years experience, 3+ years of recent experience with BI tools, Experience with Azure DevOps and Agile.

Key responsabilities:

  • Collaborate to design and execute test cases
  • Validate data integrity during ETL processes
Affinity logo
Affinity Scaleup http://affinity-group.ca
51 - 200 Employees
See all jobs

Job description

Job Description:

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.

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 11428

Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Data Engineer Related jobs