Alvaro is available for hire
Hire AlvaroAlvaro Parra
Verified Expert in Engineering
Data Architect and Developer
La Paz, La Paz Department, Bolivia
Toptal member since July 16, 2021
Bio
Alvaro is a data engineer with 10+ years of experience in developing ETL pipelines and managing databases. He is certified in Snowflake and has expertise in Azure, Databricks, Python, Airflow, and DBT. Alvaro has engineered data solutions for the food/beverage, oil and gas exploration services, banking, credit card, and pharmaceutical industries. His work has significantly increased revenue, cut expenses, and improved data processing times and reliability.
Portfolio
Kimberly Clark Services, Inc. - Digital
Data Engineering, Azure Data Factory (ADF), Databricks, Azure Databricks...
PepsiCo
Data Engineering, Apache Airflow, Snowflake, Azure, Amazon Web Services (AWS)...
Precision Drilling
Python, SQL, ETL, Snowflake, Azure Kubernetes Service (AKS), Data Warehousing...
Experience
- Data Engineering - 6 years
- Python - 5 years
- Snowflake - 5 years
- Data Migration - 5 years
- Data Modeling - 4 years
- Apache Airflow - 4 years
- Data Build Tool (dbt) - 3 years
- Database Migration - 3 years
Preferred Environment
Azure Data Factory (ADF), Azure, Snowflake, Apache Airflow, Data Build Tool (dbt), Python, Azure SQL
The most amazing...
...project I've worked on helped the supply chain team at PepsiCo by providing reliable Inventory/product data for improving warehouse processes.
Work Experience
Senior Data Engineer
2026 - PRESENT
Kimberly Clark Services, Inc. - Digital
- Implemented Medallion architecture by building Azure Data Factory and Snowflake ELT pipelines to extract SQL Server marketing data and migrate it to Snowflake for use by an external system.
- Designed the data ingestion architecture for marketing services, collaborating across cross-functional teams to model data structures for adapting them to Snowflake.
- Created a data quality internal framework for checking and improving data migration and performance while migrating data.
Technologies: Data Engineering, Azure Data Factory (ADF), Databricks, Azure Databricks, Snowflake, Data Build Tool (dbt), ETL, Python, SQL, Spark, Apache Airflow
Data Engineer (Snowflake and Airflow)
2023 - PRESENT
PepsiCo
- Developed a Business Vault model for inventory reconciliation, enabling the planning team to use information from multiple plants for product ordering.
- Implemented a Business Vault model to identify product availability on distribution centers by integrating inventory, forecast, STO, and shipment data for enabling efficient product offerings for online platforms.
- Created a Business Vault model for Shelf Life, allowing the planning team to manage time-sensitive goods efficiently.
- Refactored and optimized multiple DBT models and macros for reducing Snowflake execution time and cost.
Technologies: Data Engineering, Apache Airflow, Snowflake, Azure, Amazon Web Services (AWS), Python, Data Build Tool (dbt), Data Modeling, ETL, ELT, Monte Carlo, Data Transformation, Amazon S3 (AWS S3), Microsoft Azure, JSON, Microsoft Fabric, API Integration
Data Engineer
2021 - 2023
Precision Drilling
- Implemented a backfill pipeline for solving Rig's data streaming-related issues. The pipeline automated the process and enabled an ad-hoc process for data backfilling.
- Saved information upload time by creating pipelines that extracted information from the SAP API and put it into staging tables, enabling us to get updated information that helped us improve data quality.
- Deployed an ETL pipeline for cleaning duplicate records on multiple tables. The process runs monthly, and it usually affects 2% to 5% of the total records.
- Improved data quality and reduced data complaints by implementing data quality into pipelines for detecting and fixing possible issues, which resolved issues automatically and sent email alerts on issues that could not be fixed.
Technologies: Python, SQL, ETL, Snowflake, Azure Kubernetes Service (AKS), Data Warehousing, Azure, Microsoft Excel, APIs, Star Schema, SQL Stored Procedures, SQL Performance, Apache Airflow, Data Engineering, Amazon Web Services (AWS), Stored Procedure, ELT, CSV, CSV Export, Data Extraction, Scripting, Data Build Tool (dbt), Database Design, Data Integration, Performance Tuning, ETL Tools, Data Governance, Data Validation, Data Structures, Solution Architecture, Data Pipelines, Pipelines, Amazon S3 (AWS S3), Databases, Data Transformation, Microsoft Azure, JSON, API Integration
Data Engineer
2019 - 2021
PROS
- Automated a pipeline for transforming files sent by a customer into XML that could be consumed by the PROS system by using Azure Data Factory, Databricks, Scala, and Python.
- Deployed a pipeline to extract data from Salesforce API and transform it into PROS XML by using Azure Data Factory, Databricks, and Python.
- Deployed a solution that extracted processed information from PROS and stored it into a customer’s Snowflake platform.
- Implemented complex SSRS reports on PROS for multiple customers that enabled users to access customized pricing information.
Technologies: Azure, Databricks, Data Engineering, SQL, Reports, Data Analysis, Data Modeling, Data Warehousing, Data Analytics, ETL, Microsoft Power BI, Azure Data Factory (ADF), Azure SQL, Microsoft SQL Server, Python, Data Pipelines, Databases, Pipelines, Pandas, Apache Spark, PySpark, Azure Data Lake, Microsoft Excel, APIs, Business Intelligence Consultant, Star Schema, SQL Stored Procedures, SQL Performance, Stored Procedure, ELT, CSV, Data Extraction, Scripting, Data Build Tool (dbt), Database Design, Data Integration, Performance Tuning, Transact-SQL (T-SQL), ETL Tools, Data Validation, Data Structures, Data Architecture, Architecture, Data Lakes, Solution Architecture, Amazon S3 (AWS S3), Microsoft Azure, JSON, API Integration
Data Management Analyst
2016 - 2019
Banco FIE
- Automated marketing ETL pipelines that saved 30% of the manual effort time.
- Deployed an ETL pipeline to scrape data from a weather API using Python and join it with data from bank branches to help discover branch transactions relative to weather. This helped to reduce operating costs by changing the number of cashiers.
- Collaborated with consultants at Rabobank (Dutch bank) in segmentation and high-value customer and mobile app usability projects by creating Python and Microsoft SQL Server ETL pipelines to extract and process customer data.
- Deployed an ETL pipeline that processed debit card information to help discover the bank’s ATM usage. This helped reduce ATM maintenance costs by relocating unused ATMs.
Technologies: Microsoft Power BI, SQL, Data Engineering, Python, Reports, Data Modeling, Data Warehousing, Data Analytics, ETL, Data Marts, Microsoft SQL Server, Business Intelligence (BI), Data Analysis, Data Pipelines, Web Scraping, Databases, Pipelines, Pandas, PostgreSQL, Microsoft Excel, APIs, Business Intelligence Consultant, Data Management, Data Analysis Consultant, Star Schema, SQL Stored Procedures, SQL Performance, Stored Procedure, CSV, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, Transact-SQL (T-SQL), ETL Tools, Entity Relationships, Data Governance, Database Security, Data Validation, Data Structures, Data Entry, Automated Data Flows, Excel VBA, JSON
Database Administrator
2015 - 2016
Administradora de Tarjetas de Credito ATC
- Developed and designed ETL pipelines on SSIS to help reduce debit and credit card fraud, increasing fraudulent debit card detection.
- Deployed an ETL using Python to process monthly debit and credit card information sent to affiliated banks and reduce processing time.
- Migrated a 250GB data warehouse, including stored procedures and ETLs, from Microsoft SQL Server to Azure SQL.
Technologies: SQL Server Reporting Services (SSRS), MySQL, SQL, Data Modeling, Databases, Python, ETL, Data Marts, Microsoft SQL Server, Business Intelligence (BI), Data Engineering, Data Pipelines, Data Analytics, Pipelines, Pandas, Microsoft Excel, APIs, Star Schema, SQL Triggers, SQL Stored Procedures, SQL Performance, MySQL Server, Stored Procedure, PL/SQL, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, Dynamic SQL, Transact-SQL (T-SQL), ETL Tools, Entity Relationships, Database Security, Data Validation, Data Structures, Automated Data Flows, Excel VBA, Pentaho, JSON
Business Intelligence Developer
2014 - 2015
Grupo Alcos
- Deployed marketing ETL on SSIS that processes information from OLTP databases to analyze product consumption, increasing top product sales.
- Developed and migrated multiple dashboards from Excel to QlikView.
- Migrated a 100GB data warehouse, including stored procedures and ETLs, from Informix to Microsoft SQL Server.
Technologies: MySQL, SQL, Business Intelligence (BI), Data Modeling, Data Warehousing, Databases, Data Analytics, Data Engineering, Pipelines, ETL, Data Marts, Microsoft SQL Server, Python, Data Analysis, Data Pipelines, Database Migration, Dashboards, Microsoft Excel, APIs, Business Intelligence Consultant, Data Management, Data Analysis Consultant, Star Schema, SQL Triggers, SQL Stored Procedures, SQL Performance, MySQL Server, Stored Procedure, PL/SQL, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, Dynamic SQL, Transact-SQL (T-SQL), ETL Tools, Entity Relationships, Data Structures, Automated Data Flows, Excel VBA, Pentaho, JSON
Experience
Dashboard for Pharmaceutical Marketing Department
I collaborated with the marketing team in a pharmaceutical company to extract information and build a dashboard to visualize, analyze, and increase sales.
PROBLEM
Employees were trying to process and analyze millions of sales on Excel spreadsheets, which was time-consuming and error-prone. The marketing manager requested a solution that could optimize and improve the process.
SOLUTION
We started by designing a data warehouse to extract information from the company's selling system. To store that information, we bought a server and installed a Microsoft SQL Server database. Next, we installed Pentaho Kitchen on another server and developed ETL pipelines to process information.
Once the design was stable, we began work on the visualization tool. We had QlikView at that time, so that's how we started developing the visualization portion. The new dashboard had a significant impact, as processes that had taken hours were done in a matter of minutes. It allowed us to measure each agency's sales and provide information to improve overall company sales.
PROBLEM
Employees were trying to process and analyze millions of sales on Excel spreadsheets, which was time-consuming and error-prone. The marketing manager requested a solution that could optimize and improve the process.
SOLUTION
We started by designing a data warehouse to extract information from the company's selling system. To store that information, we bought a server and installed a Microsoft SQL Server database. Next, we installed Pentaho Kitchen on another server and developed ETL pipelines to process information.
Once the design was stable, we began work on the visualization tool. We had QlikView at that time, so that's how we started developing the visualization portion. The new dashboard had a significant impact, as processes that had taken hours were done in a matter of minutes. It allowed us to measure each agency's sales and provide information to improve overall company sales.
Education
2008 - 2013
Bachelor's Degree in Computer Science
Universidad Mayor de San Andrés - La Paz, Bolivia
Certifications
MAY 2026 - MAY 2028
SnowPro Core
Snowflake
MAY 2022 - PRESENT
Azure Data Engineer Associate
Microsoft
SEPTEMBER 2021 - PRESENT
DP-900: Microsoft Azure Data Fundamentals
Microsoft
NOVEMBER 2019 - PRESENT
MCSA: SQL 2016 Database Development
Microsoft
Skills
Libraries/APIs
PySpark, Pandas
Tools
Apache Airflow, Microsoft Excel, Microsoft Power BI, Azure Kubernetes Service (AKS), AWS Glue
Languages
SQL, Python, Snowflake, Stored Procedure, Transact-SQL (T-SQL), Excel VBA
Paradigms
ETL, Business Intelligence (BI), Database Design
Storage
Databases, SQL Stored Procedures, Data Validation, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Data Pipelines, Database Migration, PostgreSQL, SQL Triggers, SQL Performance, MySQL Server, Data Integration, Dynamic SQL, Oracle PL/SQL, Data Lakes, Amazon S3 (AWS S3), JSON, Azure SQL, MySQL, PL/SQL, Database Security, Redshift
Platforms
Databricks, Azure, Pentaho, Azure Synapse, Amazon Web Services (AWS), Microsoft Fabric
Frameworks
Apache Spark, Spark
Other
Data Engineering, Data Analysis, Data Warehousing, Business Intelligence Consultant, Data Management, Star Schema, CSV, CSV Export, Data Extraction, Automated Data Flows, Reports, Data Modeling, Data Analytics, Pipelines, APIs, Azure Data Lake, Data Analysis Consultant, ELT, Scripting, Data Build Tool (dbt), Data Migration, Performance Tuning, ETL Tools, Entity Relationships, Data Governance, Data Structures, Data Entry, Architecture, Cloud Migration, Solution Architecture, Microsoft Azure, API Integration, Azure Data Factory (ADF), Data Marts, Web Scraping, Big Data, Dashboards, Data Visualization, Financial Reporting, Data Queries, Azure Databricks, Data Architecture, Monte Carlo, Data Transformation
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring