Data Quality Analyst Azure

Ccube; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A data solutions company in Toronto is seeking a Data QA Tester with expertise in Azure tools. This hybrid role requires 5+ years in ETL, Azure Databricks, and strong SQL skills to test and validate large-scale data pipelines. Candidates should also have experience with Python and automation tools. You will work closely with development teams to ensure high data quality. If you thrive in a fast-paced environment and enjoy problem-solving, this role is for you.

Qualifications

• 5+ years of experience in ETL/Data Testing projects.
• Strong hands-on experience with Azure Databricks.
• Excellent SQL skills with ability to write complex queries.

Responsibilities

• Perform ETL testing on large-scale data pipelines built using Azure Databricks.
• Validate data flow from multiple source systems to target databases.
• Execute API test scenarios and validate JSON/XML responses.

Skills

ETL/Data Testing

Azure Databricks

SQL

Python

PySpark

Test Automation

JSON

Agile Methodology

Tools

Jira

TestRail

Git

SonarQube

Job description

Job Title: Data QA Tester (Azure Data Tester)

Location: Toronto, ON (Hybrid)

Full Time

Experience: 5-10+ Years

Must have

• ETL/Data Testing/Azure Databricks + Azure Data Factory: 4 years (Required)
• Strong SQL + Python/Py Spark: 3 years (Required)

Job Description (Responsibilities)

• Perform ETL testing on large-scale data pipelines built using Azure Databricks and Azure Data Factory
• Validate data flow from multiple source systems to target databases
• Test complex data transformation and consumer merge business rules
• Execute API test scenarios and validate JSON/XML responses
• Write and execute complex SQL queries for data validation
• Perform data validation using SQL, Python, and PySpark
• Validate source, staging, and target tables in Databricks
• Design, build, and maintain automated test frameworks using PyTest
• Automate recurring data quality and regression test cases
• Log, track, and validate defects using Jira
• Create and manage test cases in TestRail
• Work closely with development teams to recreate and validate defects
• Participate in daily agile stand-ups and update task status in Jira
• Maintain code quality using Git and SonarQube

Required Skill Sets

• 5+ years of experience in ETL / Data Testing projects
• Strong hands-on experience with Azure Databricks
• Working experience with Azure Data Factory
• Excellent SQL skills with ability to write complex queries
• Strong experience in Python or PySpark for data validation
• Experience in test automation for data pipelines
• Knowledge of data formats such as JSON, Parquet, Avro
• Experience working with Git repositories, branches, and pull requests
• Familiar with Jira, TestRail, and Agile methodology
• Strong analytical and problem-solving skills
• Ability to work independently in a remote, fast-paced environment
• Quick learner with strong attention to data quality and accuracy