Analytical Engineer

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 working with a fast growing subscription entertainment platform that has recently launched internationally and has an ambitious product and tech roadmap ahead.

They're looking for an Analytics Engineer to join their lean data team, reporting to the Head of Data. This is a varied role covering the full data lifecycle, from ingestion and modelling through to dashboards and insight.

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
• Work with engineering, product and commercial teams to turn business requirements into data solutions
• Identify data quality issues and performance improvements across the data platform

Requirements

• Strong hands on experience with GCP, particularly BigQuery, Cloud Run and Datastream
• Proficiency in dbt, including testing, documentation and dimensional modelling
• Solid Python skills for data extraction and automation
• Advanced SQL, including window functions, query optimisation and BigQuery cost management
• Experience with Git and CI/CD workflows
• Experience building dashboards in Looker Studio or Metabase
• Experience in a scale up, ecommerce, subscription or consumer business is a plus