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
Supporting dental practices across North America to go Beyond Brilliant through Frictionless Dentistry. It was founded in 2011, and is headquartered in Toronto, Ontario, CAN, with a workforce of 10001+ employees. Its website is http://www.dentalcorp.ca.