Data Analyst · Data Engineering & AI Automation

Hi, I'm Esther Adekoya.

I turn messy, large-scale data into decisions people can trust.

I'm a Data Analyst at Deloitte, using SQL, Python and PySpark to reconcile and analyse financial data for global clients, and building dashboards that drive faster decisions. I lead and mentor a team of analysts and contractors, and I'm expanding further into cloud data engineering and AI automation.

Esther Adekoya
About Me

From a Statistics degree to leading data analysis at a Big Four firm.

My path into data started with a BSc in Statistics, where I first learned to think in distributions, models and evidence. Since then I've worked across three organisations — WayForward, Deloitte's Team Administration function, and now Deloitte's Data Analytics team — each one adding a different layer to how I work: technical depth, stakeholder communication, and an understanding of how data supports real business and audit decisions.

Today, as a Data Analyst on Deloitte's Audit service line, I reconcile and analyse financial datasets exceeding a million records using SQL and PySpark in Azure Databricks, build automated data transformation workflows in Azure Synapse, and maintain dashboards in Tableau, Power BI and CRM Analytics that teams rely on to make decisions faster. I also lead and mentor a team of analysts and contractors — resolving technical queries, developing training and onboarding materials for the wider team, and interviewing new joiners into the Data Analytics team.

Alongside that, I'm expanding further into AWS, Airflow, dbt and AI automation — deepening the engineering side of my practice as I move toward Data & AI consulting.

Currently
Data Analyst, Deloitte — Audit Data Analytics
Education
BSc Statistics, Federal University of Agriculture, Abeokuta
Core tools
SQL · Python · PySpark · Databricks · Azure Synapse · Tableau · Power BI
Currently expanding into
AWS · Airflow · dbt · AI Automation · formal data modelling
Experience

Where I've worked

A progression from stakeholder-facing operations into hands-on, large-scale data analysis.

Data AnalystDeloitte, Audit Data Analytics
Sep 2024 – Present · UK
  • Reconcile and prepare financial data for global clients across datasets exceeding 1 million records, ensuring compliance with audit standards using SQL and PySpark.
  • Run large-scale data analysis using PySpark for distributed processing and SQL in Azure Databricks for bespoke analytical solutions.
  • Build and deploy data transformation solutions in Python/PySpark within Azure Synapse, reducing manual intervention by ~50% and project turnaround time by ~20%.
  • Standardised financial data, reducing reporting errors by ~25% and improving processing efficiency by ~30%.
  • Build and maintain interactive dashboards in CRM Analytics, Tableau and Power BI, improving decision-making efficiency by ~40%.
  • Lead and mentor a team of contractors and junior analysts, resolving technical and industry-specific queries and supporting their day-to-day development.
  • Develop training materials and onboarding resources for the wider team, and conduct interviews for new joiners into the Data Analytics team.
Team AdministratorDeloitte
Aug 2023 – Sep 2024 · UK
  • Managed and optimised analytics request systems, decreasing request processing time by ~25%.
  • Supported development of data pipelines and automated reporting processes.
  • Communicated with auditors, coordinated audit team resourcing, and maintained Power BI dashboards.
Data Analyst (Projects)WayForward Ltd
Jun 2019 – Sep 2021 · Nigeria
  • Designed data models to support reporting needs, contributing to an ~87% sales increase.
  • Integrated data from multiple sources into Tableau and Power BI, enabling data-driven decisions.
  • Used SQL to develop a data warehouse, improving data accessibility and accuracy by ~40%.
Show earlier career — Industrial Trainee, Ardova Plc (2017–2018)
  • Evaluated products and suppliers using SAP, reducing procurement costs by ~15%.
  • Optimised resource allocation, improving operational efficiency by ~20%.
Projects

Selected work

Dashboards and analysis built in Tableau, Power BI and Python. Click through to explore the live dashboards where available.

Employee HR Dashboard in Tableau

