Senior BI Analyst, Reporting & BI (m/f/x) at HelloFresh in Toronto, Ontario, Canada

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

Responsibilities

• Design, develop, and maintain ETL/ELT pipelinesusing 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 datatransformations 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 methodologiesto enable self-service, and mentor junior analysts and engineers on SQL best practices, data modeling, and stakeholder communication

Requirements

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

Skills

Required

• Advanced SQL
• Data pipeline experience
• dbt
• Databricks
• Spark SQL
• Airflow
• Data modeling
• Stakeholder management
• Ownership mindset

Preferred

• Python
• Cloud data platforms (AWS, GCP, Azure)

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.
• $82,000—$92,000 CAD