Oliver Strachan
Junior Data Analyst
Astrophysics graduate (BSc, 88% High Distinction) moving into data analytics, with end-to-end Python, SQL, Snowflake and Power BI projects on financial and sports data, including 1.3M+ event records. Raised picker output 15% using operational data while leading teams of up to 100. Five years of self-directed markets research. Seeking junior data analyst roles in London.
Technical Skills
SQLJoins, CTEs, aggregations, window functions
PythonPandas, yfinance
BI & VizPower BI, Tableau
DatabasesSnowflake, SQLite
OtherExcel, Git, JavaScript, Swift, Claude API
Analytical Experience
Freelance Finance App Technical Consultant
2024 – Present
- Diagnosed a transfer-misclassification issue in a multi-account budgeting app where inter-account transfers were double-counted as income and expense; tested against 50,000 bank-reconciled transactions and found a 10.4% reporting error rate.
- Recommended a transaction-matching layer (account ID, amount, timestamp) ahead of categorisation; after implementation the developer reported the error rate falling from 10.4% to 1.23%.
Independent Self-Directed Financial Markets Trader
2016 – 2021
- Five years of self-directed research and trading across equities, forex and crypto, acting on macro-driven opportunities.
- Held Reckitt Benckiser (RKT.L) from early 2020 to early 2021 on a thesis that COVID-19 would lift hygiene-product demand; self-funded portfolio grew from £3,500 to £4,918 (+40.5%).
Projects
Asset Volatility and Correlation Dashboard
Python · Pandas · Snowflake · Power BI
- Built an end-to-end pipeline on 13,240 rows of daily OHLC data across 7 assets (5 equities, 2 crypto) via yfinance, loaded into Snowflake, transformed with SQL window functions and visualised in Power BI (rolling volatility, cross-asset correlation, portfolio growth).
- AAPL rolling 30-day volatility rose from ~0.017 to ~0.058 in the COVID crash; stock/crypto correlation held at 0.80–0.87 through the Terra/Luna collapse before easing to ~0.65.
Premier League Analytics Dashboard
Python · Pandas · SQLite · Tableau Public
- Processed 1,313,783 StatsBomb event rows (2015/16 season) into a Tableau Public dashboard covering xG analysis, shot maps, player comparisons and scouting.
- Leicester City led the league in xG (66.28), supporting the view that their title win was not an anomaly.
FM26 Scout Tool
HTML · CSS · JavaScript
- Built a player-scoring tool across 7 positional roles and 25 attributes with a custom age-decay multiplier on potential ability.
- Adopted by 5 other users for a private online league.
Work Experience
Music Producer and Group Manager — Sony Collaboration
Sep 2024 – Jan 2026
- Produced and managed releases for a five-person artist group, distributed through UnitedMasters and Sony, reaching 190,000+ lifetime streams.
Warehouse Supervisor, Food Distribution Facility
2023 – 2024
- Promoted to supervise a team of 60–100; used data on units picked and orders fulfilled to identify inefficiencies, raising average picker output from 800 to 920 units/day (+15%).
Contact Tracing Manager, NHS Call Centre (COVID-19)
2020 – 2022
- Managed a team of 15, scaling case handling from 10–20 calls daily in low-demand periods to 100+ at winter peak while maintaining time-sensitive data accuracy and protocol adherence.
Education
University of Sydney — BSc Astrophysics and Cosmology
Accredited Online Programme · 88% overall average, High Distinction (equivalent to UK First Class Honours)
Modules: Astrophysics and Relativity (incl. Advanced), Data Science in Astronomy (incl. Advanced)
Certifications & Interests
Certifications: Anthropic AI Certification Suite (Skilljar)
Interests: Rubik's Cube speedsolving (sub-minute), 7-a-side football, PlayStation platinum trophies, Ancient Greek history