08 Nov
|
HelloFresh
|
Toronto
08 Nov
HelloFresh
Toronto
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 — robust 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
📌 Senior BI Analyst, Reporting (Toronto)
🏢 HelloFresh
📍 Toronto