Senior Analytics Engineer

Summary

Join HubSpot's fast-growing Product Operations team as a Senior Analytics Engineer. You will be a key contributor, building and maintaining high-value data assets, defining analytics development strategies, and enabling team excellence in a remote, global environment. Collaborate with cross-functional stakeholders to solve critical business problems, develop scalable data models, and curate reporting environments. You will also define coding standards, lead projects, and train colleagues. This role requires extensive experience with SQL, cloud data warehouses, and data pipeline optimization. HubSpot offers a competitive compensation package and benefits.

Requirements

• Lead 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
• 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)
• 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

Responsibilities

• 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

Preferred Qualifications

• 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
• 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)
• 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

Benefits

• Cash compensation range: 118500-189600 USD Annually
• 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
• Remote work
• In-person onboarding
• In-person events such as HubSpot’s annual PEER week, your Product Group Summit, and other in-person gatherings