Rugby
Finlay Wotton
Data Analyst
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
2
2
years of professional experience
3
3
years of post-secondary education
Work History
Data Analyst
Zilch Technology Ltd
10.2021 - Current
- Built out the data used in the Fraud reporting infrastructure, using DBT to collect all touchpoints any fraudsters hit into one Explore within Looker, reducing data requests from the Fraud team by 50%
- Highlighted a bug in the digital ledger which allowed fraudsters to circumvent paying a specific fee for a service within the app, equating to £250k in missing revenue
- Optimised long-running queries (>12 hours) building our DAU and MAU funnels to run in under 2 minutes, saving 60% of our Redshift compute capacity in the process
- Led the restructuring of our DBT project reducing the number of models built by 30% and improving total runtime from 120 minutes to 50 minutes
- Provided training for day-to-day users of Looker, demonstrating how to create Views and Dashboards for their own reporting purposes
- Designed and delivered the first internal SQL training to advanced Looker users to reduce dependency on the Data Platform team via self service
- Created a root cause report showing the backlog of 10000+ refunds, which had to be matched manually leading the Operations team to complete all the backlog of refunds in under a week
- Collaborated with product managers to build a data analysis dashboard in Looker helping to highlight an underlying issue with a 3rd party provider being too targeted and blocking valid customers, enabling 100k customers to actively spend boosting GMV by 10%
Data Analyst
HSBC
04.2021 - 10.2021
- Worked in the US team helping analyse information regarding Liquidity and RWA migrations from GCP and FOTC into one single dataset
- Day to day included extracting data from two separate servers, transforming the information to display side by side datasets to analyse the numbers, ensuring the new single data source in FOTC matched the results seen in GCP and FOTC
- Validated reports for 5 different sites across NA
- Ensured all reports met Basel 3 requirements and no data was missing
Education
BSc - Mathematics with Finance
Newcastle University
09.2016 - 07.2019
Skills
Looker/ LookML
TableauPower BIRedshiftAWS/ S3
Business Analysis and Data VisualisationData formatting
Data quality assurance processes
Technical Analysis
Data analysis
Interests
Scuba Diving
Golf
Trading and Investing
Timeline
Data Analyst
Zilch Technology Ltd
10.2021 - Current
Data Analyst
HSBC
04.2021 - 10.2021
BSc - Mathematics with Finance
Newcastle University
09.2016 - 07.2019