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

Description

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.

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

Responsibilities

• 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.
• 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-dive 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

Requirements

• 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.

Benefits

• 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.
• LI-HYBRID
• 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