Analytics Data Engineer

** 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

Data Engineering

• 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 

• Corporate Goodlife Membership Discount

• Group RRSP (Non-match) 

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

• Paid Religious Holidays 

• Paid Volunteer 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) 

What are we at the frontier of? 

Providing quality and top brand dental supplies to dental practices all across North America. Our customers trust our deep knowledge of the dental trade and our ability to provide the right products at competitive prices, all through simple and efficient channels. We currently sell and distribute more than 30,000 unique products to 2,000 dental offices in Canada and the U.S. We're on the cusp of something big. 

With roots in the dental wholesale and distribution industry Frontier Dental Supply, Inc., was formed in 2016. We are headquartered in the Greater Toronto Area (GTA). 

We are proud to have been certified and awarded the following: 

• Great Place to Work for three consecutive years. 

• The Best Workplaces in 2021. 

• Finalist for Fastest Growing Company 2021 and Startup Business of the Year 2021 by CanadianSME. 

• Excellence in Customer Service 2023. 

Who is at the frontier of our success? 

Our people. Our people make it all possible. That's why we seek to grow our team with individuals who desire to stay on course the Frontier TRACK. 

Learn more about what it's like to work at Frontier Dental Supply Inc. from our very own employees on our Glassdoor page. 

We're rooting for you We thank all candidates for taking the time to apply. However, only those candidates selected to move forward in our recruitment process will be contacted. 

Here at Frontier Dental, we are a diverse team that nurtures an inclusive environment. We attribute our growth significantly to our ability to learn from one another's perspectives. Frontier Dental values the unique skills and experiences of each of our candidates; recognizing that each prospective team member contributes to our efforts in building a diverse and inclusive place to work. We are committed to being an equal opportunity employer and are happy to provide accommodations upon request at all stages of the recruitment process. Should you require any disability-related accommodation to support your participation in our recruitment process, please notify us and we will work with you to meet your accessibility needs.  

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of employees so classified. All employees may be required to perform duties outside of their normal responsibilities from time to time, as needed. 

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 . All notices and candidate requests will be documented for compliance purposes