Digital Analyst

Open Farm; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Healthcare coverage

RRSP with company match

Pet-friendly office

Wellness days & personal days

Volunteer days

Job summary

Open Farm is seeking a Digital Analyst to own tracking, data and reporting powering digital marketing and ecommerce performance. You’ll partner with Growth, Media, CRM and Finance to ensure accuracy and turn data into actionable insights.

The role focuses on building pipelines, dashboards, and end-to-end customer reporting, with a strong emphasis on CAC, LTV, and cohort analyses in a fast-paced ecommerce environment.

Qualifications

• 3–6 years of professional experience in data analytics or BI.
• Experience building dashboards for marketing or ecommerce performance.
• Strong SQL skills with complex queries.
• Understanding of digital tracking, pixels and attribution.
• Experience with data pipelines and ETL on cloud platforms.
• Familiarity with Snowflake, BigQuery or Redshift is a plus.
• Experience collaborating with Finance, Product and Operations.
• Excellent communication and storytelling with data.

Responsibilities

• Build and maintain tracking across digital channels (pixels, UTMs, attribution).
• Design and maintain data pipelines feeding analytics infrastructure (Snowflake).
• Develop dashboards in Looker/Tableau to surface KPIs for leadership and teams.
• Own end-to-end customer reporting across acquisition, retention and LTV.
• Analyze performance by cohorts (acquisition period, subscriber status, product).
• Track CAC, LTV and LTV to CAC, including unit economics.
• Partner with Finance to build revenue models and forecasting accuracy.
• Lead forecasting efforts and document assumptions.
• Collaborate with Media to ensure accurate performance data.
• Leverage AI to improve reporting efficiency and insights.

Skills

SQL

Dashboarding

Data storytelling

Communication

Forecasting

Education

Bachelor’s degree in quantitative field

Tools

Looker

Tableau

Snowflake

BigQuery

Redshift

Python

R

Job description

At Open Farm we are transforming the way people feed their pets, with a focus on producing premium, healthy food and treats, all ethically sourced from farm-to-bowl. Headquarteredin Torontoand with teammembersacross the US, Open Farm is one of the fastest growing CPG companies in North America. We believe that the best foods are made with consciously sourced, top-quality ingredients from farmers and fisheries who believe in doinggood for all animals and the environment.

As Digital Analyst, you will own the tracking, data and reporting that power our digital marketing and ecommerce performance. You will work closely with Growth, Media, CRM and Finance teams to make sure our data is accurate and our dashboards are trusted, and to turn customer and campaign data into insights that guide key business decisions.

This is a role for someone with a sharp mathematical mind and a strong digital background. You will build and maintain the tracking, pipelines and dashboards behind our acquisition, retention and lifetime value reporting, and you will act as the link between marketing and Finance on the numbers. You will play a critical part in building our in house analytics capabilities as we continue to grow.

In this role you will:

• Build and maintain tracking and measurement across our digital channels, including pixels, UTMs and attribution alignment.
• Design, build and maintain data pipelines that reliably feed our analytics infrastructure, including data from Snowflake.
• Develop and optimize dashboards in Looker, Tableau or similar tools to surface marketing and ecommerce KPIs for leadership, Growth, Finance and Operations teams.
• Own end to end customer reporting across acquisition, retention and lifetime value (LTV).
• Analyze performance through cohorts built by acquisition period, subscriber status and entry product category.
• Track and report on CAC, LTV and LTV to CAC to evaluate marketing efficiency and long term ROI.
• Partner with Finance to build revenue and customer models, including cohort analysis and unit economics.
• Lead sales and customer forecasting efforts, owning the accuracy and documentation of forecasts.
• Partner with the Media team to ensure accurate performance data and clear measurement of paid channels.
• Use AI to bring efficiencies to reporting and uncover actionable insights.
• Translate complex data into clear business narratives for technical and non technical stakeholders.

We’re genuinely excited about you because you have:

• 3 to 6 years of professional experience in data analytics, business intelligence or a similar role.
• Bachelor’s degree in a quantitative field such as mathematics, statistics, computer science or economics.
• Experience building dashboards for marketing or ecommerce performance in Looker, Tableau or a similar BI platform.
• A strong understanding of digital tracking, including pixels, tags and attribution.
• Demonstrated experience building and maintaining data pipelines using SQL, ETL tools or cloud platforms.
• Strong SQL skills, with the ability to write complex queries.
• A solid grasp of CAC, LTV and LTV to CAC, along with cohort analysis and unit economics.
• Experience in ecommerce, SaaS or subscription business models is an asset.
• Familiarity with cloud data warehouses such as Snowflake, BigQuery or Redshift is an asset.
• Experience with Python, R or other scripting languages is an asset.
• A track record of working with Finance, Product and Operations teams.
• Excellent communication skills and the ability to explain insights clearly to non technical stakeholders.
• A self directed, detail oriented approach with a passion for data quality and accuracy.
• Comfort working in a fast paced ecommerce environment.

What we offer you - it's the perfect package:

• An opportunity to grow, develop, and thrive within a mission-driven, dynamic, and fast-growing company, alongside thoughtful and passionate individuals dedicated to their work and community
• Comprehensive healthcare coverage and RRSP plans with company match
• Great office culture (with lots of adorablepets!) where your pet interrupting video calls or in-person meeting is the norm
• Discounted food, apparel and insurance for your furry family members
• In addition to your PTO, we offer company-wide wellness days and personal days to support your wellbeing
• Volunteer days to give back to our community

Compensation:

The hiring range for this role is $80,000–$100,000 CAD annually, with final compensation thoughtfully aligned to your experience, skills, and the value you bring. At Open Farm, we know great people don’t always fit a mold, so role scope and compensation may evolve to reflect your unique strengths. This position may also include additional rewards such as performance-based bonuses and other incentives. We believe in growing together through a pay-for-performance approach that recognizes impact over time. Beyond compensation, we’re proud to offer a comprehensive benefits and perks package designed to support your well-being and help you feel connected, supported, and inspired at work.

AI Statement:

Open Farm may use AI tools to help organize and review applications efficiently. While technology supports our process, every hiring decision is made by our team, with care and intention. We also prioritize meaningful human connection, which is why our interview process includes in-person conversations—because technology can support the process, but can’t replace the impact of human connection.

Hybrid Work

At Open Farm, we believe in the power of collaboration, meaningful connections, and enjoying our work together—furry friends included! That’s why we’ve adopted a structured hybrid approach that allows you the benefit of a reduced commute while still building strong workplace relationships. Currently, all employees are expected to be in the office two days per week at minimum, with Tuesday and Thursday as our anchor days. In addition to this, each month our Leadership team dedicates three consecutive days onsite to continue to foster alignment and connection across the team. During this time we expect everyone to join us in person to do the same. Please note: our hybrid approach may evolve over time as we adapt to the needs of our team and business.

Vacancy Type:

New Position

Our Values

We Raise the Bar | We Open the Barn Doors | We Graze Lightly | We Are Customer Obsessed | We Are One Team | Win-Win Partnerships

Open Farm values diversity in its workforce and encourages applications from all qualified individuals. Applicants requiring a disability-related accommodation at any stage of Open Farm'srecruitment process should contact [e-mail]. As required by legislation, Open Farm will consult with applications requesting such an accommodation to ensure that Open Farm's recruitment processtakes into accounttheir accessibility needs.