Analytics Engineer II
Salary
$125,000 - $175,000
Location
Boston, MA
Posted
Today
Develop, optimize, and maintain dbt models across WHOOP's Snowflake data warehouse, following established patterns and coding standards.
Responsibilities
- 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.
Qualifications
- 2-4 years of experience in analytics engineering, data engineering, or business intelligence with hands-on dbt experience.
- Strong SQL skills, particularly within Snowflake or comparable cloud data warehouses.
- Experience with dbt in a production environment — building models, writing tests, maintaining documentation, and working across multiple environments.
- Working knowledge of Git and version control workflows (branching, pull requests, code review).
- Familiarity with dimensional data modeling concepts and schema design best practices.
- Detail-oriented with the ability to follow established patterns and execute on well-defined technical plans.
Nice to have
- Experience with Snowflake-specific features
- Familiarity with BI tools such as Sigma.
- Knowledge of Python for data transformation or automation tasks.
- Experience with CI/CD pipelines for dbt (e.g., CircleCI, GitHub Actions, dbt Cloud).
- Prior exposure to subscription/SaaS business models or consumer health/fitness data.
Stay informed about the latest analytics engineering opportunities. Subscribe to our weekly newsletter.