Data Analyst
Posted 4 days ago by Harnham
£425 Per day
Inside
Hybrid
London, England, United Kingdom
Summary: The Data Analyst role involves working within a specialist team at a leading financial services advisory consultancy, focusing on extracting and preparing large datasets for forensic analysis. Candidates must have a strong background in consultancy, particularly from a Big Four firm, and possess expert-level skills in SQL and Python. The position is primarily remote with occasional collaboration days in London and is contracted until the end of December 2025, with a possibility of extension.
Key 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.
Key Skills:
- 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.
- Experience with financial crime, regulatory or other forensic investigations (desirable).
- Data visualisation skills to help present findings clearly (desirable).
Salary (Rate): £425.00/daily
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: Mid-Level
Industry: Consulting
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
- Desired Skills and Experience
- Key experience: Big Four or top consultancy background (essential)
- Expert SQL & Python (Pandas) for data wrangling
- Handling huge datasets (100M+ rows)
- Forensic, investigative approach to data
- Oracle, text files, XML data sources
- UK-based, open to occasional London days