I am a seasoned Mexican engineer with 25 years of experience in data architecture, ETL, and Snowflake development. I have designed data models, built data pipelines, optimized DWH performance, and delivered solutions across brokerage, healthcare, retail, automotive, insurance, and finance sectors. I enjoy collaborating with new teams, sharing knowledge, and embracing feedback to maintain high standards while delivering on time. I am enthusiastic about tackling complex data challenges, continuously improving processes, and adapting to new technologies. I thrive in dynamic environments and am committed to building scalable data architectures that empower analytics and business outcomes.

Edgar Ernesto Macias Perez

I am a seasoned Mexican engineer with 25 years of experience in data architecture, ETL, and Snowflake development. I have designed data models, built data pipelines, optimized DWH performance, and delivered solutions across brokerage, healthcare, retail, automotive, insurance, and finance sectors. I enjoy collaborating with new teams, sharing knowledge, and embracing feedback to maintain high standards while delivering on time. I am enthusiastic about tackling complex data challenges, continuously improving processes, and adapting to new technologies. I thrive in dynamic environments and am committed to building scalable data architectures that empower analytics and business outcomes.

Available to hire

I am a seasoned Mexican engineer with 25 years of experience in data architecture, ETL, and Snowflake development. I have designed data models, built data pipelines, optimized DWH performance, and delivered solutions across brokerage, healthcare, retail, automotive, insurance, and finance sectors. I enjoy collaborating with new teams, sharing knowledge, and embracing feedback to maintain high standards while delivering on time.

I am enthusiastic about tackling complex data challenges, continuously improving processes, and adapting to new technologies. I thrive in dynamic environments and am committed to building scalable data architectures that empower analytics and business outcomes.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Work Experience

Data Engineer at Xtendops US (via TCS, Mexico Remote)
June 1, 2025 - Present
Data architecture re-engineering; design and model data architecture; restructure Snowflake data architecture; analyze performance of data ingestion; model medallion architecture for Snowflake; develop and support Airflow DAGs as ETL; migrate ETL DAGs to Snowflake SP.
Data Engineer at International Medical technology Company (via TCS, Mexico Remote)
March 1, 2025 - June 1, 2025
Performed ETL enhancements in Databricks; design new pipelines; support real-time pipelines with Databricks; develop and optimize Python ETL processes; analyze ingestion performance.
Data Architect at Real Estate Company (via TCS, Mexico Remote)
October 1, 2024 - March 1, 2025
Defined architecture and mappings for automated data sources extraction; designed ETL/ELT architecture and data lake models; designed and implemented staging layer; developed Airflow DAGs to ingest via API.
Data Architect at Agriculture Company (via TCS, Mexico Remote)
February 1, 2024 - December 1, 2024
Defined architecture, designed and migrated from SQL Server to Snowflake using Fivetran to stage; transformed data with Coalesce; built data marts for Power BI; supported ETL/ELT pipelines.
Data Engineer at International Retail Brands (via TCS, Mexico Remote)
May 1, 2023 - May 1, 2024
Python, AWS and Redshift support; normalized brand data; designed and supported Airflow DAGs; optimized queries; validated data quality; configured and tested DAGs; designed and enhanced data models.
Data Architect at International Beer Company (via TCS, Mexico Remote)
January 1, 2023 - August 1, 2023
DWH and pipeline automation; full pipelines to extract data from internal systems for Tableau reports; IICS-based ETL to S3; Snowflake data modeling for 15 domains; designed data marts and Snowpipe.
Data Architect at Japan Car Company (via TCS, Mexico Remote)
November 1, 2021 - December 1, 2022
Tableau reports automation; design and deployment of pipelines for 15 domains and 40 Excel Tableau reports; on-prem and cloud data migration; Snowflake modeling and IICS-based workflows.
Snowflake Developer at IT Germany Company (via TCS, Mexico Remote)
January 1, 2020 - December 1, 2022
Oracle to Snowflake migration; DWH data modeling in Snowflake; deployment of dbt models; Tableau reporting; support for SAP-related data pipelines and Snowflake integration.
Data Architect / Consultant at Independent Consultant
February 1, 2009 - April 1, 2021
Roles included ETL development, data architecture, data analysis, Snowflake development, and data analytics across multiple clients; hands-on with Oracle, Snowflake, DynamoDB, AWS Glue, Airflow, and BI tools.

Education

Cybernetics and Computer Systems Engineer (Bachelor) at La Salle University
January 11, 2030 - January 1, 2003

Qualifications

PCEP – Certified Entry-Level Python Programmer
January 1, 2025 - February 9, 2026
SnowPro Core Certification
January 1, 2023 - February 9, 2026
AWS Cloud Practitioner Essentials
January 1, 2025 - February 9, 2026

Industry Experience

Financial Services, Healthcare, Retail, Manufacturing, Transportation & Logistics