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!

Job Overview: We are looking for a Senior Data Engineer who is passionate about building systems that shape business outcomes. This role will play a key role in designing, building, and optimizing our data platform which powers our company at scale. You will drive and manage large-scale data migration and modernization initiatives, and work with cross-functional teams to deliver trusted, high-quality data that drives business intelligence, analytics, and innovation.

As a Senior Data Engineer, you will be at the forefront of building scalable pipelines, architecting data solutions, and ensuring our data platforms can support real-time insights and long-term growth. With freedom to shape solutions and make a real impact, you will be at the forefront of how our data roadmap comes to live and evolves.

Responsibilities and Duties:

• Take ownership of coding and solution design while collaborating with internal and external engineers on design, development, and deployment of data pipelines and solutions.
• Design and implement end-to-end data migration strategies from legacy systems to modern cloud platforms.
• Manage data architecture and data modernization initiatives, ensuring alignment with business goals, data governance policies, and performance requirements.
• Develop and optimize ETL/ELT pipelines using modern tools and frameworks (e.g., Apache Spark, Databricks, Airflow, dbt).
• Work with stakeholders to gather requirements and translate them into scalable and maintainable data solutions.
• Ensure data quality, reliability, and integrity through robust testing and monitoring.
• Evaluate and recommend new technologies and tools to improve data engineering practices.
• Drive best practices in DevOps for data – CI/CD.
• Mentor and provide technical guidance to data engineers.
• Provide regular status updates and risk assessments to project managers and leadership.

Education, Credentials, Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent experience).
• 7+ years of relevant experience in Data Engineering / Analytics domain with at least 3 years in Digital Analytics
• 7+ years of experience in SQL and 4+ years in Python
• Proven expertise with tools like ADF, Qlik Replicate, FiveTran for data integration and ETL processes.
• Strong understanding of Python scripting and use of libraries (NumPy, Pandas)
• Extensive hands-on experience with MS Fabric, including data warehousing, SQL optimization, and cluster management.
• Strong knowledge of Big Data technologies such as Data Bricks, Event driven data processing using Function Apps/Lambda is preferred
• Understanding of Web services (SOAP, XML, UDDI, WSDL)
• Strong knowledge and experience in event driven architecture using standard message queues (i.e.RabbitMQ, SQS or Kafka)
• Experience with building a data lake over Cloud / Azure, ADF, Synapse, and Databricks – Delta Lake
• Hands on Experience parsing NOSQL file systems such as JSON, XML, AVRO, Parquet.
• Proven track record of using Apache Spark Data Bricks.
• Hands-on experience with Azure Data Factory (ADF), Logic Apps, and Runbooks.
• Exposure to traditional BI Tools (Tableau, Power BI, Qlik, SSRS, etc.)
• Experience building web-services is a plus.

Required Skills & Abilities :

• Solid understanding of data pipeline architecture, cloud infrastructure, and best practices in data engineering.
• Excellent problem-solving skills and attention to detail.
• Ability to work independently and collaborate effectively in a team environment.
• Skilled in independently analyzing large datasets, identifying discrepancies and inconsistencies, and recommending corrective actions.
• Excellent communication and teamwork abilities, with experience engaging stakeholders at all levels.
• Self-starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever-changing priority list and resolve conflicts to competing priorities.

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.