Nicolás Robayo Pardo

Work authorisation: based in Berlin, currently permitted 20 h/week; eligible for an in-country switch to a full-time EU Blue Card.

Availability: full-time; no notice period.

• 05/2025 – present
  remote

  Analytics Lead — hands-on data engineering

  LifeOne (UnoGroup)

  Built and lead a three-person data team (hired and manage two data engineers), reporting to the CTO; about 60 % of my time is spent building. Looking for a hands-on role in a larger team by choice.

  • Built the company's analytics platform end to end on AWS (ECS cluster, Lambda, EC2, PostgreSQL databases), DuckDB over Parquet, Python, Prefect and Docker, with dev/staging/pre-prod/prod environments, infrastructure as code, code review and automated deployments.
  • Wrote and maintain the Prefect flows that integrate SQL databases, REST APIs and JSON/XML feeds, with a manual sign-off step before publication — a deliberate choice for a three-person team; largest table ~4 M rows, whole warehouse under 50 MB of Parquet.
  • Delivered embedded Power BI for 45 internal and ~30 external users (company stores and partners).
  • Renewed the assistance-claims process with AI-based tools, cutting claim processing time by 70 %.
  • Hired and manage two data engineers (planning, code review); coordinate data exchange with retail partners (API protocols).

  Note: a data platform for a three-person data team

• 05/2022 – 05/2025
  Bogotá

  Analytics Professional, Risk & Methodologies (data science and data engineering)

  CRCC — Cámara de Riesgo Central de Contraparte, Colombia's central counterparty clearing house

  CRCC was recognised by ESMA as a third-country CCP in 2023.

  • Designed and implemented a star-schema data warehouse consolidating risk and market data for regulatory and internal reporting (Oracle, SQL; Jenkins-automated jobs).
  • Built and versioned the "CRCC Data" analytics platform with a colleague: Shiny applications and APIs for internal teams and clearing members, automated risk back-testing and historical-VaR market-risk simulations.
  • Built RAG assistants over the clearing house's rulebook, used by internal teams.

  Note: risk data warehouse and versioned analytics apps

• 10/2021 – 04/2022
  Bogotá

  Credit Risk Analyst (ML credit scoring)

  Banco de Bogotá

  • Developed ML credit-scoring models (payroll-data scoring with decision thresholds; an early-delinquency model) with XGBoost, SHAP and PSI stability checks, and documented them for the risk team.

  Note: credit-scoring models

• 2021 – 2022
  remote

  Teaching assistant, MIAD Optimization course (Coursera)

  Universidad de los Andes

  • Wrote and graded Python/PuLP case assignments (marketing mix, depot location, project selection and scheduling, multi-objective location), exams and lecture material for the optimization course of the Master in Data Analytics Intelligence (MIAD), with Prof. Andrés Medaglia; tutored the programme's first cohort (Aug 2021).
• 01/2020 – 06/2020
  Bogotá

  Marketing Analytics Intern, Latin America Region

  Intel Corporation

  • Built marketing-analytics reporting and dashboards for the regional team (Optane/Gaming reports, spending reviews).

• 2024 – 2026

  Origin–destination matrices from smart-card data for Bogotá's BRT and bus network

  TRANSMILENIO S.A., Dirección Técnica Zonal · with Alejandro Palacio

  Maintained and extended an O-D estimation pipeline originally developed by a Universidad de los Andes research group with TRANSMILENIO: bug fixes, precision improvements, quality-control checkpoints and new outputs (load profiles, demand-rotation index). R and SQL on GCP BigQuery; runs daily in about 15 minutes end to end at near-zero marginal cost. Of about 3.8 million validations on a weekday (13 Feb 2026), about 68 % are chained to a destination before expansion and 97–99 % receive one after it. Used for new-route planning, weekend route redesign and daily dispatch.

  Case study

• 2020

  Metaheuristics suite (Python, public)

  github.com/robayo/metaheuristics

  Six algorithms with statistical calibration: path scanning (CARP), local search (ATSP), simulated annealing (n-queens), genetic algorithm (CVRP), iterated local search (multidimensional knapsack), large neighbourhood search (PDPTW).

  Repository

• 08/2021 – 12/2022
  degree conferred 04/2023

  Magíster en Ingeniería Industrial — M.Sc. Industrial Engineering

  Universidad de los Andes, Bogotá

  Concentration: operations research and applied statistics · cum laude (top 3 % of graduates under the Uniandes regulations in force at graduation; diploma on request)

  Thesis-based master's, begun in parallel with the B.Sc. (graduate courses 2019–2021 credited). GPA 4.84/5.0 (≈ 1.2 on the German scale, modified Bavarian formula). Thesis, 5.0/5.0: Association between HPV vaccination in Colombia and the risk of incident chronic disease — self-controlled case series, conditional Poisson regression, 55,114 vaccinated girls (advisor Carlos F. Valencia). Graduate coursework: Advanced Optimization (column generation, Lagrangian relaxation), Network Flows, Metaheuristics, Statistical Learning for Data Analytics, Linear Statistical Models, Advanced Topics in Statistics, Machine Learning.

• 08/2016 – 12/2020
  degree conferred 04/2021

  Ingeniero Industrial — B.Sc. Industrial Engineering

  Universidad de los Andes, Bogotá

  ABET-accredited · cum laude (top 3 % of graduates under the Uniandes regulations in force at graduation; diploma on request)

  GPA 4.53/5.0 (≈ 1.7). Minor in International Studies. Thesis, 5.0/5.0: A multi-criteria optimization model for bridge-intervention planning — MILP over ~1,500 national bridges within an INVIAS–Uniandes–Javeriana agreement (gurobipy; advisor Andrés Medaglia). Teaching assistant, Principles of Optimization and Finance, 2018–2019; research assistant, INVIAS bridge-management project, 2020.

• 2016

  Secondary education

  Ontario Secondary School Diploma, Hillcrest High School, Ottawa (02–06/2016) · Bachiller, Colegio de la Enseñanza, Bogotá

• 2021 – 2022

  Teaching assistant, Optimization course of the Master in Data Analytics Intelligence (MIAD)

  Universidad de los Andes on Coursera · with Prof. Andrés Medaglia

  Wrote and graded Python/PuLP case assignments (marketing mix, depot location, project selection and scheduling, multi-objective location), exams and lecture material; tutored the programme's first cohort (Aug 2021).

• 2018 – 2019

  Undergraduate teaching assistant, Principles of Optimization (2018-2, 2019-1, 2019-2) and Finance (2019-2)

  Universidad de los Andes

  Wrote the official assignment solutions (Xpress-Mosel), built grading tools (VBA) and ran training sessions.

• 2020-2

  Research assistant, INVIAS bridge-management research project

  Universidad de los Andes, School of Engineering research centre (contract VICE 3001)

• CV (PDF, English, 2 pages)updated 10/2026
• Lebenslauf (PDF, Deutsch, 2 Seiten)Stand 10/2026