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.
Who You Are
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.
The Impact You’ll Have
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 Anlytics. 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.
In This Role, You Will
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.
What You’ll Bring
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 (GitLab)
Experience with programming/scripting languages (Python, NodeJS, Batch) or similar is a great asset
About Dentalcorp
Dentalcorp is Canada’s largest and fastest growing network of dental practices, committed to advancing the overall well-being of Canadians by delivering the best clinical outcomes and unforgettable experiences. Dentalcorp acquires leading dental practices, uniting its network in a common goal: to be Canada’s most trusted healthcare network. Leveraging its industry-leading technology, know-how and scale, Dentalcorp offers professionals the unique opportunity to retain their clinical autonomy while unlocking their potential for future growth.
Candidates must be legally eligible to work in Canada. At Dentalcorp, we recognize that inclusivity and diversity strengthen our culture and make us better. We are committed to ensuring that the talent we hire is reflective of the diverse communities and patients we serve. To ensure equal opportunity for all candidates, we strongly encourage applicants requiring an accommodation to let their recruiter know during the recruitment/selection process. We appreciate all applicants for taking the time to apply, however, only those selected for an interview will be contacted.
The salary range for this position is $65,000 CAD to $80,000 CAD annually. Offers within this range are determined based on relevant experience, skills, and qualifications, as well as internal equity considerations.
This role is 4 days on-site Monday to Thursday with Friday's work from home. This job posting is for an existing vacancy.
