William Holt Gordillo
@williamholtgordillo
Data Analyst and Data Engineer focused on Python/SQL pipelines, BI reporting, and faster, reliable ETL for business outcomes.
SpainWhat I'm looking for
I’m a Data Analyst / Engineer who builds and maintains data pipelines and reporting with Python, SQL, and modern BI tools. I focus on turning messy inputs into clean, reliable datasets that teams can act on.
At Blue Marketing in Marbella, Spain, I’ve developed Python scripts that use APIs and web scraping to extract data, transform it into the required format, and load it into MySQL and the company platform. I also support ad hoc analysis and Power BI reporting by maintaining clean, structured MySQL data, and I’ve delivered semi-automated daily and weekly revenue and campaign performance dashboards.
My work emphasizes efficiency and maintainability: I overhauled multiple ETL processes, cutting processing time by 75% on one pipeline and removing a CSV dependency in another to improve reliability. Previously at Katalyze (contracted to Direct Line Group) in London, UK, I decommissioned a legacy Redshift database by rewriting pipelines in SQL and led migration of Qlik dashboards to Tableau.
I’m comfortable spanning technical and stakeholder communication, including documenting complex logic and explaining findings to both technical and non-technical audiences. I also bring a teaching background from Number10 & Win Inglés, and I hold an MSc Biological Science (First Class Honours) plus SAS Certified Specialist credentials.
Experience
Work history, roles, and key accomplishments
Data Analyst
Blue Marketing
Oct 2025 - Present (8 months)
Built and maintained Python data pipelines using APIs and web scraping, transforming and loading results into the company platform and MySQL databases. Overhauled ETL processes to reduce processing time by 75% on one pipeline and removed a CSV-file dependency to improve reliability and maintainability.
Data Analyst / Engineer
Katalyze Data
Mar 2024 - Apr 2025 (1 year 1 month)
Rewrote SQL pipelines to decommission a legacy Redshift database with a more cost-effective and maintainable solution. Led Qlik-to-Tableau dashboard migration and analyzed/migrated SAS jobs to preserve continuity and accuracy while communicating findings to technical and non-technical stakeholders.
English Teacher
Number10 & Win Inglés
Nov 2023 - Mar 2024 (4 months)
Taught English to students across ages and proficiency levels by adapting lesson plans to learners’ needs. Prepared students for Cambridge English Qualifications at B2 and C1 levels, delivering targeted instruction and assessments.
Education
Degrees, certifications, and relevant coursework
University of Sheffield
Master of Science (MSc), Biological Science
Grade: First Class Honours
Activities and societies: Key modules: Data Analysis; Advanced Biological Analysis; Research Projects; Dissertations; Communication Skills.
Earned an MSc in Biological Science with First Class Honours. Covered coursework including data analysis, advanced biological analysis, research projects, and dissertations.
I.E.S Francisco Pacheco
High School Degree, Secondary Education
Grade: 9/10 Overall Grade
Activities and societies: Key modules: Mathematics; Physics; Industrial Technology.
Completed high school with an overall grade of 9/10. Studied Mathematics, Physics, and Industrial Technology.
Availability
Location
SpainAuthorized to work in
Job categories
Interested in hiring William?
You can contact William and 90k+ other talented remote workers on Himalayas.
Message WilliamFind your dream job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
