Analytics Engineer

Harnham - Data and Analytics Recruitment; Greater London; Hybrid; GBP 70,000 - 80,000; Full time

Job summary

Harnham – Data and Analytics Recruitment is seeking an Analytics Engineer for a global organisation in London. You will own the modeled data layer, using dbt and BigQuery to build data products for reporting and self‑service analytics.

Collaborate across Data Engineering and analysts, evolve the data warehouse, and shape best practices for data modelling, quality and documentation. Hybrid London role offering £70,000-£80,000 plus benefits.

Qualifications

• 3+ years' experience across Analytics Engineering, Data Engineering or BI Development.
• Strong SQL skills with experience building production data models.
• Hands-on experience with dbt, including models, tests and documentation.
• Experience with Looker/LookML or a similar BI platform.

Responsibilities

• Design, build and maintain staging, mart and analytics models using dbt and BigQuery.
• Develop scalable data models supporting multiple regions and entities.
• Build and maintain data models powering Looker/LookML.
• Implement data quality through dbt testing, monitoring and alerting.
• Work with Data Engineering around upstream dependencies and data contracts.
• Maintain data lineage, documentation and metric definitions.
• Review SQL and dbt work and help improve modelling standards.
• Optimise query performance, costs and deployment workflows.
• Support the use of AI / LLM tools on top of well‑modelled data.

Skills

SQL

Analytics Engineering

BI Development

Data Modeling

Tools

dbt

BigQuery

Looker/LookML

Python

Airflow/Cloud Composer

Git

Job description

Analytics Engineer (DBT, GCP, LOOKER)

Permanent Role

£70,000-£80,000 + Benefits
London - Hybrid (3 days per week)

I am currently recruiting for anAnalytics Engineer to join a leading global organisation within their growing Data & Analytics function.

This is a hands‑on role where you will take ownership of themodelled data layer, working withdbt and BigQuery to build the data products that underpin reporting, self‑service analytics and data activation across the business.

You will work closely with Data Engineering, analysts and wider stakeholders, helping to evolve the data warehouse into a scalable global platform and shaping best practices around data modelling, quality and documentation.

The Role:

• Design, build and maintainstaging, mart and analytics models using dbt and BigQuery
• Develop scalable data models supporting multiple regions and entities
• Build and maintain data models poweringLooker / LookML
• Implement data quality throughdbt testing, monitoring and alerting
• Work with Data Engineering around upstream dependencies and data contracts
• Maintain data lineage, documentation and metric definitions
• Review SQL and dbt work and help improve modelling standards
• Optimise query performance, costs and deployment workflows
• Support the use ofAI / LLM tools on top of well‑modelled data

What we're looking for:

• 3+ years' experience acrossAnalytics Engineering, Data Engineering or BI Development
• StrongSQL skills with experience building production data models
• Hands‑on experience withdbt, including models, tests, macros and documentation
• Strong production experience withBigQuery
• Experience usingPython for data work and automation
• Experience withAirflow or Cloud Composer
• Strong understanding ofdimensional data modelling
• Experience withLooker / LookML or a similar BI platform
• Good understanding ofGit and modern data development practices

Desirable:

• WiderGCP experience
• Experience working withKafka / event data
• Experience migrating or restructuring data warehouses
• Experience supporting global or multi‑region data platforms
• Interest inAI / LLM applications within data and analytics