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