Open to Work · CDMX / Open to Relocation
Pablo Díaz Avila

Pablo Díaz Avila

Data Engineer · Analytics & BI

About Me

Data Engineer and Analytics professional with 3+ years of hands-on experience across enterprise clients in telecom, consulting, FMCG, media and financial services. Industrial Engineer (IPN–UPIICSA) with a Computer Science specialization — my engineering background shaped the way I work with data, approaching every project with a process and business mindset.

My work spans the full data stack — from ingesting and transforming data with Python, SSIS and Spark, to modeling and storing it in Azure Databricks, Snowflake and AWS S3, to delivering insights through Power BI, Tableau and Excel. I started my career at Telefónica Movistar while still completing my Industrial Engineering degree at IPN — UPIICSA, and have been building enterprise-grade data solutions ever since.

Currently based in CDMX and open to remote, hybrid or relocation opportunities where data engineering and analytics create real business impact.

3+
Years of Experience
10+
Projects Delivered

Academic Background

2024 · Bachelor's Degree

Industrial Engineering

Instituto Politécnico Nacional — UPIICSA

Specialized in the Computer Science curricular line, with coursework in systems analysis, information technology, databases, and process optimization. Started my professional career at Telefónica Movistar while still a student — applying classroom concepts to real enterprise data challenges from day one.

Systems AnalysisProcess Optimization Computer Science TrackIPN · UPIICSA
2024 · Diploma

Data Science

DEVF

Intensive diploma covering the full data science workflow: statistical analysis, machine learning, Python for data, and visualization techniques. Deepened the analytical foundations built through 3+ years of hands-on enterprise data engineering experience.

PythonMachine Learning StatisticsData Visualization

Tech Stack

Python
Spark
SQL
SSIS
Databricks
Snowflake
Power BI
Tableau
Excel
Azure
AWS
Power Automate
Power Apps
Git

Data Engineering Architecture

Data Sources

Oracle · SQL Server · APIs

ETL

SSIS · Python ETL · Spark Processing

Storage

Azure Databricks · AWS S3 · Data Lakes

Analytics

Power BI · Tableau · Excel

Portfolio

A selection of data engineering and analytics solutions delivered across telecom, consulting, FMCG, media and financial services. Each project reflects a focus on pipeline reliability, reporting automation, and turning operational data into business-ready insights.

Telefónica Movistar

Revenue & Collections BI Dashboard

Multi-channel billing dashboard tracking delinquency, aging buckets and recovery rate across all billing channels.

Power BI · DAX · Finance · Data Modeling
Deloitte

Financial Reconciliation Automation

SQL-based pipeline matching ERP transactions with SAT CFDI invoices, surfaced in a Power BI dashboard.

SQL Server · T-SQL · Power BI · DAX
Deloitte

.NET Financial File Loader

C# program to automate ingestion of Excel financial reports into SQL Server for internal reconciliation workflows.

.NET (C#) · SQL Server · Data Validation
Nestlé

Sales & Stock Evolution Dashboard

Automated self-service Power BI dashboard with Power Automate delivery to Supply Chain and Sales teams for on-demand analysis.

Power BI · Power Automate · DAX · Power Query
Nestlé

Alice Project — Logistics Data Migration

Full logistics migration to Azure Databricks with layered schemas (inbound → silver → gold) and zero downtime.

Azure Databricks · Python · SQL · ETL
Nestlé / Nongam

Nongam — South America Reporting

Legacy DB decommission and migration to SharePoint + Power BI with paginated reports for regional operations.

Power BI · SharePoint · Report Builder · SQL
MVS Radio

MVS Education — Sales Performance Dashboard

Excel BI dashboard tracking enrollment, revenue vs budget and branch-level performance across MVS Education.

Excel · Power Query · Power Pivot · DAX
Grupo Salinas

Legal Collections Performance Dashboard

Automated Power BI dashboard tracking collections KPIs for 1M+ accounts — reduced manual reporting by 90%.

Power BI · DAX · Power Query · Automation
Grupo Salinas

Collections KPI Dashboard — Tableau

Tableau dashboard connected to AWS S3 tracking agent-level deficit, weekly quotas and collections productivity.

Tableau · AWS S3 · Python · Data Pipelines

Professional Timeline

2022
Telefónica Movistar
BI & Analytics
· Billing & Collections BI Dashboard — Power BI
· Accounts Receivable KPI tracking
2022
Deloitte
Data Engineering & Analytics
· Payment Reconciliation Dashboard — J&J & Amazon
· .NET Financial File Loader
· Stored Procedure for BI Report Generation — Sky.
2022-2024
Nestlé
Data Engineer
· Fiscal Reporting ETL — SSIS & SQL Server
· Alice Project — Logistics Migration to Azure Databricks
· Sales & Stock Dashboard — Power Automate delivery
· Nongam South America — Power BI & Report Builder
2024-2025
MVS Radio
Analytics & BI
· MVS Education Sales Dashboard — Power Pivot & DAX
· HR Dashboard — Power BI & Azure
· Monthly Accounting Auxiliary — Power Query
· Oracle Analytics Reports — Accounts Payable
2025-2026
Grupo Salinas
Data Engineer & BI
· Legal Collections Dashboard — Power BI, 90% less manual work
· Collections KPI Dashboard — Tableau & AWS S3
· Data visualization workshop for Legal Collections team

Contact

Ready to turn data into strategic advantage? Let's work together.