HelloFresh · posted · checked
Senior BI Analyst, Reporting & BI (m/f/x)
AirflowdbtLookerSparkSQL$82k – $92kHybrid · TorontoSenior
Who can apply
Hybrid · Toronto
Location: Toronto, Ontario, Canada
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-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