Senior Analytics Engineer

Product Operations Senior Analytics Engineer

Product Operations is a fast-growing, global team of data-driven influencers, setting the standard for how data and analytics is used at HubSpot, and inspiring product teams to action. We draw from multiple sources of data (user event data, NPS, transactional data, etc) to discover what is going well, where we can improve, and what to build next, partnering with Product Management, User Experience, and Engineering leadership to build better solutions for our customers.

The Senior Analytics Engineer serves as a force multiplier for the broader Prod Ops org: building and maintaining our highest value data assets; defining and implementing team strategy for analytics development processes; and enabling the team to operate with a consistent level of excellence as we scale in a remote, global environment. In this role, you will work cross functionally, developing a deep understanding of the business and analytics priorities for the Prod Ops org to motivate solutions that will unlock our ability to scale and drive actionable insights - from refining and extending our data models, to refactoring tables, to building new assets and training content. You will collaborate with distributed analysts across the company to drive alignment on key business logic and metric definitions, influence the evolution of our core analytics infrastructure, and contribute to HubSpot’s library of best practices.

In this role, you’ll get to:

• Collaborate with technical and non-technical stakeholders, bridging the gap between business problem and technical solution
• Own and champion Product Operations’ “crown jewel” data assets that answer HubSpot’s most critical operational questions, reinforcing them as Source of Truth across the organization
• Develop scalable data models that enable performant analysis into Hubspot’s products and business
• Curate, organize and document Product Operations data and reporting environments across Looker, dbt and Amplitude
• Collaborate closely with Hubspot’s BI and Data Engineering teams to expand data access and availability
• Codify and democratize best practices for SQL query optimization/reusability and reporting, leveraging HubSpot’s data assets, and analytics development within Snowflake SQL, dbt, LookML, and git
• Define teamwide coding standards, documentation requirements and development processes (code reviews, testing requirements, etc)
• 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

We are looking for people with experience in the following areas:

Basic Qualifications:

Development

• Leading the technical execution of high complexity business intelligence and analytics projects in code with the use of CTEs, nested queries, or other similar techniques
• Experience with complex datasets and computer science fundamentals, including software development lifecycle (SDLC)
• Experience building and optimizing data pipelines, architectures and data sets; experience diagramming architecture and entity relationships with Lucidcharts (for example)
• Understanding of multi-step ETL and ELT jobs / data pipelines and working with job scheduling systems, with an ability to reverse engineer and refactor existing technical projects

Analytics

• Strong understanding of the analyst’s workflow as it relates to both structured and unstructured datasets
• Exceptional ability to document technical designs
• 3+ years of hands on experience experience with advanced SQL (writing and optimizing), cloud data warehouses (eg Snowflake, Redshift, Bigquery) and relational databases
• Ability to collaborate through code-management/version control tools like GitHub Enterprise (for peer-reviews, feature branches, resolving conflicts and commits)

Team Enablement

• Experience training and onboarding colleagues (especially at-scale, or in a remote-first or global environment)
• Effective communication across multiple modes (video, wikis, decks, guided exercises) and a knack for choosing the best format for the task and audience at hand
• Writing and reviewing end-user and technical documents, including requirements and design documents for existing and future data systems, as well as data standards and policies

Preferred Qualifications:

Development

• Exposure to data pipeline and workflow management tools (i.e. Airflow, Google Cloud Composer, Luigi, etc)
• Experience with script based analytic transformation tools (dbt, AWS Glue, Talend, etc)
• 2+ years of experience with data quality and validation exercises in data science, business analytics, business intelligence (BI), or comparable big data “like” environments

Analytics

• Experience with JSON Flattening and extracting internal elements
• Conceptual knowledge of Looker (LookML, Looks and Dashboards) or equivalent BI visualization tool (e.g. Tableau, Qlik, Power Bi)

Team Enablement

• Experience identifying and driving process improvements around data use to drive team effectiveness
• Best practice definition: identifying the minimal set of rules for the greatest teamwide gains in clarity, accuracy, discoverability, and reusability
• Patience, empathy, finding success in the team’s success

