Analytics Engineer: Data Pipelines, Models & Dashboards

HireStakes; Orpington; On-site; GBP 60,000 - 90,000; Full time

Job summary

HireStakes is hiring an Analytics Engineer to join their lean data team, reporting to the Head of Data. This role covers the full data lifecycle, from ingestion and modelling through to dashboards and insight.

You'll design end-to-end data pipelines, build data models with dbt on BigQuery, and develop dashboards in Looker Studio and Metabase, collaborating with engineering, product and commercial teams to turn business requirements into data solutions.

Qualifications

• Hands-on experience with GCP, especially BigQuery.
• Proficiency in dbt with testing, documentation and dimensional modelling.
• Strong Python skills for data extraction and automation.
• Advanced SQL, including window functions and query optimisation.
• Experience with Git and CI/CD workflows.
• Experience building dashboards in Looker Studio or Metabase.

Responsibilities

• Design, build, test and maintain end to end data pipelines.
• Build clean, tested and documented data models using dbt and BigQuery.
• Write Python scripts to extract data from third party APIs and orchestrate workflows.
• Build reports, dashboards and KPI scorecards in Looker Studio and Metabase.
• Collaborate with engineering, product and commercial teams to translate requirements into data solutions.
• Identify data quality issues and performance improvements across the data platform.

Skills

BigQuery

dbt

Python

SQL

Looker Studio

Metabase

Data pipelines

CI/CD

Git

Cloud Run

Datastream

Tools

GCP

Datastream

Looker Studio

Job description

HireStakes is hiring an Analytics Engineer to join their lean data team, reporting to the Head of Data. This role covers the full data lifecycle, from ingestion and modelling through to dashboards and insight.

You'll design end-to-end data pipelines, build data models with dbt on BigQuery, and develop dashboards in Looker Studio and Metabase, collaborating with engineering, product and commercial teams to turn business requirements into data solutions.