About the Role
Responsible for the end-to-end management and manipulation of large datasets, transforming raw data into actionable insights. The role requires a combination of technical data engineering skills and analytical problem-solving abilities, using Python and complex regex patterns to clean, standardize, and transform the data.
Responsibilities
- Ingest, process, and manipulate large, often unstructured, datasets (100,000+ rows).
- Clean, standardise, and transform data using advanced scripting and regular expressions.
- Design and implement intelligent mapping logic to match and reconcile records across disparate datasets.
- Contribute to data transformation, workflow automation, and process optimisation initiatives.
- Translate complex data processes and findings into clear, actionable insights and summaries for various stakeholders.
Requirements
- Advanced Google Sheets Expertise including Pivot Tables, extensive experience with Regular Expressions (REGEX functions), Mastery of ARRAYFORMULA and other advanced Google Sheets formulas.
- Intermediate Python Knowledge with hands-on experience with Pandas for data manipulation and Experience with PySpark for large-scale data processing.
- Intermediate SQL Proficiency with a strong understanding and application of SQL Joins and expertise in string manipulation and null handling functions (e.g., CONCAT, COALESCE).
- Proven ability to use complex regex patterns for data cleaning and transformation.
- Understanding of Google Apps Script.
- Ability to leverage AI tools to develop simple automation solutions (e.g., bulk extraction from Google Drive).
- Experience working with large, unstructured datasets.
- Strong analytical and problem-solving skills, with the ability to approach complex challenges creatively.
Skills
- Google Sheets
- Pivot Tables
- Regular Expressions (REGEX)
- ARRAYFORMULA
- Python
- Pandas
- PySpark
- SQL
- SQL Joins
- String Manipulation
- Null Handling
- Google Apps Script
- AI Tools
- Data Handling
- Analytical Acumen
- Problem Solving
Location
- London
Work Type
- Hybrid
Experience Level
- Intermediate
- Advanced
Salary/Compensations
- Inside IR35
About the Company
- This is an exciting opportunity to join Deloitte Operations for an engagement with one of our clients.