Cash compensation range: 118500-189600 USD Annually

This resource will help guide how we recommend thinking about the range you see. Learn more about HubSpot’s compensation philosophy.

The cash compensation above includes base salary, on-target commission for employees in eligible roles, and annual bonus targets under HubSpot’s bonus plan for eligible roles. In addition to cash compensation, some roles are eligible to participate in HubSpot’s equity plan to receive restricted stock units (RSUs). Some roles may also be eligible for overtime pay. Individual compensation packages are based on a few different factors unique to each candidate, including their skills, experience, qualifications and other job-related reasons.

We know that benefits are also an important piece of your total compensation package. To learn more about what’s included in total compensation, check out some of the benefits and perks HubSpot offers to help employees grow better.

At HubSpot, fair compensation practices isn’t just about checking off the box for legal compliance. It’s about living out our value of transparency with our employees, candidates, and community.

Product Operations Senior Analytics Engineer

Product Operations is a fast-growing, global team of data-driven influencers, setting the standard for how data and analytics is used at HubSpot, and inspiring product teams to action. We draw from multiple sources of data (user event data, NPS, transactional data, etc) to discover what is going well, where we can improve, and what to build next, partnering with Product Management, User Experience, and Engineering leadership to build better solutions for our customers.

The Senior Analytics Engineer serves as a force multiplier for the broader Prod Ops org: building and maintaining our highest value data assets; defining and implementing team strategy for analytics development processes; and enabling the team to operate with a consistent level of excellence as we scale in a remote, global environment. In this role, you will work cross functionally, developing a deep understanding of the business and analytics priorities for the Prod Ops org to motivate solutions that will unlock our ability to scale and drive actionable insights - from refining and extending our data models, to refactoring tables, to building new assets and training content. You will collaborate with distributed analysts across the company to drive alignment on key business logic and metric definitions, influence the evolution of our core analytics infrastructure, and contribute to HubSpot’s library of best practices.

In this role, you’ll get to:

• Collaborate with technical and non-technical stakeholders, bridging the gap between business problem and technical solution
• Own and champion Product Operations’ “crown jewel” data assets that answer HubSpot’s most critical operational questions, reinforcing them as Source of Truth across the organization
• Develop scalable data models that enable performant analysis into Hubspot’s products and business
• Curate, organize and document Product Operations data and reporting environments across Looker, dbt and Amplitude
• Collaborate closely with Hubspot’s BI and Data Engineering teams to expand data access and availability
• Codify and democratize best practices for SQL query optimization/reusability and reporting, leveraging HubSpot’s data assets, and analytics development within Snowflake SQL, dbt, LookML, and git
• Define teamwide coding standards, documentation requirements and development processes (code reviews, testing requirements, etc)
• 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

We are looking for people with experience in the following areas:

Basic Qualifications:

Development

• Leading the technical execution of high complexity business intelligence and analytics projects in code with the use of CTEs, nested queries, or other similar techniques
• Experience with complex datasets and computer science fundamentals, including software development lifecycle (SDLC)
• Experience building and optimizing data pipelines, architectures and data sets; experience diagramming architecture and entity relationships with Lucidcharts (for example)
• Understanding of multi-step ETL and ELT jobs / data pipelines and working with job scheduling systems, with an ability to reverse engineer and refactor existing technical projects

Analytics

• Strong understanding of the analyst’s workflow as it relates to both structured and unstructured datasets
• Exceptional ability to document technical designs
• 3+ years of hands on experience experience with advanced SQL (writing and optimizing), cloud data warehouses (eg Snowflake, Redshift, Bigquery) and relational databases
• Ability to collaborate through code-management/version control tools like GitHub Enterprise (for peer-reviews, feature branches, resolving conflicts and commits)

Team Enablement

• Experience training and onboarding colleagues (especially at-scale, or in a remote-first or global environment)
• Effective communication across multiple modes (video, wikis, decks, guided exercises) and a knack for choosing the best format for the task and audience at hand
• Writing and reviewing end-user and technical documents, including requirements and design documents for existing and future data systems, as well as data standards and policies

