Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Languages
Websites
Timeline
Generic
JUAN FELIPE GÓMEZ LÓPEZ

JUAN FELIPE GÓMEZ LÓPEZ

Pereira,Risaralda

Summary

Accomplished Senior Data Engineer at Aimpoint Digital, skilled in Python and AWS, with a proven track record of optimizing data pipelines and enhancing cloud integration. Adept at collaborating with cross-functional teams, I drive impactful solutions that elevate organizational capabilities and support strategic decision-making.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

Aimpoint Digital
05.2025 - Current
  • Developed tools and products for internal projects to enhance company capabilities.
  • Designed study materials and created hands-on projects for NCDP training program participants.
  • Authored an article assessing new features of Snowflake through rigorous evaluation and testing.
  • Collaborated with a video-sharing platform client on Databricks implementation, integrating workflows across multiple platforms.
  • Optimized data pipelines and orchestration processes for seamless integration of cloud services and data platforms like Kafka, Airflow, and dbt.

Data Engineer

Factored
09.2021 - 05.2025
  • Developed and maintained a big data pipeline (Airflow, AWS Batch, Snowflake, Jenkins) with efficient Python code and Great Expectations validations, aiding investment decisions at a top investment management firm.
  • Created and managed internal Python packages for web scraping publicly available data to support investment research at a leading investment management firm.
  • Developed a data extraction pipeline (Python, Airflow, Glue, PySpark, dbt) from RDS and S3 to Redshift, enabling dimensional modeling.
  • Implemented a real-time data processing pipeline (Kinesis Data Firehose, Lambda) with Terraform deployment.
  • Guided data strategy using Airflow to orchestrate data extraction and NLP model execution in AWS Batch.
  • Created data processing jobs for data lake zone movement (Python, Glue, PySpark).
  • Automated infrastructure deployment with CI/CD pipelines (GitHub Actions, Terraform).
  • Contributed to defining courses and projects for the internal training program.
  • Designed and implemented training material for the data warehouse, data lake usage, SQL, and PySpark.
  • Used Terraform for AWS resource provisioning and permissions in the internal training program.

Data Engineer

Summan
Medellín
05.2019 - 09.2021
  • Developed an Airflow framework in Python for dynamic DAG creation using configuration files, incorporating design patterns (strategy, template, factory method).
  • Managed scalable data pipeline workflows with Apache Airflow, orchestrating Docker jobs in EKS, and implementing dbt for dimensional data modeling in AWS Redshift for a prominent Colombian parking company.
  • Implemented company-wide data architectures using Splunk for a construction materials manufacturer in Colombia.
  • Contributed to various company initiatives, evaluating DataOps and MLOps frameworks for potential adoption.

IT Functional Analyst

Cadena
La Estrella
03.2018 - 05.2019
  • Led BI report development using SSIS to extract, transform, and load data from MS SQL databases.
  • Implemented Python automation for generating tracking guides from templates in official learning exams packing for Colombia's government.
  • Managed software requirements, wrote user stories, and applied agile project methodologies.
  • Analyzed infrastructure and database requirements for business applications, evaluating resource consumption.

Software Engineer Intern

TELSAT
Medellín
01.2017 - 07.2017
  • Created a monitoring system (HTML, CSS, JavaScript, Express.js, MySQL) for a healthcare company in Colombia to track entry and exit.
  • Built a turnstile system (Java) on a Raspberry Pi to collect Colombian ID data for a MySQL database.
  • Designed a desktop queuing app (HTML, CSS, JavaScript, Electron) for medical appointment check-ins.
  • Enhanced assistance control system (Excel macros in Visual Basic) for Colombian ID data storage.
  • Developed the company website using Angular and Express.js.

Education

Specialization - Big Data & BI

EIA University
Medellín
07-2019

B.S. - Mechatronics Engineering

EIA University
Envigado
12.2017

Skills

  • Python
  • SQL
  • AWS
  • Airflow
  • Snowflake
  • Pytest
  • Terraform
  • Dbt
  • PySpark
  • GitHub Actions

Certification

  • AWS Certified Solutions Architect - Professional, AWS, 08/01/24, 08/01/27
  • AWS Certified Solutions Architect - Associate, AWS, 08/01/21, 08/01/27
  • AWS Certified Cloud Practitioner, AWS, 08/01/22, 08/01/27
  • Astronomer Certification for Apache Airflow Fundamentals, Astronomer, 06/01/22
  • Data Engineering Nanodegree, Udacity, 12/01/21
  • The Software Designer Mindset Course Completion, ArjanCodes, 07/01/23
  • Splunk Enterprise Certified Architect, Splunk, 10/01/20, 10/01/23

Affiliations

  • Solving the Rubik's Cube
  • Board Games
  • Video Games
  • Playing Piano
  • Traveling
  • Concerts

Languages

Spanish
First Language
English
Upper Intermediate (B2)
B2
French
Elementary (A2)
A2

Timeline

Senior Data Engineer

Aimpoint Digital
05.2025 - Current

Data Engineer

Factored
09.2021 - 05.2025

Data Engineer

Summan
05.2019 - 09.2021

IT Functional Analyst

Cadena
03.2018 - 05.2019

Software Engineer Intern

TELSAT
01.2017 - 07.2017

Specialization - Big Data & BI

EIA University

B.S. - Mechatronics Engineering

EIA University
JUAN FELIPE GÓMEZ LÓPEZ