Analytics Engineer: Build Scalable Data Models & BI

Harnham; Greater London; On-site; GBP 70,000 - 90,000; Full time

Job summary

Harnham is seeking an Analytics Engineer to own core analytics data models and support reporting, self-service analytics, and wider data initiatives across an international organisation.

You will build and maintain analytics data models with dbt and BigQuery, create scalable datasets, and develop data pipelines while collaborating with analysts and stakeholders to deliver data solutions and governance.

Qualifications

• Strong commercial experience in Analytics Engineering, Data Engineering, or Business Intelligence development.
• Advanced SQL skills with a focus on performance and optimisation.
• Hands-on experience with dbt, including modelling, testing, and documentation.
• Experience working with Google BigQuery in production environments.
• Python experience for data processing, automation, or analytics workflows.
• Experience building and maintaining pipelines using Airflow or similar orchestration tools.
• Strong understanding of dimensional data modelling and analytics best practices.
• Experience supporting BI and reporting platforms such as Looker.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• A quality-focused approach to testing, documentation, and data governance.

Responsibilities

• Designing, developing, and maintaining analytics and reporting data models using dbt and BigQuery.
• Creating scalable, high-quality datasets that support business reporting and decision-making.
• Developing and maintaining data pipelines and workflows.
• Implementing testing, monitoring, and documentation standards to improve data quality and reliability.
• Working closely with analysts, engineers, and business stakeholders to understand requirements and deliver data solutions.
• Supporting and enhancing Looker reporting capabilities and self-service analytics.
• Managing upstream dependencies and helping establish strong data governance practices.
• Driving continuous improvements across data modelling, automation, performance, and deployment processes.

Skills

Analytics Eng

SQL Performance

dbt Modelling

BigQuery

Python Data

Airflow

Dimensional Modelling

Looker

Stakeholder Comm

Tools

dbt

BigQuery

Airflow

Looker

Python

Job description

Harnham is seeking an Analytics Engineer to own core analytics data models and support reporting, self-service analytics, and wider data initiatives across an international organisation.

You will build and maintain analytics data models with dbt and BigQuery, create scalable datasets, and develop data pipelines while collaborating with analysts and stakeholders to deliver data solutions and governance.