Data Test Engineer

Affinity


Date: 2 days ago
City: Remote, Remote
Contract type: Contractor
Remote
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

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Lending and Funding Operations Program Manager

Square, Remote, Remote
1 week ago
Since we opened our doors in 2009, the world of commerce has evolved immensely, and so has Square. After enabling anyone to take payments and never miss a sale, we saw sellers stymied by disparate, outmoded products and tools that wouldn’t work together.So we expanded into software and started building integrated, omnichannel solutions – to help sellers sell online, manage...

Barman / Barmaid

Edmonton Military Family Resource Centre, Remote, Remote
1 week ago
QUI NOUS SOMMESSBMFC. Plus qu’un emploi… une mission. Notre organisation, forte de plus de 4000 personnes, prône un mode de vie sain, actif, divertissant et créatif pour les membres, les vétérans et les vétéranes des Forces armées canadiennes et leurs familles. Aidez-nous à offrir une variété de programmes de conditionnement physique et de loisirs, à assurer du soutien aux familles,...

Senior Product Manager

Gusto, Remote, Remote
1 week ago
About GustoGusto is a modern, online people platform that helps small businesses take care of their teams. On top of full-service payroll, Gusto offers health insurance, 401(k)s, expert HR, and team management tools. Today, Gusto offices in Denver, San Francisco, and New York serve more than 300,000 businesses nationwide.Our mission is to create a world where work empowers a better...