Jonathan Barzola Email & Phone Number

Lima, Perú

Lima, Perú

Data Engineer | Big Data Team | LATAM OperationsAs a Data Engineer in the Big Data team, I provide operational support to internal users across 9 countries in LATAM, ensuring the availability and accuracy of data in Snowflake. My focus is on cost optimization, efficient data management, and the automation of critical processes.Key Responsibilities: • Advanced Snowflake administration, participating in cost optimization projects to maximize the efficiency of data storage and processing. • Designing and implementing ETL pipelines using DMS to integrate data from DocumentDB and PostgreSQL into S3, ensuring robust and scalable data flows. • Creating and maintaining Fivetran connectors, ensuring continuous data integration across multiple systems. • Developing automated scripts in Python to manage JIRA tickets, monitor and resolve incidents in Fivetran connectors, and proactively run monitoring queries in Snowflake. • Implementing and managing instances of Jupyter and Airflow, as well as configuring workspaces in Astronomer and variables in Jenkins, facilitating an agile and efficient working environment. • Developing optimization processes using classification models, achieving significant cost reductions and performance improvements in systems.

Lima, Perú

Project I: Data Warehouse in Snowflake and Dashboards in Power BI I contributed to building a Data Warehouse in Snowflake, optimizing the storage and processing of large volumes of data, which enhanced efficiency. I created interactive dashboards in Power BI, making data analysis easier and enabling data-driven decision-making. I provided ongoing support and developed new features in Snowflake to adapt to the changing needs of users.Project II: Integration of SAP S/4 Hana with AWS and Visualization in Tableau I implemented data extraction from SAP S/4 Hana using AWS AppFlow, ensuring the integrity and accuracy of the transferred information. I used AWS Glue (PySpark) to transform and store data in S3, improving accessibility and optimizing workflows. I developed dashboards in Tableau that consume processed data via AWS Athena, delivering critical insights for decision-making.Project III: Process Automation and Data Management I extracted and processed data from an internal platform using AWS Lambda for web scraping, followed by processing and storage in S3, ensuring an efficient and automated workflow. I orchestrated automated processes with AWS Step Functions, enhancing system integration and overall operational efficiency.Project IV: Data Lake Implementation and Technical Training I participated in implementing a Data Lake in AWS, centralizing data management and facilitating faster and more efficient access to critical information. Additionally, I conducted over 20 technical training sessions on AWS services.Project V: Snowflake Training I led Snowflake training sessions for over 40 participants, significantly improving their skills on the platform and achieving more efficient use of the available tools.

Lima, Perú

Cloud Computing, Information Technology

I completed a training and skills development program focused on the fundamentals of IT, AWS cloud services, and professional skills. I.

Full Stack Web Developer, Web/Multimedia Management And Webmaster

I completed a Full Stack Developer training program, where I gained skills in the fundamentals of Web Development, including Frontend.