Diego Trujillo Data Engineer / Data Architect / Data Analyst

M

Data Engineer

My Code

Sep 2023 - Apr 2025 (1 year 8 months)

● Led the migration of all company dashboards from the legacy system to a modern AWS-based architecture. ● Analyzed stakeholder requirements to ensure newly developed Qlik dashboards provided relevant insights using PostgreSQL Aurora and other data connections. ● Optimized queries to effectively leverage Qlik’s built-in data model, improving data retrieval performance. ● Defined and implemented Row Level Security (RLS) to ensure department-based access control. ● Developed a data validation technique to continuously check for discrepancies between data sources and alert the team if ETL processes failed to maintain consistency.

Data Engineer Team Lead

Team International S.A.S.

Jun 2021 - Current (4 years 11 months)

● Led the development of a robust data architecture to process, clean, and store historical information from raw, unstructured data sources using Google BigQuery, Cloud Functions, REST APIs, Pub/Sub, and Dataform. ● Optimized daily ETL processes handling millions of rows to ensure cost-efficiency and eliminate unnecessary processing expenses. ● Designed and implemented cronjobs for various data refresh frequencies, including 15-minute updates and monthly backups, ensuring data integrity and disaster recovery. ● Architected a multitenancy data warehousing solution, enabling multiple clients to store and access data securely with Row Level Security (RLS) enforcement. ● Developed and managed a Power BI Embedded solution, allowing web applicati

Data Scientist

MAS Global Consulting

May 2019 - May 2021 (2 years 1 month)

● Led the Data Science team of 2 people, responsible for developing dashboards and data solutions for both the executive and HR teams. ● Conducted analysis of HR interview data to optimize the hiring pipeline, reducing time-to-hire and improving talent acquisition efficiency. ● Established a methodology for identifying unique skill sets in applicants, helping clients determine whether job roles should be split into multiple positions or if specialized searches were necessary. ● Developed an executive dashboard in Power BI aggregating data from all departments, presenting KPIs to board members for strategic decision-making. ● Created a salary range analysis tool based on skillsets and tenure, providing HR with actionable insights for employe

C

Data Scientist

Cafeto Software SAS

Jul 2018 - Apr 2019 (10 months)

● Led a team of two people managing Big Data processes to capture advertisement data from organic and non-organic traffic. ● Developed AWS-based data pipelines for near-real-time data processing using Athena, Glue, Redshift, and Lambda Functions. ● Led the migration of dashboards from QlikView to Tableau, restyling them to prioritize stakeholder needs and improve usability. ● Ensured Tableau dashboards were refreshed more frequently throughout the day for up-to-date insights.

Data Scientist

OMNIBNK

Jan 2018 - Jun 2018 (6 months)

Responsible for the creation of an intelligent model that analyzes the history of electronic invoicing of companies in Chile and decides whether or not the company can aspire to the credit line it is requesting through the different technological platforms of the financial partners.

Data Scientist

Tinamica

Jul 2017 - Dec 2017 (6 months)

Lead Data Scientist. Consultant for different companies. Execution of projects for the automatic generation of reports, analytics and different techniques of data science that allow making better decisions. * Project: OSFI Metrics. Scotiabank Group. Project leader: Creation of automatic processes for the generation of risk and liquidity area reports for the regulator in Toronto, Canada. * Project: Curiosity Tunnel. Project winner in the Big Data 2019 Awards in Spain. Creation of strategies and mathematical techniques for the study of concrete and the reconstructed ferrous system with LIDAR technologies.

Data Scientist Jr

Datasketch

Aug 2016 - Apr 2017 (9 months)

Exploration, analysis and data cleansing. Execution of different big data techniques to process and transform data from different sources. Creation of different news in Datasketch portal with data story-telling. Data journalism. * Retail Project: Creation of different web visualization dashboards for different people in the organization, advising which visualizations fit the data the most. * Spatial Project: Data cleansing from different external sources. Geographic visualizations from data were captured from external sources and internal customer sources. * Creation of a data visualization library. We collected 100+ different types of visualizations in order to recreate them with the ggplot2 library (R) in a web visualization dashboard (sh

Modelador de Productos Jr

Pitmmam Innovación y Tecnología S.A.S.

Jan 2016 - Jul 2016 (7 months)

Responsible for the creation of an intelligent model that could forecast the number of cashiers every Exito -one of the biggest retailers in Colombia- store should have at any period, given the company's IoT data in real-time.

Intern

Coca-Cola Femsa

May 2014 - Jun 2015 (1 year 2 months)

Responsible for the creation of an intelligent model that could forecast the total amount of sales for a given product. Non-stochastic models were used to build an optimal mesh over very well known statistical models.

Diego Trujillo

About

Detail

Timeline

Résumé

Diego Trujillo new_releases

About

Detail

Diego Trujillo