Analytics Engineer

Roots • Toronto, ON

1d

About The Position

As an Analytics Engineer, you'll sit at the intersection of data engineering and analytics, turning raw retail data into trusted, scalable assets and the insights that bring them to life. As a collaborative member of our data team, you'll contribute to the data models that power solutions across the Roots business and help build the data products, semantic layers, and self-service tools that empower every team at Roots to access trusted data independently. Our data team is small and collaborative, meaning you'll wear multiple hats and have broad exposure across the business.

Requirements

• 3+ years of experience in analytics engineering, data engineering, business intelligence, or an equivalent data analytics role.
• Strong SQL proficiency and hands-on experience with Snowflake or a comparable cloud data warehouse.
• Hands-on experience with ELT/ETL platforms, with Matillion or a similar cloud-native transformation tool preferred.
• Proficiency building data models and dashboards with Power BI.
• Solid understanding of dimensional modelling methodologies including star schemas and slowly changing dimensions.
• Experience with version control using Git.
• Familiarity with data quality practices including testing, documentation, and pipeline monitoring.

Nice To Haves

• Exposure to Gen AI solutions such as Snowflake Cortex or Microsoft Fabric Copilot is preferred.
• Retail or apparel industry experience across omnichannel environments is an asset.
• Python proficiency for data transformation, ad hoc analysis, or automation is a plus.

Responsibilities

• Support end-to-end data transformation, converting raw omnichannel source data (POS, e-commerce, inventory, CRM, and marketing) into clean, structured layers within Snowflake.
• Contribute to the design and build of components of the Snowflake data mart, applying dimensional modelling best practices including star schemas and slowly changing dimensions, to help create reliable, performant data products that serve ad hoc analysis, BI dashboards, and AI data solutions.
• Support Power BI report development end-to-end, from semantic model design to polished, publish-ready reports, giving commercial, merchandising, marketing, and finance teams self-service access to trusted data without analyst dependency.
• Perform ad hoc analysis using SQL and Python directly in Snowflake to help answer pressing business questions, uncover trends, and deliver timely insights that inform planning, buying, and operational decisions.
• Assist in maintaining data quality standards, including testing frameworks, pipeline alerting, and documentation, to help ensure the data mart is trustworthy and well-understood across the business.
• Support the development and maintenance of Gen AI data solutions, including natural language interfaces enabling any business user to query the data mart in plain English.
• Partner cross-functionally with merchandising, planning, marketing, and commercial teams to understand analytical needs and help translate them into scalable data products.
• Participate in the continuous improvement of our data platform, contributing ideas around new tools, patterns, and AI capabilities that keep Roots ahead of the curve.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed