Jake Caulton
London
Summary
Data Acquisition Engineer with 6+ years of proven expertise in transforming complex data challenges into streamlined solutions. Successfully automated data extraction processes for over 200 clients, delivering significant efficiency gains through innovative SQL and Python implementations. Unique combination of technical proficiency and strong interpersonal skills enables effective bridging between complex data systems and business objectives. Excels at translating technical solutions into clear business value, having presented to 100+ clients and secured widespread adoption of data extraction tools.
Overview
10
10
years of professional experience
Work history
Data Acquisition Engineer
PricewaterhouseCoopers (PwC)
London, UK
07.2018 - 01.2026
- Consulted over 100 clients to gain approval for use of automated extraction tools, leading to one week saved on average in both time and costs on audit engagements.
- Designed and implemented new data transformation scripts in Visual Studio using SQL and Python which helped to streamline preparation of audit data.
- Developed Revenue testing workflows using PySpark in Databricks.
- Performed assessments of structure of client systems and prepared and advised data solutions relevant to their needs.
- Delivered firm-wide learning sessions on data tools such as Databricks and ETL pipelines to all levels of expertise.
- Used Databricks and SQL to resolve technical issues for audit teams on client data.
- Utilised Alteryx to build automation workflows for data processing and Power BI to present data to project stakeholders.
- Led multiple data extraction projects, using Azure DevOps and Excel trackers to ensure timely and accurate data delivery for audit teams.
- Managed team on projects and instructed on tool usage and automation techniques.
Data Administrator
Octopus Investments
London, UK
01.2018 - 07.2018
- Contacted financial advisers regarding client portfolios, resolving data inconsistencies.
- Contacted financial advisers regarding client portfolios, resolving data inconsistencies
- Utilised Excel formulas to streamline data processing, handling 1,500+ records daily.
- Updated adviser FCA numbers to maintain compliance and operational accuracy.
- 6-month contract.
Property & Communications Manager
Krukziener Properties
Auckland, NZ
03.2016 - 12.2016
- Managed office and retail tenants across five commercial properties and four parking lots.
- Liaised with potential buyers and tenants, conducted property tours, and compiled investor reports.
- Created marketing materials using Adobe InDesign and Photoshop for properties available for lease.
- Drafted and edited lease agreements, updating leasing schedules using Excel.orts..
- Drafted and edited lease agreements, updating leasing schedules using Excel
Education
Conjoint Bachelor's Degree - Property and Finance
University of Auckland
Auckland, NZ /2011 - /2015
Skills
- SQL
- PySpark
- Python
- Client Relations
- Microsoft Fabric
- Azure DevOps
- Docker
- Power BI
- Databricks
- Alteryx
- Visual Studio Code
- Microsoft Excel
Timeline
Data Acquisition Engineer
PricewaterhouseCoopers (PwC)
07.2018 - 01.2026
Data Administrator
Octopus Investments
01.2018 - 07.2018
Property & Communications Manager
Krukziener Properties
03.2016 - 12.2016
Conjoint Bachelor's Degree - Property and Finance
University of Auckland
/2011 - /2015