Senior Analytics Engineer II

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:

• Collaborate with both technical and non-technical areas of the business, bridging the gap between the business problem and the technical solution
• Build out scalable data models to analyze key parts of the HubSpot business
• Establish and uphold technical best practices in maintaining the data infrastructure and and contribute to the company's long term data strategy
• Support distributed operations teams as they utilize these foundational data models for reporting
• Perform complex root cause analysis of problems and subsequently, makes and implements recommendations to prevent future occurrences
• Expand our suite of dbt patterns and macros to enable flexible and easily extensible data structures
• Scope requirements with internal stakeholders and lead working groups to usher projects through their entire lifecycle while building clear roadmaps for cross-functional team members
• Learn from our team of Analytics engineers, as well as HubSpot’s greater AE community
• Mentor and upskill other analytics engineers to create an inclusive team environment while promoting diversity, inclusion and belonging

We are looking for people who have:

• Several years of hands-on SQL experience, relational databases, and data modeling
• Ability to document technical design documents and organizational skills
• Proven communication skills and ability to bridge between business leaders, engineers, and data scientists
• Experience distilling complex ideas and data for both executives and front-line reps
• Creative problem solving skills to identify flexible solutions to business questions
• Insatiable curiosity and interest in learning new things
• Snowflake, dbt, and/or Looker experience