Juan Campias
@juancampias
Senior data engineer optimizing cross-border payments data pipelines on AWS.
What I'm looking for
I build and optimize the data infrastructure behind cross-border payments, processing billions of transactions across LATAM, APAC, and EMEA. At dLocal, I manage 129+ Apache Airflow DAGs and architect ETL pipelines on AWS to keep analytical systems fast and dependable.
I design data warehouse strategies and optimize performance in Amazon Redshift, including schema migrations, vacuum tuning, and query improvements. My work has identified $100K+ in annual cost savings, while keeping data quality, observability, and reliability aligned with cross-functional needs.
Previously, I led on-premises to AWS migration at Naranja X and consulted on Snowflake architecture for Banco Sabadell, reducing storage costs by 30%. I also created the Big Data specialization at Informatorio Chaco from scratch, graduating 200+ students across multiple cohorts.
I bring practical cloud engineering and data fundamentals to every initiative, supported by AWS Solutions Architect Associate (SAA-C03) and Astronomer Certified (Airflow 3). I’m driven by building maintainable pipelines that turn transactional data into trustworthy decisions.
Experience
Work history, roles, and key accomplishments
Designing and maintaining scalable data pipelines and ETL workflows using Apache Airflow to process payment transaction data across Latin America, Africa, and Asia Pacific. Optimizing Amazon Redshift data warehouses handling billions of rows, including schema migrations, vacuum tuning, and query performance improvements. Collaborating with cross-functional teams to ensure data quality, observabili
Sr Business Intelligence Engineer II
Dlocal
Feb 2025 - Mar 2026 (1 year 1 month)
Designed and maintained scalable data pipelines using Apache Airflow to enable efficient ETL workflows across cloud infrastructure. Leveraged AWS services including EC2, S3, RDS, Lambda, and Redshift to support merchant ingestion, transformation, and reporting.
Design and maintain scalable data pipelines using Apache Airflow, enabling efficient ETL workflows across cloud-based infrastructure. Leveraging AWS services such as EC2, S3, RDS, lambda & Redshift. Ensure reliable data ingestion, transformation, and reporting of top-tier merchants. My work supports business decision-making by delivering clean, timely, and accessible data to stakeholders.
BI Data Engineer into the @dLocal BI team.
We will take a tour of data analysis (extraction, transformation, and loading) to transform data into valuable and reliable information for organizations. Using major Python libraries and modules such as Flask, Requests, SQLAlchemy, Pandas, and Decouple. Additionally, designing, managing, and maintaining relational databases in local environments and corresponding Big Data concepts (Data Lake, Dat
Cloud Data Engineer
NowVertical ES
Jul 2022 - Oct 2023 (1 year 3 months)
Worked on cloud data engineering covering data lake architecture and data warehouse management with data transformation. Also supported a Big Data migration of on-premises databases to AWS cloud environments.
1. Google Cloud Platform speciality, DataLake architecture, Data Warehouse management, and data transformation.
2. Big Data team at Naranja X, performing the migration of On-premises databases to the AWS cloud.
Tutoring on professional practices and project management in workgroups for the final project in the development of a web application with Django.
Education
Degrees, certifications, and relevant coursework
Coderhouse
Data analytics, Tecnología de la información
2022 - 2022
I have experience as a technical analyst implementing solutions using Python, SQL, Power BI, DAX, M language, and Power Query.
Coderhouse
Data scientist, Tecnología de la información
2022 - 2022
I develop data analytics projects as a comprehensive analyst, from initial data gathering to creating dashboards. I am skilled in both the theory and implementation of Data Science projects, and I am able to create predictive models from scratch.
In this course, I am learning practical applications of Machine Learning and the use of NumPy, Pandas & Spark.
Universidad Nacional del Chaco Austral (UNCAUS)
Chemical engineering
2016 - 2022
Developed strong analytical and problem-solving skills through mathematical and statistical coursework. Gaining valuable experience in process analysis and systematic thinking.
Informatorio Chaco
Web Development Course, Tecnología de la información
2021 - 2021
I have knowledge and practical experience in using web applications with Django in Python, as well as designing and maintaining databases using the MVT paradigm and POO progrming.
KEI - School of English
Upper intermediate CEFR-B2, Certification of my English language proficiency as a foreign language(TEFL).
2020 - 2020
Availability
Location
Authorized to work in
Job categories
Skills
Interested in hiring Juan?
You can contact Juan and 90k+ other talented remote workers on Himalayas.
Message JuanGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
