ETL and BI Developer

123Dentist is Canada’s largest majority dentist-owned network of dental practices, with almost 500 locations nationwide and nearly 8,000 employees. We offer professional advancement opportunities, competitive compensation, corporate sponsored incentive programs such as long-term bonuses for full-time employees (a first of its kind in the Canadian dental industry), and a long-term career in a growing network located in multiple communities across the country, at all levels of the industry. 

Whether you’re entering the job market or you’re an experienced practitioner, we welcome your interest! Come join the 123Dentist team and be part of our success.

We provide Canadian dentists and dental practices with an array of non-clinical support and resources, including accounting, HR, marketing, as well as supply & equipment procurement.

By leveraging our unmatched management experience, marketing expertise and state-of-the-art technologies, we allow dentists to take advantage of a practical and effective alternative to practice ownership and focus on what they’re best at – being a dentist!

We are recruiting for an experienced ETL and BI developer professional to join our Business Intelligence team. This role will be based in our Corporate head office in Downtown Toronto.

This is an on-site position.

Job Overview:

We are looking for a skilled Data Engineer to design and develop robust ETL processes, SQL scripts, and Power BI solutions for integrating and analyzing data across multiple enterprise systems, including Dental, HR, and Finance platforms.

This role requires strong expertise in SQL, Azure Data Factory, Python, and Power BI, as well as sharp problem-solving skills to ensure data accuracy, consistency, and optimal performance.

The ideal candidate will work closely with business stakeholders to deliver scalable, high-quality data solutions that drive strategic decision-making and business impact.

Responsibilities and Duties:

• Develop and maintain scalable ETL processes using Azure Data Factory, SQL Stored Procedures, Logic Apps, Databricks, and Python to extract, transform, cleanse, and load data into Azure SQL Database while maintaining high data quality.
• Continuously monitor and optimize ETL pipelines to ensure seamless data flow, proactively addressing and resolving any data quality issues that arise.
• Utilize advanced data analysis skills to reverse-engineer data logic and create efficient SQL solutions that align with report calculations from dental software and integrate data from multiple source systems, including HR and Finance.
• Identify, investigate, and resolve discrepancies between source and target data through in-depth gap analysis, implementing effective solutions to improve data accuracy and consistency across systems.
• Perform comprehensive data quality checks and reconciliation processes to ensure compliance with departmental standards, while identifying potential risks and ensuring timely issue resolution.
• Collaborate closely with data analysts and business stakeholders to design optimized logical and physical data models capable of efficiently handling large-scale data volumes and supporting high-performance queries.
• Conduct thorough unit and integration testing, ensuring data integrity and compliance with business and functional requirements, and troubleshooting issues to maintain system reliability and performance.
• Develop robust data models using star schema, snowflake schema, and normalization techniques to optimize query performance and reporting.
• Implement Power BI solutions by seamlessly integrating data from the data warehouse and other enterprise systems, ensuring user-friendly visualizations and actionable insights.
  
  

Education, Credentials, Qualifications:

• Bachelor’s degree in computer science, computing and financial management, statistics, actuarial science, or a similar program.
• Minimum of 2 years of overall work experience, with a focus on ETL, SQL, or Data Warehouse.
• Familiarity with or experience in dental software or healthcare systems and data is a valuable asset.
• Certified Data Engineering on Microsoft Azure or Certified Microsoft Power BI Data Analyst would be an asset.
  
  

Required Skills & Abilities:

• Hands-on experience with Azure Data Factory (ADF), Logic Apps, and Runbooks.
• Demonstrated expertise in working with SQL Server, Oracle, Azure SQL Databases, and APIs.
• Advanced proficiency in data manipulation languages (T-SQL, PL/SQL), data definition languages, database design, data modeling, and query performance tuning.
• Skilled in independently analyzing large datasets, identifying discrepancies and inconsistencies, and recommending corrective actions.
• Solid understanding of data warehousing concepts, including source analysis, profiling, and relational DBMS.
• Practical experience with DAX, Power Query, MS Power BI service architecture, and administering roles and security.
• Experience with at least one programming language (Python, Java, C#, etc.).
• Familiarity with the Azure cloud platform and PowerShell scripting.
• Strong problem-solving and analytical skills.
• Excellent communication and teamwork abilities, with experience engaging stakeholders at all levels.
• Capable of managing and adjusting to evolving priorities from multiple projects
  
  

What We are Offering:

• Full-time permanent employment, competitive salary and great benefits package
• A collaborative team that will support and train you, great office environment
• Challenging and rewarding role that will develop your skillset and talent
• Dynamic, fast paced and growing company, with an entrepreneurial, ‘can do’ attitude
  
  

Why Join Us? At 123Dentist, we value a diverse and inclusive workplace and offer a dynamic environment where you can make an impact on the total rewards experience for our team members across the country.

123Dentist is an equal opportunity employer committed to diversity and inclusivity. The organization strives to build a workforce that reflects the communities it serves, including individuals with disabilities. Accommodations are available upon request throughout the recruitment process. Please inform our team if you need assistance at any stage.

We thank all candidates for their interest; however, only those selected for an interview will be contacted.