Lead Data/Analytics Engineer

Build, maintain, and optimize ELT pipelines using dbt, Prefect and Fivetran

Own core datasets and dbt models in Snowflake in partnership with the BI and product engineering teams

Lead infrastructure modernization: orchestration and dbt version upgrades, flow runtime reduction, Snowflake compute and storage cost optimization

Drive warehouse security and governance work, including access controls, remediation of security assessment findings, and PII handling

Implement data quality tests, freshness checks, observability, and alerting across critical pipelines

Troubleshoot pipeline failures and data incidents, and drive root-cause fixes rather than patches

Deliver ready-to-consume data marts that power product features such as recommendations and personalization, plus the baselines to measure them

Contribute to the semantic layer that gives BI tools and AI features a single source of truth for metric definitions

Supply reliable, well-governed data to AI features that improve the member experience and vet workflows

Define and document the company’s core metrics so every team calculates things the same way

6+ years of experience in analytics engineering, data engineering, or hybrid data roles

Strong proficiency in SQL and Python

Deep hands-on experience with Snowflake or a comparable cloud data warehouse

Production experience with dbt, including testing, documentation, and CI

Experience with product analytics platforms, ideally Amplitude, including funnels, cohorts, experiment configuration, and identity resolution

Experience with customer data platforms and event pipelines, ideally Segment, including tracking plan design, destination management, and debugging

Demonstrated experience designing and analyzing A/B tests or product experiments

Experience with orchestration tools such as Prefect, Airflow, or Dagster

Comfortable with Git-based workflows and CI/CD tools such as GitHub Actions

Uses AI tools (code assistants, LLMs, etc.) as part of daily work and can show how

Familiarity with BI tools like Sigma, Looker, or Tableau

Bonus: experience with semantic layers, data contracts, ML/LLM applications in production, or cloud infrastructure (AWS, GCP, or Azure)

You treat trust in the numbers as the product. When a metric is wrong, you feel it personally

You can build an event taxonomy from scratch and also explain to a PM why their experiment needs a bigger sample size

You’re as comfortable writing dbt models as you are reviewing an experiment readout with a product lead

You use AI tools every day to move faster and expect to keep pushing that boundary

You’re self-directed and comfortable managing your own priorities in a fast-moving environment

You care about data quality, reproducibility, and documentation because you’ve been burned by their absence

You love animals

Competitive salary range between $185K - $220K CAD

Hybrid working location

Health, Dental and Vision Insurance

Life and Disability Insurance

Flexible PTO

Mental Wellbeing Options

Robust Holiday Schedule

Registered Retirement Savings Plan

Growth Opportunities!

Pets First – business and medical decisions are always guided by the pet’s best interest. We’ll never compromise on pet health and we’re all here because we care about their well-being

Agile Like a Cat – We have a bias toward swift action, while maintaining quality and accuracy. For us, that means being able to turn on a dime, like a cat, analyze our options – even ones that may not be on the table – then execute without perfection getting in the way

Creativity is our Catnip – Creativity feeds us and helps us push boundaries to always find better solutions, making the complex more accessible and easier to understand

Be the Human Your Dog Thinks You Are – Be kind, show care for your colleagues, and even if you’re an expert - give others context, reinforce the positive, and help them understand.