Lydia Hughes
lydia.hughes@example.com+44 20 7946 0191linkedin.com/in/lydiahughesgithub.com/lydiahughes
Summary
Analytics engineer with 6 years modelling warehouse data into trusted metrics and self-serve analytics products.
Experienced in dbt, SQL, Snowflake, BigQuery, semantic layers, testing, lineage, BI enablement, and stakeholder education.
Experience
Senior Analytics Engineer
GrowthPilot | London, UK | January 2022 - Present
- Own dbt project with 230 models supporting product, finance, marketing, and executive reporting.
- Built certified metrics layer that reduced conflicting revenue definitions from 6 to 1 across the company.
- Improved warehouse freshness SLA from 92% to 99.4% through incremental models, tests, and alert routing.
- Reduced dashboard load time by 51% by redesigning marts, clustering large tables, and removing fan-out joins.
- Train 85 business users on self-serve analytics, certified dashboards, and metric interpretation.
Analytics Engineer
HireMetric | Cambridge, UK | May 2019 - December 2021
- Developed Snowflake and dbt models for hiring funnels, customer health, billing, and product usage.
- Implemented source freshness, uniqueness, accepted-values, and relationship tests across 140 models.
- Built lineage documentation that reduced analyst onboarding time from 4 weeks to 2 weeks.
- Partnered with RevOps to reconcile ARR reporting and reduce monthly close adjustments by 27%.
Data Analyst
BrightForms | Norwich, UK | September 2017 - April 2019
- Wrote SQL analyses for activation, retention, customer support, and revenue reporting.
- Created Looker dashboards used by 60 weekly active stakeholders across product and sales teams.
- Standardised event naming and reduced unclassified product events by 39%.
- Documented KPI definitions and analysis playbooks for product managers and analysts.
Skills
Languages
SQL, Python, YAML
Modelling
dbt, Dimensional modelling, Metric layer, Data contracts, Lineage
Warehouses
Snowflake, BigQuery, Redshift, Postgres
BI
Looker, Mode, Hex, Tableau, Amplitude
Education
- MSc Data Science, University of Edinburgh
- BSc Mathematics, University of Leeds