Ross Young
London
Summary
Senior Data Engineer with 8+ years' experience designing and building scalable ELT/ETL pipelines, dimensional data models, and cloud data warehousing solutions. Skilled in Python, SQL and DBT-based transformation, with a strong track record of Kimball-methodology data modelling, CI/CD-driven pipeline automation, and stakeholder-led requirements gathering. Experienced in translating complex data needs into clear, accessible, well-governed data platforms that support self-serve analytics and informed, data-driven decision-making.
Overview
1
1
Language
14
14
years of professional experience
Work History
Senior Data Engineer
Quantum Media
London, London
02.2025 - Current
- Led a stakeholder requirements-gathering exercise with the finance team, translating their revenue-auditing needs into the design of the finalised data model and giving them full self-serve ability to audit revenue data.
- Designed and implemented a Kimball-style dimensional model for conversion funnel data, structuring each stage of processing through a medallion (bronze/silver/gold) architecture for clear, auditable data lineage.
- Refactored and consolidated the existing DBT codebase, reducing model execution runtime by ~10x and significantly simplifying ongoing maintenance.
- Designed a config-driven, automated ETL pipeline for ingesting third-party merchant revenue data, applying domain-specific business logic and schema validation, and enabling new feeds to be onboarded without code changes.
- Deployed and managed Fivetran connectors to centralise ad-spend data from platforms such as Facebook and Snapchat, choosing Fivetran as the most effective route for standardised ads-reporting APIs over bespoke connectors.
- Identified and remediated costly BigQuery jobs, applying partitioning and clustering strategies to cut compute costs and improve query performance at scale.
- Upgraded pipelines with GitHub Actions for full CI/CD automation, and authored Claude AI-agent context files across repositories to guide AI-assisted development.
Senior Data Engineer
Space Ape Games
London
05.2020 - 11.2024
- Maintained >99.9% SLO availability across pipelines through proactive monitoring and alerting.
- Optimised a critical SQL workflow through incremental processing, cutting runtime from 3 hours to 20 minutes and reducing costs.
Data Engineer
Zopa
London
01.2018 - 05.2020
- Developed a Python-based ingestion pipeline to integrate CRM data from the Salesforce API into the data warehouse, improving centralised data availability for analytics.
- Designed and implemented a star-schema data model for loan application data, enabling efficient querying and supporting detailed analytical use cases.
Technical Consultant
BAE Systems Applied Intelligence
London
03.2013 - 01.2018
- Acted as the primary technical point of contact on client site, supporting solution implementation and troubleshooting to ensure smooth adoption.
- Maintained and optimised an Oracle database within an Anti-Money Laundering (AML) technology stack, supporting regulatory and compliance requirements.
Education
Doctor of Philosophy - Experimental Particle Physics
University of Edinburgh
Edinburgh, EDH2012
Master of Science - Laser Physics And Optoelectronics
Univerity of Strathclyde
Glasgow, GLG2007
Skills
- Python
- SQL
- ELT/ETL
- BigQuery / Redshift
- Orchestration (DBT / Airflow)
- Data Modelling
- Fivetran
- Linux
- git
- CI/CD
- AI (Claude)
Hobbies
- Tennis, travelling and cooking
- Currently serve as Head Treasurer for our residential freehold management company
Languages
English
First Language
Timeline
Senior Data Engineer
Quantum Media
02.2025 - Current
Senior Data Engineer
Space Ape Games
05.2020 - 11.2024
Data Engineer
Zopa
01.2018 - 05.2020
Technical Consultant
BAE Systems Applied Intelligence
03.2013 - 01.2018
Doctor of Philosophy - Experimental Particle Physics
University of Edinburgh
Master of Science - Laser Physics And Optoelectronics
Univerity of Strathclyde