Skip to content

Principal Analytics Engineer, DSI

Salary

$138,500 - $221,600

Location

Remote - USA

HubSpot's mission is to Help Millions of Organizations Grow Better. HubSpot's Operations team is core to this goal by supporting the HubSpotters who attract, engage, and delight HubSpot's customers. Our goal in Operations is to embed advanced analytics and algorithmic intelligence into the DNA of decision-making across Flywheel. Flexible, well-connected, well-architected data are the backbone of our strategy, along with the Analytics Engineers who create that landscape.

We believe in the power of data to drive effective decision-making. We leverage data for both day-to-day operations (improving efficiency by surfacing the right data at the right time) and for strategy (fostering deep understanding of what makes our flywheel spin, and projecting how to spin it faster in the future). In this role, you'll be a member of the Data, Systems, & Intelligence team to design and build a modern data foundation for efficient models and analyses. Your work will directly support analytic and ML products that will change the way we make decisions within Flywheel at HubSpot.

We're looking for Analytic Engineers with a strong interest in building and maintaining flexible, reusable architecture for our highest value data assets. In this role, you will develop a deep understanding of the business and analytics priorities to create solutions that will unlock our ability to scale and drive actionable insights.

In this role, you'll get to:

  • 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

We are looking for someone with:

  • 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
  • Experience with Python and familiarity with Sales teams are a plus, but not required