Santiago Cañas Casco

Senior Data Engineer

Salaire / Taux journalier

Madrid, Espagne

Freelance, ouvert au CDI

À distance uniquement

Expertises

PythonRequêtes SQLGoogle BigQuerydbtApache AirflowPostgreSQLJavascriptGoogle Cloud PlatformLookerTableauETLRESTful APIsMATLAB

Langues

Espagnol (Maternelle)Anglais (Courant)Français (Courant)

À propos

Introduction

Senior Data Engineer with 7+ years building GCP-based data platforms. I design event-driven ELT pipelines, real-time DWH models, and orchestration workflows in BigQuery, dbt, Airflow, and Prefect. My work has supported 1B+ transactions/year across analytics and billing. I focus on owning reliable pipelines, improving data models, and partnering with product and analytics teams to turn complex operational data into trusted reporting and product decisions. Recent work includes Jira delivery analytics (API -> dbt -> Looker), contract-driven billing pipelines, and ClickHouse migrations for faster, cheaper analytics queries. Feel free to reach out at [email protected].

Liens

Expérience de travail

Senior Data Engineer

TripleFreelance

juil. 2022 - Présent

4 ans 4 mois

Remote, Oregon 97458, États-Unis

Built event-driven ELT and billing data systems that support 1B+ transactions/year across analytics and finance reporting. - Built a BigQuery, Pub/Sub, and GCS framework for historical replay, schema evolution, and long-term retention of proto events. - Designed dbt models and Prefect orchestration to make real-time warehouse transformations observable, easier to rerun, and more reliable. - Automated the client billing pipeline from warehouse aggregation to validated invoice drafts, applying contract rules dynamically and reducing manual finance preparation.

Master Class Collaboration

Tokio SchoolFreelance

sept. 2025 - oct. 2025

2 mois

Remote, Oregon 97458, États-Unis

Master Class Collaboration

Analytics Engineer

CoverWallet, an Aon company

juin 2021 - août 2022

1 an 3 mois

Madrid, Espagne

Reduced manual Jira data preparation time by 80% and gave product and analytics teams real-time visibility into sprint progress, capacity planning, and delivery bottlenecks. - Built Python extraction from the Jira REST API for issues, epics, sprints, story points, and users, with incremental warehouse ingestion. - Modeled sprint velocity, backlog evolution, and workload KPIs in dbt using staging, intermediate, and marts layers. - Orchestrated extraction, transformation, and data-quality workflows in Airflow with task-level alerts and retries. - Published curated Looker dashboards and custom reports that increased trust in Jira performance metrics across departments.

Business Intelligence

Cabify

avr. 2020 - juil. 2021

1 an 4 mois

Madrid, Espagne

Reduced fraudulent transactions by 15% by analyzing transactional patterns with Python and PostgreSQL and surfacing anomalies for business teams. - Protected finance and leadership reporting by validating invoice and billing data before it reached Tableau dashboards. - Built Python data-quality checks for mismatched totals, missing client records, and inconsistent contract rules across billing pipelines. - Integrated validation into reporting workflows so Tableau dashboards reflected trusted financial data for revenue tracking and strategic decisions.

Data Engineer

OnTruck

mai 2018 - mai 2020

2 ans 1 mois

Greater Madrid Metropolitan Area

Improved pricing strategy visibility by linking mobile app sessions to transaction and pricing data in the DWH through a unique session_id model. - Built Python API ingestion pipelines and warehouse models for BI, pricing analytics, and operational reporting. - Enriched mobile event data with DWH metrics, enabling journey-level analysis of price offer acceptance across user flows, devices, and regions. - Created a journey characteristics heat map that helped product and marketing teams identify where users accepted or rejected price offers. - Used StreamSets to automate ETL transformations and validation checks from mobile APIs to warehouse datasets.

Data Analyst Intern

Fraunhofer Heinrich Hertz Institute HHI

juil. 2017 - mai 2018

11 mois

Berlin, Allemagne

In order to satisfy the continually increasing demand for more capacity in fiber-optical networks, spectrally efficient modulation formats such as quadrature amplitude modulation with high cardinality have to be employed. However, non-ideal characteristics of optical transmitter components such as digital-to-analog converter, modulator driver amplifier and electro-optic modulator cause distortions of the generated optical waveforms leading to a reduced quality of transmission. One promising option to compensate these distortions are digital nonlinear pre-distortion filters applied in the transmitter digital signal processing unit. The goal of the thesis is to develop advanced methods and algorithms for transmitter impairment estimation in order to determine the optimum pre-distortion filters. The algorithms should be implemented and verified in Matlab. Finally, the implemented algorithms should be validated in laboratory experiments.

