Analytics Engineer II: Scalable dbt & Snowflake Modeling

Responsibilities

• We are hiring an Analytics Engineer II to join our Analytics Engineering team. This role will focus on building and maintaining scalable, well‑tested data models in dbt that power analytics and reporting across the company.
• You will work closely with Analytics and Data Engineering to expand and improve WHOOP’s data infrastructure as we scale — executing on architectural initiatives set by senior team members while developing deep expertise in our data platform.
• Develop, optimize, and maintain dbt models across WHOOP’s Snowflake data warehouse, following established patterns and coding standards.
  Execute on database restructuring initiatives — migrating domain‑specific schemas into purpose‑built databases to improve data governance and role‑based access control.
• Implement and maintain data quality tests and documentation within dbt, ensuring models are reliable, well‑documented, and discoverable.
  Partner with Analytics teams to understand data requirements and translate them into performant, accurate transformation logic.
  Collaborate with Data Engineering on data ingestion improvements, source freshness monitoring, and warehouse optimization.
  Support the team’s data governance goals, including maintaining consistent naming conventions, enforcing data contracts, and managing database roles and grants.
• Apply software engineering best practices to analytics code, including version control (Git), code review, testing, and continuous integration.
  Build domain expertise in assigned business areas, becoming the technical point of contact for data models and workflows in those domains.

• 2‑4 years of experience in analytics engineering, data engineering, or business intelligence with hands‑on dbt experience.
• Working knowledge of Git and version control workflows (branching, pull requests, code review).
• Detail‑oriented with the ability to follow established patterns and execute on well‑defined technical plans.
• Experience with dbt in a production environment — building models, writing tests, maintaining documentation, and working across multiple environments.
• Familiarity with dimensional data modeling concepts and schema design best practices.
• Strong SQL skills, particularly within Snowflake or comparable cloud data warehouses.
• Experience with Snowflake‑specific features.
• Knowledge of Python for data transformation or automation tasks.
• Familiarity with BI tools such as Sigma.
• Prior exposure to subscription/SaaS business models or consumer health/fitness data.
• Experience with CI/CD pipelines for dbt (e.g., CircleCI, Git Hub Actions, dbt Cloud).

• Flexible Vacation: WHOOP has a flexible vacation policy that allows you to unwind, laptop‑free, when you need it most.
• Focus on Family:
  We offer 18 weeks paid parental leave, plus an additional 2 weeks to gradually return to work.
• Get Invested:
  In addition to a competitive base salary and 401(k), you’re eligible to receive stock options to share in the future of WHOOP.
• WHOOP +1:
  Everyone on the team gets a complimentary WHOOP membership—plus another membership to share with a loved one.
• Health Matters:
  Our competitive benefits package covers medical, dental, and vision, in addition to mental health services, life and disability insurance, and more.
• Find Your Fit:
  Full‑time employees get $500 a year to spend on wellness in whatever way they see fit, from fitness classes and memberships, to recovery services.
• It Pays to Sleep:
  Our Sleep Performance Program incentivizes employees to get more sleep. Log an average sleep performance of 85% or higher for the month and get a $100 bonus.
• Location, Location,
  
  Location:
  
  You can’t beat the views from the rooftop of One Kenmore Square. Feel inspired daily as you work, enjoy free snacks and coffee, and collaborate in the heart of Boston.