Data Management Associate Manager/Data Engineering Lead
Philip Morris Mexico
Nov 2020 - Jan 2025 (4 years 3 months)
Data Management Associate Manager/Data Engineering Lead
* Co-architected and deployed an event-driven ELT data platform, migrating legacy workloads into a centralized Snowflake Cloud Data Warehouse using Matillion for data orchestration.
* Designed and structured the enterprise data warehouse model, defining multi-layered data topologies (Staging, Integration, and Presentation layers), comprehensive fact/dimension tables, and optimized analytical views.
* Engineered a decoupled, automated data ingestion pipeline for multi-million row retail sell-out data: implemented schema and file validation (encoding, delimiter checks) in AWS S3, orchestrated asynchronous messaging triggers via AWS SQS, and automated target loading in Matillion.
*