Monitor Escuela de Liderazgo Blas de Lezo

Colegio de Huérfanos de la Armada (C.H.A.) Nuestra Señora del Carmen

sept. 2015 - juil. 2016

11 mois

Colegio Huerfanos de la Armada

Escuela de Liderazgo Blas de Lezo consiste en una iniciativa llevada por alumnos con competencias en diversas areas desde marketing, derecho e ingeniería. Impartimos cursos de forma gratuita en distintos colegios e institutos de Madrid. La temática de los cursos es amplia, desde oratoria, gestión del tiempo, técnicas de estudio, dirección de equipos hasta gestión de redes sociales. El contenido de los cursos es teórico/práctico

Desarrollador de software

Universidad Politécnica de Madrid

sept. 2014 - oct. 2015

1 an 2 mois

Campus Montegancedo - Universidad Politécnica de Madrid

We are designing a tool, which will enable us to measure brain signals. We test it in rabbits before we try in human brains. The project consists in two parts, one part is about programming software in order to handle the different signals we acquire and the other part is about electronics, we design an LNA ( Low Noise Amplifier)


Formation

Politecnico di Torino

Double Degree COMMUNICATIONS AND COMPUTER NETWORKS ENGINEERING, Software and Telecommunication Engineering

2016 - 2017

1 an 1 mois

Résultat : (27,5 /30)

Politecnico di Torino is offering an Master Degree in Communications and Computer Networks Engineering, merging the best of Communications and Computer Networks worlds. Browse the top menu on the left for more details, or have a look at the presentation given at the start of the academic year.This degree is completely given in English and will allow the students to “live” their didactical experience in a international class formed by international people. It offers many possibilities to travel for joint or double degrees in other foreign Universities. More information about these international programs is given every year at the end of the first semester, when all students are invited to a public presentation. The students interested in these international programs will be automatically considered when applying for the Master Degree in Communications and Computer Networks Engineering, since the selection process for these positions (and grants) is organized institutionally

Universidad Politécnica de Madrid

Máster Universitario en Ingeniería de Telecomunicación, Telecommunication Engineering

2015 - 2016

1 an 2 mois

The Master’s Degree in Telecommunication Engineering has been accredited by the Engineering Accreditation Commission of ABET (http://www.abet.org) and by the Madri+D Foundation, and is officially registered in the Registry of Universities, Centers, and Degrees (RUCT). • Duration: 2 academic years • 120 ECTS credits according to the current study plan at UPM (M2013) • Students must complete a total of 120 credits to graduate, divided into core and elective courses • The first year includes 60 ECTS of mandatory core subjects • The second year includes 30 ECTS of elective courses organized into specialization tracks, and 30 ECTS for the Master’s Thesis • The program is taught in person (on-campus) • The main language of instruction is Spanish, although some courses are offered in English

Escuela Oficial de Idiomas de Santander

Advanced level 1, English

2014 - 2015

1 an 1 mois

Universidad Politécnica de Madrid

Bachelor of Engineering in Telecommunication Technologies and Services Engineering (BETTS), Telecommunication Engineering

2010 - 2015

5 ans 1 mois

The Bachelor of Engineering in Telecommunication Technologies and Services Engineering (Grado en Ingeniería de Tecnologías y Servicios de Telecomunicación) from Universidad Politécnica de Madrid has been accredited by the Engineering Accreditation Commission of ABET, http://www.abet.org. 4-year university studies course with 240 ECTS credits in accordance with the current syllabus at the UPM (Plan 2010). This graduate degree enables the student to carry out the regulated profession of a Technical Telecommunication Engineer (in accordance with that set out in the CIN/352/2009 Order), in a speciality function of the itinerary followed by the student (Telecommunications Systems, Telematics, Electronic Systems or Sound and Image).


Licences et certifications

IELTS Certificate

Délivré le : déc. 2015

Certifié par British Council

Certificación Inglés B2 por la Universidad Politécnica de Madrid

Délivré le : juin 2013

Certifié par Universidad Politécnica de Madrid

Le meilleur endroit pour trouver votre prochaine opportunité

© 2026. Tous droits réservés.