Senior Data Engineer

• Aug 2022 - Present

Senior Data Engineer

• Feb 2022 - Aug 2022

● Consume of different API's with Python, such as Google Ads and Facebook, to extract raw data and then store this in Parquet and JSON format on s3 for data processing. ● Architecture design and schema creation in AWS Athena through Glue Jobs, Crawlers and Lambda Functions to query raw data directly from the data lake on S3. ● Developing and automation of ETL’s, integrating different data sources and loading data into data warehouse allowing data analysts and data scientists to have reliable data for modelling and further analysis. ● Automation of QA data ingestions and QA data processing, reducing reprocessing and generating alerts for the different teams to be reviewed. ● Implementation and proofs of concepts for different technologies to be used for the business team. Show less

Product Manager Automation & Analytics

• Mar 2021 - Feb 2022

● Developing of analytical solutions, prototypes and proofs of concept for different business cases. ● Implementing complex technological and analytical projects with a focus on collecting, managing, analyzing and visualizing data for sellers, vendors and stakeholders. ● Definition, development and deployment of digital products and data monetization models such as attribution models, recommendation models and prediction models. ● Design, develop and maintain scripts and routines in different programming languages in the cloud to enhance automation level of data processing and integrating from different data sources. Show less

Operations Coordinator

• Jun 2020 - Mar 2021

• Database administration and generation of dashboards to optimize, measure and control the operation and guarantee customer satisfaction. • Continuous improvement of the supply chain operation through the automation of ERP systems, planning systems, implementation of KPI’s and constant training for the work team. • Data analysis that allows the correct planning of each product to meet the requirements of each customer. • Database administration and generation of dashboards to optimize, measure and control the operation and guarantee customer satisfaction. • Continuous improvement of the supply chain operation through the automation of ERP systems, planning systems, implementation of KPI’s and constant training for the work team. • Data analysis that allows the correct planning of each product to meet the requirements of each customer.

Data & Information Consultant

• Nov 2018 - Jun 2020

• Generation of reports and dashboards according to customer needs, presenting the necessary information for decision-making. • Database administration and information extraction to obtain insights that help to develop new products based on information for different markets. • Creation of queries for the operation that allow to automate the data extraction processes. • Debugging of databases in order to obtain reliable information which can be presented in different dashboards to customers. • Optimization of existing queries and views to make queries more efficient. Show less

Planning Engineer

• Jul 2018 - Nov 2018

• Development of spreadsheets in Excel to calculate the operating costs and budget of the company, thus reducing the cost overruns by 2% and developing a new cost allocation. • Planning and calculation of delivery times for each of the projects, taking into account the logistics costs, production times, installation times and technical specifications of each of the equipment. • Improvements within the supply chain process of the elevator business unit, through tools such as MRP and KPI’s that allowed to eliminate the restrictions on the productions system and optimize the whole process by 5%. • Creating of purchase orders to the headquarters in Japan as well as the realization of different engineering technical consultations for each of the technologies to be implemented. Show less