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