Data Analyst

Harnham - Data & Analytics Recruitment • TRAFFIC • London, Not Specified, United Kingdom • £375 - £425 / day • 10h ago

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 rolesConsultancy / Big Four background (mandatory)Expert SQL & Python (Pandas)Forensic, investigative approach to dataComfortable with extremely large datasetsUK-based, willing to attend occasional London collaboration days

Related Jobs

Senior Data Scientist

Xcede Recruitment Solutions • TRAFFIC • London, Not Specified, United Kingdom • 9h ago

Data Outside IR35

Senior Data Scientist - 6-Month Contract - Hybrid (London Preferred) Sector Focus: Online Publishing / Market Research Outside IR35 A data-driven organisation in the B2B content and research space is seeking a Senior Dat...

9h ago

Apply

AVP - Data Quality Analysts - FinCrime (h/f)

emagine • ATS • London, Not Specified, United Kingdom • 1d ago

Data

Data Quality Analyst London - Hybrid working (2-3 days on site) £350-£400pd Inside IR35 emagine is a high-end professional services consultancy and solutions firm specialising in providing business and technology service...

1d ago

Apply

Data Scientist with PyMC & Marketing Mixed Modelling experience

Lorien • TRAFFIC • London, Not Specified, United Kingdom • 1d ago

Data

Data Scientist with PyMC & Marketing Mixed Modelling experience Job Type: Contract/Temporary Location: London (Remote/1 day onsite a month at Bankside) Job Ref: BBBH28 Date Added: May 19th, 2025 Consultant: Louis Poy...

1d ago

Apply

Sr. BIE, Amazon Grocery Data and Tech

Amazon • TRAFFIC • London, Not Specified, United Kingdom • 1d ago

Data

At Amazon, we're working to be the most customer-centric company on earth. To get there, we need exceptionally talented, bright, and driven people. We are looking for a Sr. Business Intelligence Engineer in the Amazon Gr...

1d ago

Apply

Experienced CRM Data Scientist CRM Data Science UK Hybrid Remote

EveryMatrix Ltd • TRAFFIC • London, Not Specified, United Kingdom • 1d ago

Data

EveryMatrix is a leading B2B SaaS provider delivering iGaming software, content and services. We provide casino, sports betting, platform and payments, and affiliate management to 300 customers worldwide. But that's not...

1d ago

Apply

Senior Data Scientist - Creative Optimization London, England

Group M Worldwide Inc. • TRAFFIC • London, Not Specified, United Kingdom • 1d ago

Data

Senior Data Scientist, Creative Optimization Who we are: Choreograph is WPP's global data products and technology company. We're on a mission to transform marketing by building the fastest, most connected data platform t...

1d ago

Apply

Associate - Instrument Data

Dianaduggan • TRAFFIC • London, Not Specified, United Kingdom • 1d ago

Data

We are looking for an Associate to make a key contribution to the Instrument Data Team for this top tier Asset Manager. You will have a good understanding of the fundamental characteristics of financial instruments, such...

1d ago

Apply

CRM Data Analyst Remote

HipHopTune Media • TRAFFIC • London, Not Specified, United Kingdom • 1d ago

Data

A client of Synapri is seeking an experienced CRM Data Analyst to join their remote team. The ideal candidate will have 3-5 years of CRM data analysis experience, with strong expertise in Salesforce essential for the rol...

1d ago

Apply

Scrum Master - Healthcare, Data, Azure

Hays Technology • TRAFFIC • London, Not Specified, United Kingdom • 2d ago

Data

Scrum Master - Healthcare, Data, Azure Market Rate - Inside IR35 London / Hybrid - 2 days per week on site 6 months My client is an instantly recognisable Healthcare Insurer who urgently require a Scrum Master with exper...

2d ago

Apply

Associate VP - Data Governance BA BCBS 239 (h/f)

emagine • ATS • London, Not Specified, United Kingdom • 3d ago

Data

Business Analyst - Data Governance Hybrid working (2-3 days) London £400pd Inside IR35 emagine is a high-end professional services consultancy and solutions firm specialising in providing business and technology services...

3d ago

Apply