Hi, I'm Harry Ramsay
... turning data into insights at Schiphol Airport.
I specialise in using Python, PySpark, and Databricks to ensure a high degree of clarity and data reliability.
def analyze_data(df):
"""Transform chaos into clarity"""
df = df.dropna().dedupe()
insights = df.groupby('category')
.agg(metrics)
.display()
return insights
About Me
I'm a data analyst at Schiphol Airport, focused on making sure our data is reliable and clearly understandable.
Day-to-day, I use Python, PySpark, and SQL within Databricks to automate checks, solve problems proactively, and keep our data trustworthy.
With a background spanning payments fraud detection, music metadata, and even professional music performance, I bring a unique perspective to data analysis. I believe in clear communication, elegant solutions, and the power of well-structured data to drive decisions.
Quick Highlights
Schiphol Airport
Ensuring data quality for one of Europe's busiest airports
Fraud Detection
Built integration processes for payment fraud prevention
Process Optimization
Eliminated all editorial errors in client products at Nielsen
Work Experience
Data Analyst
Royal Schiphol Group- Developed and implemented automated data quality checks using Python, PySpark, and SQL within Databricks
- Built and maintained structured orchestration workflows to streamline data validation processes
- Collaborated with data governance teams to define and refine data quality standards and procedures
- Proactively identified root causes of data quality issues, reducing manual intervention and enhancing data reliability
- Created clear documentation to improve knowledge transfer and standardise internal processes
Personal & Professional Break
Took time away from work for personal reasons, including relocating and handling family commitments, alongside ongoing professional development.
Lead Researcher / Data Analyst
Social Healing ProjectNote: Part-time, fixed-scope project conducted in collaboration with a research lab whilst employed full-time at Fraudio.
- Led a mixed-methods research project analysing data from 20 participants to understand the role of social interactions in psychological healing
- Employed AI transcription services and conducted rigorous data quality checks to ensure 100% transcript fidelity from audio recordings
- Performed semantic analysis using LIWC on transcripts, surveys, and interviews to identify key themes
- Collaborated with lab co-director to establish codebook guidelines
- Visualised complex data using Python (pandas, matplotlib, seaborn)
- Managed a research associate, delegating tasks and ensuring timely project completion
Data Analyst
Fraudio- Partnered with cross-functional sales, customer success, and data science teams to ensure alignment throughout integration lifecycles
- Conducted in-depth analyses on payments data using SQL, Python, and visualisation tools
- Developed robust integration processes consolidating data from multiple sources through automated data quality checks and schema mapping tools coded in Spark
- Acquired extensive domain expertise in the payments ecosystem - transaction flows, chargebacks, fraud patterns
- Created reusable Spark tools for automated data quality testing, significantly reducing manual efforts
- Developed comprehensive technical documentation using Docusaurus and React, dramatically increasing onboarding speed
Data Analyst
Gracenote / Nielsen- Developed and implemented new data quality procedures that eliminated all editorial errors in client products
- Performed complex data analysis using Python, SQL, Excel, Google Sheets, Tableau, Spotfire, and R
- Continuously optimised workflows to increase efficiency and maintain data quality standards
- Designed and conducted live training sessions to upskill managers and team leads
- Created comprehensive documentation for new and existing projects
Music Content Editor
Gracenote / Nielsen- Exclusively managed metadata and quality control for the DACH (German-speaking) music data market
- Contributed to cross-functional projects including workflow documentation and productivity tracking
- Developed transparent, effective solutions to report, track and resolve issues impacting the entire music department
- Continually streamlined personal workflows to enhance productivity and effectiveness
Professional Musician & Educator
Freelance- Taught music theory and guitar to students of all skill levels
- Performed internationally as a freelance musician for cruise lines and function bands
- Developed customised lesson plans tailored to each student's goals
- Expanded business by acquiring web design and marketing skills
Skills & Languages
Core Competencies
Data Engineering
Building robust data pipelines and quality frameworks using Python, PySpark, and SQL in cloud environments
Data Quality Assurance
Implementing automated validation checks and proactive monitoring to ensure data reliability at scale
Process Automation
Streamlining workflows through intelligent automation, reducing manual effort and increasing efficiency
Analytics & Insights
Transforming complex data into actionable insights through analysis and clear visualization
Languages
Technical Skills & Tools
Speaking Engagements
In the Zone: The Psychology of Flow
An exploration of flow states based on Mihály Csíkszentmihályi's research, including the genesis of flow, cultivating flow at will, and its implications for generating meaning and momentum.
Nature vs. Nurture Part 1: Is Talent Actually A Thing?
An exploration of the hotly-debated nature of talent: its origins, its definitions, and even its very existence.
Nature vs. Nurture Part 2: Nurturing Our Nature
How can we best cultivate the talents we have – in our friends, our children, and ourselves?
"Not Here" Is Not A Destination: The Limits of Mental Models
An exploration of mental models as popularised by Charlie Munger, examining both their practical helpfulness and the dangers of blind adherence.
Education
Bachelor of Arts: Contemporary Music Performance
Academy of Contemporary Music
2008-2010 | Guildford, UK
First Class HonoursHigher Diploma: Contemporary Music Performance
Academy of Contemporary Music
2007-2008 | Guildford, UK
DistinctionGet In Touch
I'm always interested in interesting discussions with interesting people. Feel free to reach out!