Nicolás Robayo Pardo

Profile

Data Analytics Engineer with 5+ years of experience designing cloud data platforms, ML-powered automation, and end-to-end BI solutions across finance, insurance, and risk management. Driven by turning fragmented data into scalable analytics platforms that enable executive decision-making, replacing manual processes with production pipelines and intelligent automation that deliver measurable business outcomes.

Experience

LifeOne – Central America Warranty & Assistance Company

Remote

Head of Data & Analytics

May 2025 – Present

  • Architected the company's cloud analytics infrastructure from scratch using AWS RDS, S3, DuckDB, Python, SQL, and Docker, deploying a Power BI Embedded platform with 10+ production dashboards serving 70+ users across 5 business units.
  • Designed and automated 15+ ETL/ELT pipelines orchestrated with Prefect, processing diverse data sources including SQL databases, REST APIs, and JSON/XML feeds, eliminating 2 FTE of manual reporting effort.
  • Engineered a production AI/ML solution for claims automation using NLP-based intelligent agents, reducing resolution time by 70% and achieving 100% bot-handled processing without quality loss.
  • Partnered directly with C-suite to define enterprise data strategy, KPIs, and governance frameworks; led a team of 2 data engineers and managed data integration partnerships with major retail clients.
  • Data Engineering
  • AI/ML
  • Power BI
  • ETL/ELT

Colombia Counterparty Clearing House (CRCC)

Bogotá, Colombia

Data Scientist – Risk & Methodologies

May 2022 – May 2025

  • Designed and implemented a star schema data warehouse consolidating risk and market data for regulatory and internal reporting, with automated risk-management models and executive dashboards that streamlined back-testing workflows.
  • Built interactive Shiny applications enabling stakeholders to visualize risk exposures, pricing dynamics, and regulatory metrics in real time, eliminating 4 FTE of manual evaluation and reporting.
  • Deployed AI-powered customer service chatbots using Retrieval-Augmented Generation (RAG) techniques, improving response accuracy and significantly reducing support team workload.
  • Data Warehousing
  • AI
  • NLP
  • Risk Management

Banco de Bogotá

Bogotá, Colombia

Data Scientist

Aug 2021 – Apr 2022

  • Developed a predictive ML credit-scoring model combining credit bureau and payroll data sources, optimizing approval thresholds to expand the bank's approved customer base while maintaining portfolio quality standards.
  • Machine Learning
  • Credit Scoring

Intel Corporation

Bogotá, Colombia

Americas Strategy & Insights Intern

Jan 2020 – Jul 2020

  • Designed and launched a cloud-based sales analytics dashboard for regional leadership, transforming data-driven decision-making across the Americas division.
  • Recognized with the Quality Award and One Intel Award.
  • Analytics
  • Cloud Solutions

Education

M.Sc. Industrial Engineering

Universidad de Los Andes, Bogotá, Colombia

Jan 2021 – Dec 2022

GPA: 4.84/5.0 (cum laude). Coursework: Machine Learning, Advanced Optimization, Time Series Analysis, Flow Networks, Heuristics.

B.Sc. Industrial Engineering, Minor in Global Studies

Universidad de Los Andes, Bogotá, Colombia

Aug 2016 – Dec 2020

GPA: 4.53/5.0 (cum laude).
photo of me
Download CV

Skills

    • Data Engineering
    • Python
    • SQL
    • Snowflake
    • Prefect
    • Apache Airflow
    • DuckDB
    • Spark
    • APIs
      Cloud & DevOps
    • AWS (RDS, S3, Glue, Lambda, ECS)
    • GCP
    • Docker
    • Jenkins
    • CI/CD
      BI & Modeling
    • Power BI (DAX, M, Embedded)
    • Shiny
    • Star Schema
    • Dimensional Modeling
      ML & AI
    • NLP
    • RAG
    • Scikit-learn
    • Predictive Modeling
    • Statistical Analysis
    • R

Languages

  • Spanish
    Native
  • English
    C2
  • French
    B1
  • German
    B1

Diplomas

  • IBM Data Engineering Professional Certificate

Interests

  • Global Politics
  • Cooking
  • Public Transpo.
  • Paragliding
  • Electronic music