Dentalcorp is Canada’s largest and fastest growing network of dental practices, committed to advancing the overall well-being of Canadians. The QA Developer role focuses on ensuring the accuracy and reliability of data that supports clinical, operational, and strategic decision-making through robust data validation and ETL processes.

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

Skills

• 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

Benefits

• This role is 4 days on-site Monday to Thursday with Friday's work from home.

Company Overview