Preferred Qualifications:

Development

• Exposure to data pipeline and workflow management tools (i.e. Airflow, Google Cloud Composer, Luigi, etc)
• Experience with script based analytic transformation tools (dbt, AWS Glue, Talend, etc)
• 2+ years of experience with data quality and validation exercises in data science, business analytics, business intelligence (BI), or comparable big data “like” environments

Analytics

• Experience with JSON Flattening and extracting internal elements
• Conceptual knowledge of Looker (LookML, Looks and Dashboards) or equivalent BI visualization tool (e.g. Tableau, Qlik, Power Bi)

Team Enablement

• Experience identifying and driving process improvements around data use to drive team effectiveness
• Best practice definition: identifying the minimal set of rules for the greatest teamwide gains in clarity, accuracy, discoverability, and reusability
• Patience, empathy, finding success in the team’s success

Cash compensation range: 118500-189600 USD Annually

This resource will help guide how we recommend thinking about the range you see. Learn more about HubSpot’s compensation philosophy.

The cash compensation above includes base salary, on-target commission for employees in eligible roles, and annual bonus targets under HubSpot’s bonus plan for eligible roles. In addition to cash compensation, some roles are eligible to participate in HubSpot’s equity plan to receive restricted stock units (RSUs). Some roles may also be eligible for overtime pay. Individual compensation packages are based on a few different factors unique to each candidate, including their skills, experience, qualifications and other job-related reasons.

We know that benefits are also an important piece of your total compensation package. To learn more about what’s included in total compensation, check out some of the benefits and perks HubSpot offers to help employees grow better.

At HubSpot, fair compensation practices isn’t just about checking off the box for legal compliance. It’s about living out our value of transparency with our employees, candidates, and community.

We know the confidence gap* and* imposter syndrome can get in the way of meeting spectacular candidates, so please don’t hesitate to apply — we’d love to hear from you.

**If you need accommodations or assistance due to a disability, please reach out to us using this form.* This information will be treated as confidential and used only for the purpose of determining an appropriate accommodation for the interview process.*

*At HubSpot, we value both flexibility and connection. Whether you’re a Remote employee, or work from the Office, we want you to start your journey here by building strong connections with your team and peers. *

If you are joining our Engineering team in a full-time role, you will be required to attend a regional HubSpot office for in-person onboarding. If you join our broader Product team, you’ll also attend other in-person events such as HubSpot’s annual PEER week, your Product Group Summit, and other in-person gatherings to continue building on those connections.

If you require an accommodation due to travel limitations or other reasons, please inform your recruiter during the hiring process. We are committed to supporting candidates who may need alternative arrangements.

**Germany Applicants:* (m/f/d) - link to HubSpot's Career Diversity page here.*

**India* Applicants: link to HubSpot India's equal opportunity policy here.*

About HubSpot

HubSpot (NYSE: HUBS) is a leading customer relationship management (CRM) platform that provides software and support to help businesses grow better. We build marketing, sales, service, and website management products that start free and scale to meet our customers’ needs at any stage of growth. We’re also building a company culture that empowers people to do their best work. If that sounds like something you’d like to be part of, we’d love to hear from you.

You can find out more about our company culture in the HubSpot Culture Code, which has more than 5M views, and learn about our commitment to creating a diverse and inclusive workplace, too. Thanks to the work of every employee globally, HubSpot was named the #2 Best Place to Work on Glassdoor in 2022 and has been recognized for its award-winning culture by Great Place to Work, Comparably, Fortune, Entrepreneur, Inc., and more.

Headquartered in Cambridge, Massachusetts, HubSpot was founded in 2006. Today, thousands of employees across the globe work remotely and in HubSpot offices. Visit our careers website to learn more about the culture and opportunities at HubSpot.

By submitting your application, you agree that HubSpot may collect your personal data for recruiting, global organization planning, and related purposes. HubSpot's *Privacy Notice** explains what personal information we may process, where we may process your personal information, our purposes for processing your personal information, and the rights you can exercise over HubSpot’s use of your personal information.*