Amaia Artola

I am a Junior Data Analyst

About Me

Junior Data Analyst transitioning into tech with hands-on training in SQL, relational databases and data analysis. I recently completed Harvard's CS50 SQL course and built a full relational database project from scratch. I bring strong communication and self-learning skills developed over years of teaching — and I apply that same patience and rigour to working with data.

Junior Data Analyst

  • Degree: BA Hons. Translation and Interpreting
  • City: Valencia, Spain

After years of teaching, I transitioned into tech through the IT Career Switch full-stack programme — and it was there that I discovered a real passion for working with data and databases. That led me to complete Harvard's CS50 SQL course and build real projects from scratch, independently. I bring the same rigour and curiosity I had in the classroom to every data challenge I work on.

Skills

My core technical skills and areas of expertise.

Data & Databases

SQL PostgreSQL MySQL Database Design Normalization JOINs CTEs Window Functions Query Optimization

Development

PHP JavaScript Git HTML CSS REST APIs

Professional Skills

Analytical Thinking Problem Solving Attention to Detail Communication Self-Learning Project Planning

Curriculum Vitae

Former language teacher transitioning into data, with hands-on experience in SQL, relational databases and analytical problem-solving.

Download CV

Education

CS50 SQL — Harvard University

2024
  • Training in relational databases, SQL querying and schema design.
  • Built a full relational database for a music streaming platform as a final project.
  • Practised JOINs, CTEs, window functions and query optimisation.

IT Career Switch — Full Stack Development Programme

2024 – 2025
  • Built full-stack projects using PHP, MySQL, JavaScript and APIs.
  • Used SQL with JOINs, GROUP BY and prepared statements in real applications.

The Odin Project — Foundations

2023 – 2024
  • Fundamentals including HTML, CSS, JavaScript, Git and command line.

Qualified Teacher Status (QTS)

2013 – 2014

BA Hons. Translation and Interpreting

2006 – 2011

Pablo de Olavide University, Sevilla

Professional Experience

Self-Employed — Online Language Tutor

2018 – 2020

Remote

  • Managed own tutoring business teaching English and Spanish to international students.

English Teacher — English Connection

2016 – 2018

Madrid, Spain

  • Designed and taught lessons for varied levels including Cambridge exam preparation.

MFL Teacher — Hemsworth Arts & Community Academy

2014 – 2016

Pontefract, Yorkshire, UK

  • Taught students across Key Stages 3 to 5 (ages 11–18).

Assistant & Trainee Teacher — Ossett Academy (UK)

2011 – 2014
  • Completed teacher training for QTS with outstanding final assessment.

Projects

A selection of projects built from scratch, combining data, databases and web development.

Music Streaming Database

Relational database for a music streaming platform — CS50 SQL Final Project

SQL PostgreSQL Database Design JOINs CTEs
Company Directory

Full-stack internal tool with CRUD, filtering and real-time updates

PHP MySQL JavaScript SQL Bootstrap
Gazetteer Web App

Interactive country explorer with maps, weather and live API data

JavaScript PHP MySQL Leaflet.js REST APIs