
Santiago Cañas Casco
Senior Data Engineer
Salaire / Taux journalier
Madrid, Espagne
Freelance, ouvert au CDI
À distance uniquement
Expertises
Langues
À 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].
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
Certificación Inglés B2 por la Universidad Politécnica de Madrid
Délivré le : juin 2013