Skills

Python Data Analysis SQL Marketing Analytics Analytical Thinking GCP

Job Specifications

Role: Analytics Engineer

Location: London / Birmingham / Bristol - Any location (Hybrid 3 days onsite, 2 days remote)

Duration: 6 Months

Day rate: £450 - £600 Inside IR35

Role Overview

We are seeking an experienced Analytics Engineer to design and build scalable analytical data models that support business intelligence, reporting and commercial analytics.

The role sits within a multidisciplinary data team responsible for delivering trusted analytical data products used across commercial and marketing teams.

The ideal candidate will combine strong analytical thinking with advanced SQL engineering capability, and will have experience designing analytics-ready datasets used by BI tools or semantic layers. This is not a pipeline engineering role; we are looking for someone experienced in building analytical data models that define consistent business metrics and enable self-service analytics.

Key Responsibilities

Analytical Data Modelling

Design and implement scalable analytical data models in SQL used by BI tools and analytics platforms.
Build datasets that support consistent business metrics, reporting and analysis.
Implement modelling approaches such as star schemas, denormalised analytical tables and reusable metric layers.

Data Analysis & Profiling

Profile complex datasets to understand data structure, quality and business meaning.
Investigate and interpret source data to inform robust analytical modelling decisions.
Translate business questions into well-structured analytical datasets.

SQL Engineering

Develop robust SQL transformations to convert raw source data into trusted analytical assets.
Ensure analytical models are scalable, performant and maintainable within a cloud data warehouse.
Optimise SQL logic for performance and efficient data processing.

Collaboration

Work closely with analysts, visualisation developers, data engineers and business stakeholders.
Contribute to the development of reusable data assets and consistent analytical definitions.
Support the evolution of the organisation's analytics data layer and self-service reporting capability.

Essential Skills

Advanced SQL skills with experience engineering complex analytical transformations.
Proven experience building analytical data models used by BI tools or reporting platforms.
Experience designing analytics-ready datasets rather than ingestion pipelines.
Strong experience with cloud data warehouse platforms (preferably Google BigQuery / GCP).
Strong data analysis and data profiling capability with the ability to interpret complex datasets.
Experience implementing analytical modelling approaches such as star schemas or wide tables.

Desirable Skills

Experience working with semantic layers or metrics layers (e.g. Looker / LookML).
Experience designing consistent business metrics used across reporting and analytics.
Python experience for data analysis, automation or advanced analytics workflows.
Exposure to AI-enabled analytics tools or modern data workflows.
Experience working in commercial or marketing analytics environments.
Telecommunications or subscription business experience would be advantageous.

Candidate Profile

Strong analytical mindset combined with engineering discipline.
Comfortable working with complex business data and translating it into analytical structures.
Experienced in building analytics-ready datasets used by BI tools and reporting platforms.
Collaborative and comfortable working within cross-functional data teams.

About the Company

Experis is a global leader in IT professional resourcing, project solutions and managed services. As the need for IT skills accelerates, we help organisations transform their digital infrastructure, enterprise applications, cloud and cyber security. Through Experis Academy, we deliver the powerful combination of in-demand technical skills together with the soft skills that are critical for business success. Experis is part of ManpowerGroup, a Fortune 500 Global Business and world leader in innovative workforce solutions. Know more