Oliver Tandy
Data Analyst, SQL, Power BI and Python
Edinburgh, EH3oliver.tandy@example.com07700 900852Summary
Data analyst with five years in energy and online grocery, working in SQL, Python and Power BI. Built the churn analysis that led a supplier to redesign its fixed tariff offer, and replaced six weekly spreadsheet reports with one self-serve dashboard used by 45 managers. Known for making the numbers easy to act on for people who do not live in spreadsheets.
Experience
Data Analyst, Forth Valley Energy
– Present
Edinburgh
- Analysed three years of customer data in SQL and Python to find the months when households switched away; the findings shaped a new fixed tariff that cut switching in its first quarter.
- Built a Power BI dashboard for 45 operations and marketing managers that replaced six weekly spreadsheet reports and saves the team around ten hours a week.
- Designed and read out seven A/B tests on the online sign-up journey with the product team, including sample size planning and guardrail measures.
- Wrote data quality checks on the meter readings table that catch missing and duplicated records before they reach the Ofgem returns and the finance close.
Reporting Analyst, Lothian Grocers Online
–
Livingston
- Produced weekly sales and stock reports for 70 delivery hubs and trained regional managers to use them.
- Automated the monthly performance pack in Power Query, cutting preparation from three days to half a day.
- Built a markdown analysis that helped buyers clear seasonal stock with less discounting.
Education
BSc (Hons) Statistics, First Class
University of the Lothians, Edinburgh
Dissertation on survival models for customer churn.
Skills
- SQL (PostgreSQL, SQL Server, BigQuery)
- Python (pandas)
- Power BI
- Tableau
- Excel and Power Query
- A/B testing
- Cohort and churn analysis
- Data cleaning and quality checks
- dbt
- Stakeholder reporting
- GDPR and data handling
Certifications
- Microsoft Certified: Power BI Data Analyst Associate, Microsoft,