Senior Analytics Engineer II

Summary

Join HubSpot's Data, Systems, & Intelligence team as an Analytics Engineer and build a modern data foundation for efficient models and analyses. You will collaborate with technical and non-technical teams, build scalable data models, establish best practices, support distributed operations teams, perform root cause analysis, expand dbt patterns, scope requirements, and lead working groups. This role requires several years of hands-on SQL experience, relational databases, data modeling, and strong communication skills. You will contribute to HubSpot's long-term data strategy and mentor other analytics engineers. HubSpot offers a flexible work environment with opportunities for in-person collaboration and professional development.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

Snowflake, dbt, and/or Looker experience

Benefits

• Flexible work environment
• In-person onboarding and events
• Accommodations for travel limitations