Employee HR Dashboard

An interactive Tableau dashboard giving HR a quick overview of headcount, department distribution, compliance training status and vacation usage across the company, modelled across three related tables.

TableauExcelData Modelling
Customer Revenue Dashboard in Tableau

Customer Revenue Dashboard

A Tableau dashboard analysing $159M+ in revenue across 42,600+ customers and 126,000+ orders — breaking performance down by age, gender, state and month to surface where revenue is coming from.

TableauData Analysis
Parental Leave Report in Power BI

Parental Leave Benchmarking Report

A Power BI report comparing paid and unpaid maternity/paternity leave policies across 1,600+ companies and 51 industries, highlighting which sectors lead on parental leave provision.

Power BIBenchmarking
Laptop Market Analysis in Power BI

Laptop Market Analysis

A Power BI report comparing price, ratings and specs across 208 laptops from 19 brands, including a price-vs-rating correlation to test whether higher price means a better-rated product.

Power BIData Analysis
import pandas as pd
import logging

logging.basicConfig(filename='rides_log', level=logging.INFO)
logging.info('Starting data cleaning process')

try:
    rides = pd.read_csv('rides.csv')
    logging.info("Dataset loaded successfully")
except Exception as e:
    logging.info(f'Failed to load dataset: {e}')
    raise

rides['Vehicle Type'] = rides['Vehicle Type'].str.lstrip()
rides['Vehicle Type'] = rides['Vehicle Type'].fillna('unknown')

Ride-Hailing Data Cleaning Pipeline

A Python/Pandas script that cleans a raw rides dataset — trimming whitespace, standardising inconsistent categories, flagging and handling missing values, and zeroing out cancelled bookings — with logging at every step for traceability.

PythonPandasData Quality
Skills

What I work with

Languages & Data

SQLPythonPySparkSAQL

Platforms & Cloud

Azure DatabricksAzure SynapseAzure DevOps

Visualisation & BI

TableauPower BICRM Analytics

Analysis & Stats

R / RStudioSPSSExcelData Modelling

Currently building

AWSAirflowdbtAI Automation

Ways of working

Stakeholder communicationMentoringProcess improvement
Certifications

Qualifications & certificates

SF

Certified Salesforce Administrator

2023 · View certificate

AI

Salesforce Certified AI Associate

2023 · View certificate

CRM

Certified Tableau CRM & Einstein Discovery Consultant

2024 · View certificate

BA

Business Analysis — Coven Works

2023 · View certificate

GSK

Virtual Work Experience — GSK

2023 · View certificate

DS

Introduction to Data Science

2020

Education

Academic background

BSc Statistics

Federal University of Agriculture, Abeokuta, Ogun, Nigeria

2019
Salesforce

Salesforce & business analysis work

Before and alongside data analytics, I've done a good amount of Salesforce consulting and business analysis work — it's part of how I learned to map processes, gather requirements and translate business needs into technical solutions.

Salesforce Consultant Quest presentation cover

Salesforce Consultant Quest — Internal Sales Transformation

Oct – Nov 2023. Implemented a Knowledge Base and self-help/FAQ/chatbot options for customer support, integrated telephony with Salesforce, and rolled out a multi-channel support system — cutting customer inquiries by ~20%, service requests by ~15%, and case resolution time by ~25%.

SalesforceBusiness Process MappingConsulting
Dreamforce Digital Engagement Team process map

Salesforce Business Analyst Team Sprint

Sep – Oct 2023, with Clicked. Conducted stakeholder interviews to elicit requirements, mapped the Dreamforce Digital Engagement Team's process end-to-end, and crafted user stories and project plans for Salesforce-driven solutions — presenting findings to peers and industry professionals.

SalesforceBusiness AnalysisStakeholder Management
Get in touch

Let's talk data.

Open to Senior Data Analyst and Data Engineering conversations. The fastest way to reach me is email or LinkedIn.