Data Analyst

arrow

London / £375 - £425 day

INFO

Salary
SALARY:

£375 - £425

Location

LOCATION

London

Job Type
JOB TYPE

Contract

Data Analyst (Data Wrangler, SQL, Python)

Location: Primarily remote (occasional collaboration days in London)
Contract: Until end December 2025 (strong possibility of extension)
Day Rate: £375-£425 (IR35, TBC)

About the Role

Join a specialist team within a leading financial services advisory consultancy, working on a high-profile, confidential investigation. This role is heavily focused on extracting, wrangling and preparing extremely large datasets to support complex forensic analysis and reporting.

Responsibilities

  • Perform extensive data wrangling to clean, structure and prepare large datasets from multiple sources.

  • Use SQL and Python (Pandas) to transform and load data into analytics environments.

  • Conduct thorough quality checks, spotting inconsistencies or issues proactively.

  • Support senior consultants by ensuring data is ready for robust comparative analysis and final reporting.

Why This Role Stands Out

  • Consultancy experience is absolutely critical - candidates must come from a Big Four or equivalent consultancy environment. This ensures the ability to operate in fast-paced, multi-stakeholder projects, with a rigorous approach to quality and delivery.

  • A forensic, investigative mindset is equally essential. This work involves dissecting sensitive datasets to identify discrepancies and support complex conclusions, far beyond typical data analyst or BI dashboard work.

  • Requires expert-level SQL and Python (Pandas) skills to handle hundreds of millions to billions of rows across diverse data sources.

Key Requirements

  • 3-5 years' data-focused experience in professional services or consulting environments.

  • Proven track record in a Big Four or similar consultancy, delivering on complex, high-pressure projects.

  • Advanced SQL for building, optimising and troubleshooting queries on very large static datasets.

  • Expert Python scripting, with deep use of Pandas for data manipulation.

  • Strong experience handling multiple data formats: Oracle databases, text files, XML.

  • UK-based, with flexibility for occasional days in the London office.

Desirable

  • Experience with financial crime, regulatory or other forensic investigations.

  • Data visualisation skills to help present findings clearly.

Quick Experience Checklist

3-5 years in data-focused roles
Consultancy / Big Four background (mandatory)
Expert SQL & Python (Pandas)
Forensic, investigative approach to data
Comfortable with extremely large datasets
UK-based, willing to attend occasional London collaboration days

CONTACT

James Lipscombe

Recruitment Consultant

SIMILAR
JOB RESULTS

4k-Harnham_DA copy
CAN’T FIND THE RIGHT OPPORTUNITY?

STILL
LOOKING?

If you can’t see what you’re looking for right now, send us your CV anyway – we’re always getting fresh new roles through the door.