Jamie McClenaghan
Welcome! I'm Jamie McClenaghan, showcasing expertise in Data Analysis, Data Engineering, and Development. Explore my projects, skills, and how I can help you leverage data for success.
My Portfolio
Featured Projects
A selection of projects showcasing my skills in data analysis, engineering, and strategic product support.
Foundational OKR Development & Insights Visualization
Led the definition of company OKRs for Automata Technologies and architected visualizations from live global systems, delivering actionable insights that directly shaped strategic product and business development initiatives.
Technologies:
SQL
Snowflake
Looker Studio
Python
dbt
Outcomes:
- Directly shaped strategic product and business development.
- Fostered data-driven decision-making, including establishing a customer success prioritization framework.
50%Reduction in planning time in key cases
Product Scheduling Performance Optimization
Partnered with product and engineering at Automata to optimize core product scheduling performance by designing experiments, analyzing results, and developing live dashboards for proactive monitoring of customer usage patterns and key SLIs.
Technologies:
Python
SQL
Experimentation Design
Looker Studio
Data Analysis
Outcomes:
- Influenced product improvements leading to a 50% reduction in planning time in key cases.
- Enabled proactive degradation monitoring.
£50M+Key Financial Metric
Global Ad Monetization Strategy & Data Integrity
Served as lead analyst for a £50M+ annual ads revenue stream at Skyscanner, ensuring data integrity for terabytes of user data and leading global ad monetization strategy by analyzing ad performance and user engagement.
Technologies:
PySpark
Databricks
SQL
Tableau
AWS S3
Kafka
Outcomes:
- Ensured reliable data for strategic decisions for a high-value revenue stream.
- Optimized revenue yield globally through tailored A/B testing based on regional variations.
Sales Workflow Automation Tool
As a Growth Intern at Skyscanner, developed a Python-based automation tool to streamline sales workflows, significantly improving data handling efficiency and accuracy for commercial analysis.
Technologies:
Python
Data Handling
Process Automation
Outcomes:
- Significantly improved data handling efficiency and accuracy.
- Supported identification of growth opportunities through commercial analysis.
My Expertise
Technical Skills
A comprehensive overview of my capabilities across various data domains.
Product Analytics & Strategy
SQL (Advanced)
KPI Definition & Monitoring
User Behaviour Analysis
A/B Testing
Root Cause Analysis
Opportunity Sizing
Data Science & Statistical Analysis
Python (Pandas, NumPy, Scikit-learn)
Hypothesis Testing
Regression Analysis
Statistical Significance
Data Engineering & Modeling
DBT
ETL/ELT Pipelines (SQL, Python)
Data Modeling
Cloud Data Warehousing (Snowflake, Databricks, BigQuery)
Data Quality Assurance
Data Visualization & BI
Tableau / Looker Studio
Dashboard Development
Data Storytelling
Technical Stack & Tools
Cloud Platforms (AWS, GCP)
Data Pipelining (Kafka, Spark, Fivetran, Snowpipe)
Databases (PostgreSQL)
Version Control (Git, CI/CD)
AI-Powered Skill Matching
Job Skills Matcher
Paste a job description below, and our AI will highlight relevant skills and projects from my portfolio.
Enter Job Description
Provide the job details to see how my experience aligns.
Matching Summary
AI-generated insights based on the job description.
Results will appear here.
Note: This AI-powered match is for demonstration purposes and may not capture all nuances.
Career Journey
Professional Timeline
A visual overview of my career and education. Click on an item to see details.
Loading timeline...
Note: Timeline is illustrative. Hover over bars for more details.
Professional Journey
Work Experience
Detailed overview of my roles, responsibilities, and key accomplishments.
Senior Data Analyst
Automata Technologies
London, UK
Mar 2023 – Present
- Led the definition and development of foundational company OKRs, establishing critical metrics for operational performance such as workflow success rates and customer throughput, alongside key financial indicators like gross margin; architected visualisations from live systems globally, delivering actionable insights that directly shaped strategic product and business development initiatives and fostered data-driven decision-making including establishment of the customer success prioritisation framework.
- Partnered with product and engineering teams to drive optimisation of core product scheduling performance by designing, executing, and presenting findings from experiments evaluating software versions and machine sizes; subsequently developed live dashboards tracking customer usage patterns and key SLIs, enabling proactive degradation monitoring and influencing product improvements that, in key cases, led to a 50% reduction in planning time.
- Identified key opportunities for product enhancement by leading product analysis of operational data to address client-impacting lab workflow failures; pinpointed root causes and informed targeted product enhancements, resulting in improved system robustness and client operational efficiency.
- Developed bespoke data pipelines (Python, SQL, Snowflake) and customer-centric data products for leading life science/healthcare organisations, supporting key revenue milestones.
- Collaborated with Data Engineering to migrate legacy SQL transformation pipelines into dbt, significantly enhancing maintainability, testability, and reliability of core data workflows, critical for accurate reporting.
- Integrated data from diverse operational systems (e.g., Salesforce, Xero) using Fivetran and custom Python API integrations into Snowflake, powering comprehensive business intelligence and enabling deeper product performance analysis against defined OKRs.
Technologies Used:
SQL
Snowflake
dbt
Python (Pandas, NumPy)
Looker Studio
AWS
Kafka
Git
CI/CD
Senior Data Analyst
Skyscanner
London, UK
Apr 2021 – Mar 2023
- Served as lead analyst for a £50M+ annual ads revenue stream, taking ownership of data integrity for systems processing terabytes of user data (100M MAU peak) with PySpark on Databricks, ensuring reliable data for strategic decisions.
- Led global ad monetisation strategy by analysing ad performance and user engagement across diverse international markets; identified regional variations (e.g., in market rates, user response patterns) to inform tailored A/B testing and optimise revenue yield globally for a £50M+ ads business.
- Defined and monitored key metrics for advertising product performance, integrating and validating diverse 1st/3rd party ad exchange reporting data to ensure quality for revenue accounting and strategic analysis.
- Developed and launched new ad destination data products, providing valuable performance insights to external advertising partners and influencing partner strategy.
Technologies Used:
SQL
Databricks (PySpark)
Python (Pandas, NumPy)
Tableau
AWS (S3)
Kafka
REST APIs
Git
Data Analyst
Skyscanner
Edinburgh, UK
Jul 2019 – Mar 2021
- Conducted market and pricing analysis for the advertising team, providing key insights to inform commercial strategy such as emerging markets and experiments on revenue cannibalisation.
- Delivered key dashboards providing critical business visibility, ensuring data accuracy and timeliness for commercial decision-making.
- Collaborated with internal teams to understand data requirements and provide meaningful analysis to support company decisions.
Growth Intern
Skyscanner
Edinburgh, UK
Jul 2018 – Jun 2019
- Provided commercial analysis to identify growth opportunities and developed a Python-based automation tool to streamline sales workflows, significantly improving data handling efficiency and accuracy.
Technologies Used:
Python
Academic Background
Education
My academic qualifications and achievements.
University of St Andrews
MPhys (Hons) Theoretical Physics and Applied Mathematics (2.1)
St Andrews, UK
Sep 2015 – May 2019
Key Details & Achievements:
- GPA: 3.6/4.0 (Converted)
- Dean’s List: 2016-2017
- Master's Project: Numerical Approximations for Analytical Continuations of the Airy Functions in 2D.
- Advanced Physics Modules: Quantum Field Theory, General Relativity, Special Relativity, Particle Physics, Group Theory, and Electromagnetism.
- Research Paper (Course Credit): Authored a detailed paper demonstrating how neutrino oscillations provide direct evidence for neutrino mass, as mass is a prerequisite for state oscillation.
- Advanced Mathematics Modules: Analytical Continuation, Advanced Solar Theory, Wave Theory, Linear Algebra, Path and Higher Order Integrals, Complex Numbers, Advanced Analytical Methods, Numerical Approximation, and development of a Python library for symbolic differentiation and integration.
Get In Touch
Contact Me
The best way to reach me is by email. I look forward to hearing from you!
Jamie McClenaghan
Feel free to reach out via email: