Principal Analytics Engineer

Summary

Join HubSpot's Data, Systems, & Intelligence team as a Principal Analytics Engineer and build a modern data foundation for efficient models and analyses. You will design and optimize data pipelines, foster innovation, guide team development, and partner with stakeholders to solve business problems. This role requires expert knowledge of modern data tools (Snowflake, dbt, Looker), proficiency in SQL and data modeling, and experience building complex data projects. The ideal candidate possesses a DevOps mindset, strong communication skills, and creative problem-solving abilities. HubSpot offers a competitive compensation package including base salary, commission, bonus, and potential equity, along with various benefits.

Requirements

• Expert knowledge of modern data tools (such as Snowflake, dbt, and Looker)
• Extensive proficiency in SQL, data modeling, ETL, ELT, and data transformation
• Successful experience building complex and cross-functional data projects
• Experience developing slowly changing dimension (SCD) tables from multiple sources
• Experience utilizing version control tools (such as GitHub Enterprise)
• 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
• Creative problem-solving abilities to embrace and navigate ambiguity and change
• Insatiable curiosity and interest in learning new things

Responsibilities

• Build and optimize the performance of data pipelines and analytical tools for scale
• 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
• Lead working groups, scope requirements, & usher projects through the entire lifecycle
• Maintain detailed documentation of data pipelines, processes, and best practices
• Lead major projects like our corporate financial reporting, guided support with artificial intelligence (AI), and pipeline snapshotting

Preferred Qualifications

Experience with Python and familiarity with Sales teams

Benefits

• Base salary
• On-target commission for employees in eligible roles
• Annual bonus targets under HubSpot’s bonus plan for eligible roles
• HubSpot’s equity plan to receive restricted stock units (RSUs)
• Overtime pay