Nicolás Robayo Pardo

he/him

Industrial engineer by training (M.Sc., concentration in operations research and applied statistics, Universidad de los Andes)

Data engineer in Berlin. I build reliable pipelines and data warehouses — and the statistical, ML and optimization models that run on them.

Berlin · Open to data engineering and data science roles across Germany · Eligible for an in-country switch to an EU Blue Card.

Selected projects

Origin–destination matrices from smart-card data for Bogotá's BRT and bus network
About 3.8 million validations on a weekday (13 Feb 2026) turned into origin–destination matrices, load profiles and service indicators: ~68 % chained to a destination before expansion, 97–99 % after it, in about 15 minutes a day at near-zero marginal cost.
TRANSMILENIO S.A., Dirección Técnica Zonal · 2024–2026 · R · SQL · GCP BigQuery · Parquet
A data platform for a three-person data team: Prefect, DuckDB and AWS
Python and Prefect pipelines into a DuckDB-over-Parquet warehouse on AWS, serving embedded Power BI to 45 internal and about 30 external users; assistance-claims processing time cut by 70 % with renewed, AI-assisted processes.
LifeOne (UnoGroup) · 2025–2026 · Python · Prefect · DuckDB · Parquet · AWS (ECS, Lambda, EC2, PostgreSQL) · Docker · Power BI
Risk data warehouse and versioned analytics apps at Colombia's central counterparty^e
A star-schema warehouse consolidating risk and market data for regulatory and internal reporting; the 'CRCC Data' platform of Shiny applications and APIs for internal teams and clearing members; automated risk back-testing and historical-VaR simulations.
CRCC — Cámara de Riesgo Central de Contraparte de Colombia · 2022–2025 · SQL · Oracle · Jenkins · R · Shiny · Python

Public projects and theses. Four pieces of evidence that I can formulate and solve the model that runs on a pipeline, not only build the pipeline.

Six metaheuristics in Python (CARP, ATSP, n-queens SA, CVRP GA, PDPTW LNS, MKP ILS), with statistical calibration repository
Multi-criteria MILP for intervention planning on ~1,500 national bridges (B.Sc. thesis, gurobipy) note
Self-controlled case series on 55,114 HPV-vaccinated girls, conditional Poisson regression (M.Sc. thesis) note
Teaching assistant, MIAD optimization course on Coursera (Python/PuLP, first cohort) About