Lewis Cherry
Braintree,Essex
Summary
Data analyst with strong proficiency in SQL, DAX, Power BI and Excel, turning complex datasets into clear, actionable insights. Independently designs and delivers reporting solutions across departments from financial and operational reporting to HR and Commercial - including a centralised project directory covering 2000+ projects. Comfortable working with large, complex datasets and translating technical findings into concise recommendations for non-technical stakeholders.
Overview
5
5
years of professional experience
Work history
Data Analyst
VolkerFitzpatrick
Hoddesdon, Hertfordshire
2025.06 - Current
- Built complex SQL queries for Power BI reporting, using window functions and advanced CTEs to construct historical and current-state datasets, with strong focus on query optimisation for performance.
- Applied robust DAX to build validation logic - including lookup checks and duplicate detection, to ensure accuracy and reliability of report results.
- Designed and delivered discretionary spend report spanning all 7 divisions, giving leadership consistent view of spend across business.
- Automated recurring reports, including cash project positions and timesheets, cutting manual reporting effort significantly.
- Consolidated project data into single, centralised directory cover 2,191 projects across VolkerWessels, including contact, division and location data - previously scattered across business.
- Independently built reports for HR, HSEQ and Commercial, in addition to financial and operational reporting - reflecting range across business functions.
Business Analyst
RIFT Tax Refunds
Ashford, Kent
2021.10 - 2023.10
- Automated weekly MI Pack pulling from numerous data sources, using Power Automate to generate and distribute PDF reports to all division heads, reporting MTD and YTD business performance.
- Conducted ROI analysis across marketing channels, informing shift in budget away from TV, radio and social media advertising toward SEO and referrals — channels with highest conversion rates.
- Analysed employee call performance to identify patterns among top performers, informing best practices around call timing, conversation approach, and optimal intervals between follow-up attempts.
- Partnered with stakeholders to define KPIs for lead lifecycle, combining historical data with business acumen to establish benchmarks for tracking performance from initial contact through to conversion.
Education
Master of Science - Mathematics
University of East Anglia
Norwich, Norfolk 2017 - 2021
A-Levels -
Braintree Sixth Form
Braintree, Essex 2015 - 2017
GCSEs -
Tabor Academy
Braintree, Essex 2010 - 2015
Skills
- Data Analysis & Visualisation - Comfortable building end-to-end Power BI solutions, from raw data through to stakeholder-ready dashboards
- SQL & Data Engineering - Skilled in window functions, CTEs and query optimisation for handling large, complex datasets efficiently
- DAX & Data Validation - Experienced building advanced DAX logic to catch data quality issues
- Research & Analysis - Structured research and analytical approach developed through dissertation work, applied to identifying patterns in ambiguous or complex information
- Stakeholder Communication - Able to translate technical findings into clear, actionable recommendations for non-technical audiences
- Independent Delivery - Comfortable owning projects end-to-end with minimal oversight, from scoping to delivery
References
References available upon request.
Timeline
Data Analyst
VolkerFitzpatrick
2025.06 - Current
Business Analyst
RIFT Tax Refunds
2021.10 - 2023.10
GCSEs -
Tabor Academy
2010 - 2015
A-Levels -
Braintree Sixth Form
2015 - 2017
Master of Science - Mathematics
University of East Anglia
2017 - 2021