Senior BI Analyst, Reporting & BI (m/f/x)

HelloFresh; Toronto; Hybrid; CAD 82,000 - 92,000; Full time

Benefits offered by this job

Box Discount

Health & Wellness benefits

Vacation & PTO

Parental leave top-up

Career development support

Team events & company culture

Job summary

HelloFresh Canada is seeking a Senior BI Analyst to own the data landscape for the Toronto-based domain. You will design and maintain ETL/ELT pipelines, create executive dashboards, and perform deep-dive analyses to inform strategic decisions reaching C-suite stakeholders.

You will lead data quality initiatives, partner with Product, Marketing, Finance, and Ops, and mentor others in SQL, data modeling, and best practices.

Qualifications

• 6+ years in BI Analytics or related fields.
• Advanced SQL proficiency and data pipeline experience.
• Experience with modern data stack tools (dbt, Databricks, Airflow).
• Data modeling and scalable BI dashboards.
• Strong stakeholder management.
• Ownership mindset and data quality focus.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using dbt, Databricks, Spark SQL, and Airflow — transforming raw data into robust, scalable models that power analytics across the business
• Act as the steward of your domain's data landscape: implement automated data quality checks, monitoring, and alerting to proactively catch issues, and troubleshoot pipeline failures with timely root‑cause fixes
• Write performant, maintainable SQL for large-scale data transformations and collaborate with central Data Engineering teams on schema design and technical requirements
• Build and maintain executive‑level BI dashboards (Tableau, Databricks) and conduct deep‑drive analyses that translate complex, ambiguous business questions into data‑driven strategic recommendations
• Own critical business reporting (WBRs, QBRs, forecasting) and act as the trusted analytics partner across Product, Marketing, Finance, and Operations — ensuring insights are accurate, timely, and actionable
• Document data models, pipelines, and methodologies to enable self‑service, and mentor junior analysts and engineers on SQL best practices, data modeling, and stakeholder communication

Skills

BI Analytics

SQL proficiency

Data pipelines

dbt/Databricks

Data modeling

BI dashboards

Stakeholder mgmt

Ownership mindset

Tools

dbt

Databricks

Spark SQL

Airflow

Job description

The Role

As a Senior BI Analyst in the Reporting & BI team, you will be the owner of HelloFresh's data landscape for your domain. You will build and maintain the data infrastructure that powers executive decision‑making — from creating data pipelines and ETL jobs to building executive‑level dashboards and conducting deep‑dive analyses. You combine analytical depth with engineering capabilities: translating ambiguous business questions into actionable insights and own end‑to‑end delivery — from raw data ingestion through transformation pipelines to polished dashboards and strategic recommendations that reach C‑suite stakeholders. This role is ideal for someone who thrives at building things: pipelines, data models, dashboards, and insights — all while ensuring data quality, scalability, and business impact.

What You’ll Do: The Recipe

• Design, develop, and maintain ETL/ELT pipelines using dbt, Databricks, Spark SQL, and Airflow — transforming raw data into robust, scalable models that power analytics across the business
• Act as the steward of your domain's data landscape: implement automated data quality checks, monitoring, and alerting to proactively catch issues, and troubleshoot pipeline failures with timely root‑cause fixes
• Write performant, maintainable SQL for large-scale data transformations and collaborate with central Data Engineering teams on schema design and technical requirements
• Build and maintain executive‑level BI dashboards (Tableau, Databricks) and conduct deep‑drive analyses that translate complex, ambiguous business questions into data‑driven strategic recommendations
• Own critical business reporting (WBRs, QBRs, forecasting) and act as the trusted analytics partner across Product, Marketing, Finance, and Operations — ensuring insights are accurate, timely, and actionable
• Document data models, pipelines, and methodologies to enable self‑service, and mentor junior analysts and engineers on SQL best practices, data modeling, and stakeholder communication

What You’ll Bring: The Ingredients

• 6+ years of experience in BI Analytics, Data Engineering, or Analytics Engineering — ideally in a fast‑paced B2C, subscription, or growth‑oriented business
• Advanced SQL proficiency and data pipeline experience — comfortable with complex transformations, performance‑tuning, and building/troubleshooting ETL/ELT pipelines at scale
• Modern data stack tools — hands‑on experience with dbt, Databricks, Spark SQL, Airflow, or similar orchestration and transformation tools
• Data modeling expertise — strong understanding of dimensional modeling, star schemas, and designing scalable data models
• Proven ability to build and maintain BI dashboards (Tableau, Databricks, Looker, or similar) that reach senior leadership
• Stakeholder management — experience translating ambiguous business challenges into structured analytical work and influencing cross‑functional partners (Product, Marketing, Finance, Operations)
• Ownership mindset — proactively identifies issues, drives solutions, and takes accountability for data quality and delivery

Nice To Have

• Python for data transformation, ad‑hoc analysis, automation, or lightweight modeling
• Experience with data monitoring and alerting frameworks (Great Expectations, Monte Carlo, dbt tests)
• Experience with event‑level behavioral data and tracking design (Snowplow, Google Analytics, Segment, GA4) — schema design, entity modeling, event naming
• Exposure to statistical modeling techniques — segmentation, clustering, regression, cohort analysis
• Experience with cloud data platforms (AWS, GCP, Azure) or data migration projects.

What we offer: The Toppings

• Box Discount - Amazing discounts on 1 box per week! 75% discount on weekly HelloFresh and Chefs Plate meal kits AND 50% off weekly Factor meal box.
• Health & Wellness - Health & Dental benefits from day 1, a Health Spending Account, unlimited access to the Headspace app to meet your self‑care needs, and 25% discount on GoodLife fitness memberships!
• Vacation & PTO - Time off is also an important part of self‑care! We offer generous vacation and PTO to help you create a good work‑life balance.
• Family Benefits - A parental leave top‑up program for expectant parents.
• Growth & Development - We support your career progression and invest in your continued learning through experiences and initiatives owned by our dedicated L&D team
• Work Hard & Have Fun - From team socials to engaging company days, you’ll have plenty of opportunity to experience the fun!
• Diversity & Inclusion Initiatives - With impactful ERG’s like FreshPride, Women Empowered and LIMES, we are committed to our diversity, equity & inclusion efforts.

Flexible Hybrid Approach

At HelloFresh, we know that flexible work arrangements are essential in enabling you to do your best work, while balancing your personal and life needs. Offering remote work flexibility, along with the opportunity to interact and collaborate in the office are all a part of creating a great employee experience. To meet these needs, we are pleased to provide Flexible Hybrid work. Flexible Hybrid is a people‑first approach that is based on choice, trust, personalization, and empowers teams to choose when and how often they work from the office and work from home, in addition to team days and company days. This means a minimum of 2 days in office per week, with most teams in office between 2‑3 days a week.

HelloFresh Canada uses AI‑integrated technology to help us process and evaluate applications more efficiently. This includes tools that screen and assess candidate qualifications based on the requirements for this role. While these tools assist our workflow, all final selection decisions are made by our hiring team.

Toronto, ON Pay Range

$82,000—$92,000 CAD