Analytics Data EngineerFrontier Dental CA • Markham, York Region, CA

Analytics Data Engineer

Frontier Dental CA • Markham, York Region, CA

23 days ago

Job type

Full-time

Job description

Analytics Data Engineer

Join to apply for the Analytics Data Engineer role at Frontier Dental CA.

Must be willing to work on-site in Markham office 5 days / week

Come work with us to do what you love and stay for the Frontier TRACK …

Team Centric : We each take responsibility for fostering an environment of personal and professional growth. We are eager to help, support and collaborate with one another recognizing that we are better when we work together.
Respectful and Inclusive : We treat everyone the way we want to be treated and accept everyone on the team just as they are.
Autonomous and Accountable : We are entrusted with and given the space to do our work and in turn hold ourselves accountable for results.
Committed to Excellence : We are fueled by the desire to be our best and to make an impact now and tomorrow.
Keep it Real : We lead with integrity and genuineness in our work, interactions and relationships.

We’re seeking an Analytics Data Engineer to help shape the future of dental supply distribution through data-driven innovation.

Key Responsibilities

We’re looking for a hands‑on Analytics Data Engineer who will own our end‑to‑end data stack – building and tuning data warehouse, automating reliable SQL / Python ELT pipelines, and delivering analytics and semantic models for dashboards and AI / ML use cases, while maintaining strong data‑quality and governance standards.

Hands‑on data strategy lead – Translate business goals into an actionable roadmap for modern data warehousing, governed data pipelines, and scalable infrastructure.

Data‑warehouse – Architect, build, and continuously tune our data lakehouse architecture, ensuring high availability, cost‑efficiency, and strong performance across all teams.

Pipeline builder – Design, automate, and monitor ELT workflows using SQL and Python, with comprehensive testing and alerting to guarantee accuracy and availability.

Governance & quality – Implement version control, data lineage tracking, and access policies; enforce data SLAs and lead root‑cause analysis to uphold data integrity and compliance.

Integration specialist – Connect and integrate data from various enterprise systems (including CRM and ERP platforms such as HubSpot, Acumatica, RingCentral) into the data platform, ensuring a unified, analytics‑ready data model.

Analytics

Analytics enabler – Build and maintain Power BI semantic models, dashboards, and self‑serve tools that turn raw data into actionable insights for business stakeholders.

AI / ML facilitator – Collaborate with the data Team to prepare clean, usable feature sets and deploy predictive models that drive revenue, operational efficiency, and customer value.

Cross‑functional collaborator – Collaborate with stakeholders to resolve data issues, and promote agile, insight‑driven decision‑making.

Qualifications & Experience

5+ years experience in data engineering, analytics, or a related field.

End‑to‑end ownership : Demonstrated success owning end‑to‑end data pipelines and business intelligence assets in a high‑growth, fast‑moving organization (e.g., building ETL workflows and delivering BI dashboards).

Data & AI projects : Experience partnering with data science teams to deploy predictive or generative AI models (leveraging Python‑based ML frameworks or cloud AI services) that lifted revenue and reduced operational costs.

Modern data stack : Deep understanding of modern data stack technologies and cloud platforms (AWS or Azure), including hands‑on experience with AWS managed services such as S3, AWS Lake Formation, Glue, EMR, EC2, AWS Lambda, Athena, and comparable Azure data services.

Security & governance : Strong background in data security and governance – implementing data encryption, access controls / roles, and data lineage tracking (familiarity with tools like AWS Lake Formation or Azure Purview for data cataloging is a plus).

SQL & Python expertise : Expert at writing analytical SQL (in databases or warehouses like PostgreSQL, MySQL, Snowflake, or Amazon Redshift) and building ELT jobs in Python (using frameworks like dbt, Apache Airflow, or AWS Glue). Able to create complex DAX measures in Power BI and design robust data pipelines that scale.

Strategic execution : Demonstrated ability to turn strategic business objectives into a concrete plan for data warehousing, governed analytics, and practical AI / ML deployment (for example, aligning cloud data platforms and machine learning services like AWS SageMaker or Azure ML with business goals).

Cloud data warehousing : Skilled at architecting, implementing, and continuously optimizing scalable cloud data warehouses (for example, solutions on Snowflake, Amazon Redshift, or Databricks Lakehouse) to keep high‑quality, analytics‑ready data flowing to the business.

System integration : Experience integrating data from CRM and ERP systems (e.g., HubSpot CRM, Acumatica ERP) via APIs or connectors, merging these data sources into a unified analytics platform.

Relevant industry certifications are a plus – for example, AWS or Azure cloud certifications, or data platform certifications like Snowflake or Databricks.

Why join us? (Brace yourself…)

We offer competitive compensation

Extended Health and Dental Benefits Plan (100% Employer‑paid Premiums on eligible benefits)

Continuous Learning Assistance Program reimbursing up to $1,500 per calendar year

Group RRSP (Non‑match)

15 Vacation Days to start and scale to 20 Vacation Days.

Flexibility to help you balance work and life

Supportive leadership team and Culture Committee that works to maintain a positive culture

Competitive yet collaborative work environment

Fully stocked snacks, team BBQs and other company paid meals (we love to eat!)

Frontier Dental uses an automated Applicant Screening Tool to assist in reviewing applications. This tool evaluates candidates based on job‑related criteria, including skills, experience, and qualifications listed in your application materials.

You may request an alternative, non‑automated assessment or an explanation of how the evaluation was conducted by contacting careers@frontierdental.com. All notices and candidate requests will be documented for compliance purposes.

Job Details

Seniority Level : Not Applicable

Employment Type : Full‑time

Job Function : Information Technology

Industries : Retail

Referrals increase your chances of interviewing at Frontier Dental CA by 2x.

