Angel Alfonso Montoya Garcia
Data Integration Engineer
Guadalajara
Summary
Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.
Overview
5
5
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.
Data Integration Specialist
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
Timeline
Data Engineer
AstraZeneca
02.2022 - Current
Data Integration Specialist
Food Service Company
11.2020 - 02.2022
COMPUTATIONAL SYSTEMS ENGINEERING -
ITESO (Instituto De Estudios Superiores De Occidente)
07.2015 - 12.2020