Juan Ardila

Data Engineer with 5+ years of experience designing and optimizing scalable ETL/ELT pipelines, cloud-based data platforms, and analytics solutions using Databricks, Python, SQL, Azure, and AWS. Strong expertise in data modeling, workflow automation, orchestration, and integrating large-scale datasets to support business intelligence and operational decision-making. Experienced working with international teams and delivering high-impact data engineering solutions in fast-paced environments.

Senior Data Engineer, Financial Systems Analyst at Vantage (2024-01 – 2026-05)

• Designed and maintained ETL/ELT pipelines using Databricks, Python, and SQL for finance and operational analytics.
• Developed scalable data workflows integrating multiple enterprise data sources into centralized reporting environments.
• Built automated validation and reconciliation processes improving financial data accuracy and consistency.
• Optimized SQL queries and data models to improve dashboard refresh performance and reporting efficiency.
• Collaborated with business and technical stakeholders to define analytics requirements and implement data solutions.
• Supported migration initiatives from SQL Server environments to Azure cloud-based platforms.

Senior Data Engineer at IQVIA (2023-05 – 2024-05)

• Developed and optimized ETL/ELT pipelines using Databricks, Python, and SQL for large-scale supplier data transformation and analytics workflows.
• Worked with cloud-based data engineering solutions in Databricks to improve workflow orchestration, scalability, and data processing efficiency.
• Automated workflow orchestration using Apache Airflow.
• Implemented data quality validation frameworks reducing transformation inconsistencies.

Data Engineer at Teleperformance (2020-07 – 2023-03)

• Implemented ETL workflows to automate operational reporting and reduce manual effort.
• Integrated CRM and ERP data into centralized analytical solutions.
• Optimized cloud-based data management solutions for scalability and efficiency.

Master's in Software Engineering – Universidad de Los Andes

Bachelor's in Mechanical Engineering – Universidad de Los Andes