Get notified about new Data Engineer jobs in Markham, Ontario, Canada.

#J-18808-Ljbffr

Create a job alert for this search

Data Engineer • Markham, York Region, CA

Similar jobs

Senior Manager, Data Analytics

Scene+ • Toronto, ON, Canada

Full-time

At Scene+, we foster an entrepreneurial spirit that drives our mission : making tomorrow even more rewarding for our members. As a unique joint venture between Cineplex, Empire, and Scotiabank, and a...Show more

Last updated: 30+ days ago • Promoted

Data Engineer - Snowflake

Tiger Analytics Inc. • Toronto, ON, CA

Full-time

Quick Apply

Tiger Analytics is a fast-growing advanced analytics consulting firm.Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several F...Show more

Last updated: 7 days ago

Consulting Director, Data Analytics

Info-Tech Research Group • Toronto, Canada

Full-time

Consulting Director, Data Analytics.Info-Tech Research Group Join to apply for the.Consulting Director, Data Analytics.Info-Tech Research Group Get AI-powered advice on this job and more exclusive ...Show more

Last updated: 30+ days ago • Promoted

Databricks Engineer

TheAppLabb • Toronto, ON, Canada

Full-time

TheAILabb is a leading innovation company specializing in AI-powered digital solutions, mobile app development, and emerging technologies. We leverage data-driven insights to enhance digital experie...Show more

Last updated: 30+ days ago • Promoted

Data Analytics Intern

SalesPilot 365 | CRM • richmond hill, on, ca

Full-time

As part of our expansion into Data Analytics, we’re offering a structured internship program for motivated individuals eager to build a career in data-driven decision-making.Join our analytics team...Show more

Last updated: 19 days ago • Promoted

Strategic Data Modeling & Analytics Architect

Accenture • Toronto C6A, ON, Canada

Full-time

A leading consulting firm in Toronto seeks a Data Modeling and Analytics Architect.This role involves hands-on data modeling and architectural guidance, focusing on developing data marts for analyt...Show more

Last updated: 9 days ago • Promoted

Lead Data Engineer - Snowflake

Talent To Hire Inc. • Toronto, ON, Canada

Full-time

Our client is a Toronto-based firm founded by leading engineers and data scientists, with deep roots in capital markets and cloud engineering. You’ll work on cutting-edge projects in asset man...Show more

Last updated: 30+ days ago • Promoted

Azure Data Engineer : AI-Powered Data Pipelines

Genpact • Toronto

Full-time

A leading technology services company in Toronto is seeking a Principal Consultant - Azure Data Engineer.In this role, you will design and maintain data pipelines and implement ETL processes using ...Show more

Last updated: 11 days ago • Promoted

Senior Data Engineer, Cloud & Analytics Platform

Socotra, Inc. • Toronto

Full-time

At Lyft, our purpose is to serve and connect.We aim to achieve this by cultivating a work environment where all team members belong and have the opportunity to thrive. We believe that our data is on...Show more

Last updated: 15 days ago • Promoted

AWS Technical Lead - Data & Analytics

Adastra • Markham

Full-time +1

AWS Technical Lead - Data & Analytics.Are you ready to lead the charge in the world of data innovation? Adastra is seeking an AWS Technical Lead with a solid background in Data and Analytics to joi...Show more

Last updated: 15 days ago • Promoted

Data Engineer

Synechron • toronto, on, ca

Full-time

At Synechron, we believe in the power of digital to transform businesses for the better.Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital ...Show more

Last updated: 30+ days ago • Promoted

Data Analytics Consultant — Deal Advisory & AI Insights

KPMG LLP Canada • Toronto

Full-time

A leading professional services firm in Toronto seeks a Consultant / Senior Consultant to join their Data & Analytics team. The role involves evaluating business performance, analyzing large dataset...Show more

Last updated: 15 days ago • Promoted

Manager, Analytics

VaynerX • Toronto

Full-time

Subsidiaries include VaynerMedia, Eva Nosidam Productions, The Sasha Group, Gallery Media Group, Tingley Lane Trading, VaynerSpeakers, and VaynerCommerce. VaynerMedia is a contemporary global creati...Show more

Last updated: 3 days ago • Promoted

Head of Cloud Platform (Data & Analytics)

Azoma • Toronto

Full-time

Head of Cloud Platform (Data & Analytics).Get AI‑powered advice on this job and more exclusive features.Direct message the job poster from Azoma. This role is for engineers who have owned 0→1 cloud ...Show more

Last updated: 12 days ago • Promoted

Data Analytics Scientist - Hybrid (Azure / Databricks)

V-Soft Consulting Group, Inc. • Toronto

Full-time

A dynamic technology consulting firm is looking for a Data Analytical Specialist / Scientist to join their team in Toronto, Ontario. This role involves running inference jobs, data handling, and suppo...Show more

Last updated: 15 days ago • Promoted

Data Strategy & Analytics Lead

Kepler Group • Toronto

Full-time

A leading marketing analytics agency in Toronto is seeking a Data Strategy & Analytics Associate Director to drive client success through data insights and strategy. The role demands strong analytic...Show more

Last updated: 15 days ago • Promoted

Azure Data Engineer | PySpark & Data Lake Architect

Themesoft Inc. • Toronto

Full-time

A leading IT consulting firm is seeking a Strategic Recruitment Manager for HR Operations and Global Hiring Compliance.Located in Toronto, ON, this role involves designing data pipelines, developin...Show more

Last updated: 15 days ago • Promoted

GCP Data Leader : ML, Analytics & Big Data

PricewaterhouseCoopers International • Toronto

Full-time

A leading consulting firm in Toronto is seeking a data and analytics engineer to develop robust data solutions and drive decision-making. Responsibilities include project ownership, mentoring team m...Show more

Last updated: 15 days ago • Promoted