Match score not available

Analytics Engineer

Remote: 
Full Remote
Experience: 
Mid-level (2-5 years)
Work from: 

Offer summary

Qualifications:

3+ years of experience in data analysis and SQL, High proficiency with Google Cloud Platform, Experience with data modeling using DBT/Dataform, Strong capability to build scalable data solutions.

Key responsabilities:

  • Maintain and develop data flow into Hubspot
  • Own and improve the data pipeline to BigQuery
Pinpoint Applicant Tracking System logo
Pinpoint Applicant Tracking System https://www.pinpointhq.com/
51 - 200 Employees
See all jobs

Job description

Hi 👋 I'm Freddie, VP of Strategy + RevOps.


We're a high-growth, HR-tech start-up building and selling software that helps in-house recruitment teams attract, hire, and onboard the right talent. Today, we have a strong foundation in place, with a mature product, strong product-market fit, and happy customers.

Our RevOps team drives data operations at Pinpoint, wrangling data pipelines and models that power teams across the business. Over the past year, we've worked on internal and external product data to produce vital insights for the Customer Success team, assist in product decision-making, and inspire marketing content.


With our data responsibilities expanding and existing infrastructure requiring maintenance, we need someone to show us what "great" looks like—setting the standard for data at Pinpoint.

You'll ensure our pipelines are scalable and robust, all while creating new ways to analyze our data and derive insights.


A few things to know before applying:

  • While we're a highly technical RevOps function, you won't have dedicated Data Architects, Engineers, or Analysts at your disposal. You'll need to thrive with limited supporting resources, ready to get stuck in at all levels to get the job done.
  • Our values shape who we are and how we work. We're excited to meet candidates who share these principles and will bring them to life in their work.
  • This UK-based role is mostly remote, with in-person team meetups a few times per quarter. Our headquarters is in Jersey, UK, and we have a distributed remote team of 80 members spanning the UK and the U.S.


About the Role:

  • Sit at the crucial intersection of Customer Success, Product/Engineering, and RevOps to maintain and develop the flow of data into Hubspot and beyond, ensuring we have the data needed to drive customer campaigns, spot signs of churn risk, and identify upsell opportunities. You won't just provide data—you'll help us understand why it's important and how to interpret it.
  • Own the pipeline between production and BigQuery, diagnosing and fixing issues to ensure optimum reliability.
  • Improve the data transformation pipeline (using DataForm for controlled changes and issue visibility).
  • Build a data dictionary and understand data locality (e.g., where to find details for specific features, required logic, etc.). Set design principles for the reporting layer, establishing standards for how we structure this data to ensure consistency.
  • Work closely with Product and Engineering teams to stay on top of changes and releases, translating them into the reporting layer. Participate in data design conversations during product development to ensure data capture and raw output are factored in
  • Act as the lead on our external RecTrends site. In addition to owning the pipeline behind it, you'll manage regular updates and develop new data points and visualizations to showcase our product data. You'll also help the team draw insights and interpret the data creatively.


Tech Stack: GCP, Stitch, Hightouch, Hubspot


About You:

  • 3+ years commercial experience with data analysis and SQL, including data modeling (DBT/Dataform)
  • High proficiency with Google Cloud Platform and data tooling like Segment, Posthog, Stitch, Fivetran and Hightouch
  • Strong ability to architect scalable data solutions and combine data from multiple sources
  • Excellent communication skills - you can explain complex technical concepts to diverse stakeholders
  • Strategic mindset to prioritize high-impact work in a fast-paced environment
  • Proven track record demonstrating our core values
  • Based in the UK with work authorization


FAQs


What is the current state of analytics engineering at Pinpoint? Will the successful applicant have to build everything from scratch?

Pinpoint already has several key dashboards and metrics created in Hubspot that need reviewing and improving. While reporting datasets in BigQuery have been initiated, they require management to ensure a standard structure and naming convention, making them more usable. The role will also involve building new pipelines, dashboards, and metrics based on organizational needs. You will not be starting from scratch but will need to focus on standardizing and improving the existing systems while building new capabilities as required.


Are people currently doing things in Excel, or are there legacy systems in place?

Pinpoint primarily uses modern data integration and analytics tools. FiveTran and Stitch are used to extract data from source systems into BigQuery, where data transformation is performed to create reporting views or views for ingestion into Hubspot. Hightouch is then used to feed this data into Hubspot. Reporting is typically done in either Hubspot or Looker Studio, depending on the specific use case. However, in some instances, spreadsheets might still be the most effective solution for specific problems. You will need to evaluate the best tool for each scenario and avoid over-engineering solutions.


What kind of reporting will the analytics engineer be producing? Is it mostly around sales and marketing figures?

The primary focus of this role will be to make product usage data accessible to Customer Success Managers (CSMs) for customer conversations and driving automated actions. This requires working end-to-end, from understanding source data with engineering teams to landing the data in BigQuery, transforming it, and feeding it back into Hubspot or Looker dashboards. Additionally, the role will involve providing insights for Marketing to highlight how product usage has delivered value and to identify emerging trends. A significant responsibility will be owning and managing the underlying data pipeline and transformation processes.


What tools and technologies does Pinpoint currently use for analytics?

Our cloud platform of choice is Google Cloud Platform (GCP), and it uses data integration tools such as FiveTran, Stitch, and Hightouch. Data transformation is managed within BigQuery and DataForm, while reporting is handled through Hubspot and Looker Studio.


What are the immediate priorities for this role?

The immediate priorities for this role include reviewing and improving existing dashboards and metrics in Hubspot, as well as standardizing and managing reporting datasets in BigQuery. You will also need to develop new data pipelines, dashboards, and metrics to meet evolving organizational needs. Ensuring that product usage data is easily accessible and actionable for both the Customer Success and Marketing teams will also be a critical focus area.

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Problem Reporting
  • Strategic Thinking
  • Communication

Related jobs