QA Developer

dentalcorp•Toronto, ON

3d•Hybrid

About The Position

This role sits at the heart of Dentalcorp’s data ecosystem, ensuring the accuracy, reliability, and trustworthiness of the data that powers our clinical, operational, and strategic decision‑making. As we continue to scale our network and modernize our data platforms, the need for robust data validation and high‑quality ETL processes has never been more critical. You will join a growing Data Engineering & Architecture team during an exciting period of transformation, where we are expanding our data pipelines, maturing our quality frameworks, and increasing automation across our environment. This is an opportunity to directly influence the integrity of enterprise‑wide data assets while working with modern cloud technologies and a collaborative, high‑performing team. This position is part of an existing vacancy and offers the chance to step into a meaningful role where your work will have immediate and visible impact across the organization.

Requirements

Knowledge of ETL/ELT concepts and processes.
Understanding of SQL and experience in querying relational databases.
Familiarity with data quality tools and techniques.
Basic understanding of data warehousing concepts.
Strong analytical and problem-solving skills.
Excellent communication and collaboration skills
Experience in writing complex SQL queries
Experience in testing BI reports (Tableau)
Experience with Agile methodologies (Scrum and Kanban) and frequent release cycles
Experience with Atlassian Tools (JIRA & Confluence)
Experience with Snowflake and MS-SQL Databases
Experience with CI/CD (GitLab)
Candidates must be legally eligible to work in Canada.

Nice To Haves

Post-secondary degree in Computer Science, Information Technology, or a related field would be an asset
Experience with programming/scripting languages (Python, NodeJS, Batch) or similar is a great asset

Responsibilities

Work closely with cross-functional teams, including ETL developers, data engineers, data analysts, and business users to better understand data migration processes, data requirements, and business rules.
Assist in developing and documenting test plans and test cases based on functional and technical specifications, ensuring comprehensive coverage of data migration workflows.
Participate in executing and automating test cases to validate the accuracy, completeness, and consistency of data throughout the data migration pipeline.
Assess data quality at various stages of the data migration process, identifying anomalies, discrepancies, and outliers.
Identify opportunities for process improvement and automation to enhance the efficiency and effectiveness of the ETL QA process.