Digital Analyst

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. Headquartered in Toronto and 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.

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

• 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, Big Query 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.

• An opportunity to grow, develop, and…