Analytics Engineer | dbt, BigQuery & Looker

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

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.