Data Analyst

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)

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.

• 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.

• 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.

• 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.

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

• Data visualisation skills to help present findings clearly.

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