Sep 2024 – Mar 2025 · 6 mos · London Area, United Kingdom · Hybrid

• Maintained and developed GCP architecture for clients which provides analytics around media and marketing insights.
• Built Python API ingestion pipeline for illness-related Google search trends and weather data history into GCS with subsequent loading into BigQuery; this supported a ML model predicting ideal marketing campaign time-frames for pharmaceutical client.
• Implemented an ELT process with Python into a GCP data warehouse featuring Cloud Logging, modelled BigQuery data with dbt and SQL to analyse hospitality loyalty figures, tracking booking-to-stay conversion rates across hotel locations.
• Audited client’s BigQuery project with 300+ tables, recommending cleanup of abandoned pipelines, reducing table count by 75% and resulting in improved capacity for maintenance.
• Patched problematic GA4 pipeline for client by utilising event-driven logic in conjunction with Pub/Sub message triggers to accurately order pipeline sequencing; missing data was backfilled to re-populate affected periods.
• Resolved dbt DAG failures caused by unexpected data source changes, troubleshooting SQL in BigQuery, communicating resolutions to clients, backfilling data and restoring sales analytics in Looker.
• Revised GitLab repositories by incorporating a CI/CD Terraform (IaC) workflow which updates GCP infrastructure and pipelines.

Dec 2022 – Sep 2024 · 1 yr 9 mos · London Area, United Kingdom · Hybrid

• Developed BigQuery data models for numerous projects to enable the visualisation team to produce analytics on: customers, product holdings, technology types, subscription flows, order flows and contract data.
• Monitored aggregated view of customers with broadband speed issues in Tableau, measured the percentage of customers churning in response to inconveniences in different time-frames.
• Analysed broadband discount strategies in Tableau and was successfully able to measure the effectiveness of offers contributing to subscription acquisitions and churn reduction.
• Migrated SQL transformation scripts from dedicated servers to the GCP BigQuery data warehouse, implementing SQL best practices for readability, and performing regression tests to assure high data quality.
• Supported the implementation of common staging pipelines to optimise data processing volumes, resulting in a significant reduction of duplicate processing costs and creating a single source of truth.
• Prioritised and triaged ad-hoc requests from stakeholders, created gcloud bash scripts (bq, gsutil) to export data into GCS buckets to stay agile whilst handling larger projects.

Nov 2021 – Nov 2022 · 1 yr · Luton, England, United Kingdom

• Facilitating data analytics in the Safety, Security & Compliance team:
• Forged strong relationships with safety experts and collaborated to create Tableau dashboards for monitoring safety statistics.
• Replaced Excel tasks with comprehensive reporting pipeline in Python; over 15 xlsxwriter reports to save 30 man-hours/month.
• Templating 12 monthly PowerPoint’s with the python-pptx library and saving 40 man-hours/month of presentation prep.

Aug 2018 – Sep 2021 · 3 yrs 1 mo · Luton, United Kingdom

• Working between the CAMO and the Part 145 maintenance teams:
• Coordinating engineering investigations, root cause analysis and occurrence risk management.
• Leading discussions in the Engineering Safety Action Group to discuss emerging risks.
• Presenting data to drive risk mitigation actions within the Safety Action Groups.
• Designing occurrence reporting process flows in compliance with airline safety regulations.
• Harnessing Pandas and Matplotlib to create data-sets to monitor E&M safety reporting metrics.
• Building Excel Dashboards to monitor safety performance indicators for the engineering department.

Jun 2017 – Jul 2017 · 1 mo · York, Queen Ethelburga's College

• Assisting in running summer camp activities:
• Leading team-building games for children to participate in: Basketball, Origami, Painting, Tie Dye, etc.
• Supervising excursions for offsite adventure activities to: rock climbing, sailing, gorge walking, camping etc.

Feb 2012 – Jul 2018 · 6 yrs 5 mos · High Wycombe, Booker Airfield

• Supporting gliding operation at airfield by ensuring efficient ground movements:
• Performing launch point preparation, flight log administration, glider launching and retrieval.