Angel Alfonso Montoya Garcia
Data Engineer
Guadalajara
Summary
Data Engineer with 5+ years of experience building and optimizing data integration solutions, ETL/ELT pipelines, and data warehouse models. Hands-on expertise in Snowflake, dbt, Talend, Python, SQL, MySQL, and AWS, with experience supporting finance and operational analytics. Skilled in data modeling, data quality, automation, and platform modernization, with a strong track record of delivering reliable data solutions for reporting and self-service analytics.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
Work History
Data Engineer
AstraZeneca
02.2022 - Current
- I developed new integrations for the Finance data warehouse, enhancing OLAP (Snowflake) models. Using dbt and Talend, I ensured data integrity through data quality checks aligned with business data governance, enabling reliable analytics for Finance dashboards and reports.
- I am responsible for maintaining and optimizing the infrastructure of the Finance Data Hub Platform. This platform integrates data from diverse sources including SAP, business templates, and other data repositories. My primary focus is on supporting the ETL processes managed through Talend jobs, ensuring seamless transformation, and loading of data into MySQL and Snowflake databases.
- I supported and developed, working with the development team, an Automated Visualization tool built with Python, Airflow, and MySQL that ingests job metadata from the Talend API into an OLTP database. The tool provides stakeholders and developers with comprehensive visual insights into platform status and job health.
- I worked on migration of ETL integrations from Talend and MySQL to dbt and Snowflake, improving data integration performance, scalability, and user accessibility for analytics and self‑service reporting.
Business Intelligence Developer
Food Service Company
11.2020 - 02.2022
- I led data modeling to extract and standardize business data from the ERP database, designing a robust star-schema that aligned with key business processes and KPIs. As a result, OLAP cubes and semantic layers delivered fast, consistent analytics for dashboards and ad‑hoc reporting, reducing query times and enabling reliable, self‑service insights across different SET areas
- Instrumental in automating report generation processes to enhance efficiency and accuracy. Leveraged Python scripts and tools to design and implement automated workflows, minimizing manual intervention. Streamlined data extraction, analysis, and visualization, enabling timely and precise report delivery.
- Led end-to-end execution of Tableau Dashboard projects for Sales, Purchasing, and Logistics, employing KNIME ETL, Firebird DB, and Tableau. Transformed data processes, delivering real-time insights, while driving automation for enhanced efficiency.
Education
COMPUTATIONAL SYSTEMS ENGINEERING -
ITESO (Instituto De Estudios Superiores De Occidente)
Guadalajara, Jalisco 07.2015 - 12.2020
Skills
SQL
Data Modeling
AWS (Redshift, S3)
Snowflake Platform
ETL (Talend, Python)
ELT (dbt, Snowflake)
Timeline
Data Engineer
AstraZeneca
02.2022 - Current
Business Intelligence Developer
Food Service Company
11.2020 - 02.2022
COMPUTATIONAL SYSTEMS ENGINEERING -
ITESO (Instituto De Estudios Superiores De Occidente)
07.2015 - 12.2020