QA Developer

The Opportunity

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.

You are analytical, detail‑oriented, and naturally curious - someone who enjoys digging into data, uncovering inconsistencies, and ensuring systems behave exactly as intended. You thrive in environments where accuracy matters and where collaboration with developers, analysts, and business partners is essential. You communicate clearly, ask thoughtful questions, and bring a structured approach to problem‑solving. You’re comfortable working with ambiguity, adaptable to changing priorities, and motivated by improving processes and building scalable, repeatable testing frameworks.

You take pride in delivering high‑quality work and contributing to a culture of continuous improvement.

Reporting to the Senior Director, Data Engineering and Architecture, you will play a key role in validating the data that supports Dentalcorp’s clinics, operational teams, and enterprise reporting. Your work ensures that data flowing through our ETL pipelines is complete, accurate, and aligned with business rules — ultimately supporting better patient experiences, stronger operational performance, and more informed decision‑making. You will collaborate closely with ETL developers, data engineers, analysts, and cross‑functional partners across Operations, Finance, and Analytics.

Your contributions will directly influence the reliability of our data warehouse, the success of migration initiatives, and the quality of insights delivered across the organization.

• 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.

• Post‑secondary degree in Computer Science, Information Technology, or a related field would be an asset
• 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 (Git Lab).
• Experience with programming/scripting languages (Python, NodeJS, Batch) or similar is a great asset.

The salary range for this position is $65,000 CAD…