Staff Analytics Engineer

HubSpot

Staff Analytics Engineer designing and building a modern data foundation for HubSpot's analytics and AI products. Optimizing data pipelines and performance for key business decisions while collaborating with cross-functional teams.

Posted 6/30/2026full-timeRemote • 🇺🇸 United StatesLead💰 $138,500 - $221,600 per yearWebsite

Tech Stack

Tools & technologies

CloudETLPythonSQL

About the role

Key responsibilities & impact

Build and optimize the performance of data pipelines and analytical tools for scale
Own and evolve core platform assets, AE tooling, reusable patterns, and automation that raise the floor for every AE on the team
Contribute to our composable agentic AE delivery system, a pipeline of AI-powered skills that automates the full delivery lifecycle from context to merged PR
Design and maintain semantic models that serve as the trusted, reusable foundation for analytics and AI consumption across the organization
Build internal AI agents and data-grounded tools, integrating RPC-based capabilities via MCP servers
Design and implement cost strategies for shared data assets, pipelines, and compute usage
Define and deploy scalable data ingestion, replication, and transfer patterns across systems
Foster innovation with emerging technologies and by staying current with industry trends
Guide professional development of the team through technical leadership
Partner with stakeholders to solve business problems with technical solutions
Build out scalable data models to analyze key parts of the HubSpot business
Expand our suite of dbt patterns and macros to enable flexible and easily extensible data structures
Drive data observability and pipeline reliability using tools like Monte Carlo
Establish scalable patterns and standards for analytical application development in Hex
Lead working groups, scope requirements, and usher projects through the entire lifecycle
Maintain detailed documentation of data pipelines, processes, and best practices

Requirements

What you’ll need

Expert knowledge of modern data tools (such as 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 ambiguous problem to production
Experience building or maintaining shared data platform assets, developer toolkits, or internal frameworks
Experience designing semantic models or metric layers for analytics or AI consumption
Proficiency with AI-assisted development tools such as Claude Code, including agentic pipeline design and composable, skill-based workflows
Comfort building AI agents and integrating external tools and services via MCP servers
Experience utilizing version control tools (such as GitHub Enterprise Cloud)
A DevOps mindset characterized by automation, collaboration, continuous improvement, and a hyperfocus on user needs and frequent iteration
Strong communication skills and ability to distill technical solutions into business terms
Experience with Python is a plus, but not required.

Benefits

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development
Bonuses
Stock options

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLData ModelingETLELTData TransformationDbtBuilding AI AgentsData Pipeline DesignVersion ControlData Observability

Soft Skills

Strong Communication SkillsTechnical LeadershipCollaboration