Staff Analytics Engineer

H
HubSpotData analytics
Location: Remote - USAFull-TimeStaff
Salary138,500 - 221,600 USD per year
Apply NowOpens the employer's application page

Job Details

Required Skills
PythonSQLETLSnowflakeData modelingdbtLooker

Requirements

  • Have expert knowledge of modern data tools such as Snowflake, dbt, and Looker.
  • Bring extensive proficiency in SQL, data modeling, ETL, ELT, and data transformation.
  • Have deep dbt expertise, including advanced modeling patterns, macros, and package development.
  • Have experience developing slowly changing dimension (SCD) tables from multiple sources.
  • Have successfully led complex, cross-functional data initiatives from ambiguous problem to production.
  • Have experience building or maintaining shared data platform assets, developer toolkits, or internal frameworks.
  • Have experience designing semantic models or metric layers for analytics or AI consumption.
  • Be proficient with AI-assisted development tools such as Claude Code, including agentic pipeline design and composable, skill-based workflows.
  • Be comfortable building AI agents and integrating external tools and services via MCP servers.
  • Have experience with version control tools such as GitHub Enterprise Cloud.
  • Bring a DevOps mindset focused on automation, collaboration, continuous improvement, user needs, and frequent iteration.
  • Be able to communicate technical solutions in business terms.
  • Python experience is a plus, but is not required.

Responsibilities

  • Build and optimize data pipelines and analytical tools for scale.
  • Own and evolve core platform assets, analytics engineering tooling, reusable patterns, and automation.
  • Contribute to an AI-powered analytics engineering delivery system that automates the delivery lifecycle.
  • Design and maintain semantic models for analytics and AI consumption.
  • Build internal AI agents and data-grounded tools, integrating RPC-based capabilities via MCP servers.
  • Design cost strategies for shared data assets, pipelines, and compute usage.
  • Define scalable data ingestion, replication, and transfer patterns across systems.
  • Expand dbt patterns and macros, and drive data observability and pipeline reliability using tools such as Monte Carlo.
  • Establish standards for analytical application development in Hex and lead projects through their lifecycle.
  • Partner with stakeholders, guide team development, and maintain documentation of pipelines, processes, and best practices.
View Full Description & ApplyYou'll be redirected to the employer's site
138,500 - 221,600 USD per year
Apply Now