Staff Analytics Engineer

Overview

Staff Analytics Engineer on HubSpot’s Data & AI Foundations team, building a modern data foundation for efficient models and analyses.

What you'll do

• Build and optimize performance of data pipelines and analytical tools for scale.
• Own and evolve core platform assets, AE tooling, reusable patterns, and automation.
• Design and maintain semantic models that serve analytics and AI consumption.
• Build internal AI agents and data-grounded tools using RPC-based capabilities via MCP servers.
• Define and deploy scalable data ingestion, replication, and transfer patterns.
• Drive data observability and pipeline reliability using Monte Carlo.
• Lead working groups, scope requirements, and shepherd projects end to end.

What you'll need

• Expert knowledge of modern data tools including Snowflake, dbt, and Looker.
• Extensive proficiency in SQL, data modeling, ETL/ELT, and data transformation.
• Deep dbt expertise including advanced modeling patterns, macros, and package development.
• Experience developing slowly changing dimension (SCD) tables from multiple sources.
• Successful experience leading complex, cross-functional data initiatives from ambiguity to production.
• Experience designing semantic models or metric layers for analytics/AI consumption.

Details

• Location: Remote - USA.
• Annual cash compensation range: $138,500 — $221,600 USD.