Learn Data Skills
Beta
Lucas Agustin Madrid Druetta

Lucas Agustin Madrid Druetta

Data Engineer

AGOS Global | Spain

Technologies

My Portfolio Highlights

My New Course

Understanding Data Engineering

My New Course

Understanding Data Engineering

Data explorer, embarking on expeditions to uncover hidden insights.

My Work

Take a look at my latest work.

course

Cleaning Data with PySpark

PythonSQLGit
course

Database Design

SQLShellTheory
course

Cleaning Data with PySpark

PythonSQLGit

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

AGOS | Apr 2023 - Present

Data Engineer

Achieved a remarkable 60% reduction in GCP cloud costs through the implementation of best practices and continuous monitoring of billing resources, ensuring cost-effective utilization of cloud services. Spearheaded the integration of diverse data sources across data engineering pipelines, facilitating the creation of a comprehensive management subscriptions dashboard, and providing valuable insights and decision support. Developed custom Python scripts to dynamically transform data from various sources, enhancing data processing efficiency and flexibility. Led successfully migrating AWS Lambda functions to GCP Cloud Functions, optimizing performance and resource utilization while ensuring a seamless transition. Led the successful migration from GCP architecture to Azure Databricks solution by moving the data pipelines alongside the data warehouse located in BigQuery.
Show More

Clear Tech | Feb 2022 - Apr 2023

GCP Developer & Data Engineer

Spearheaded designing and managing data transformation and automation routines utilizing GCP Data stack technologies. Collaborated with cross-functional teams to devise engineering solutions leveraging GCP ETL Tools, such as Cloud Dataflow and Cloud Function, facilitating seamless data movement between diverse source/target systems and enterprise information repositories to Cloud Storage and BigQuery. Fostered effective collaboration with Data Analysts and Business Analysts to glean insights into new requirements, subsequently orchestrating the development of robust ETL pipelines for integrating a diverse array of data sources into a centralized solution. Proficiently executed performance enhancements and orchestrated the migration of complex SQL queries from PowerBI, which fueled dashboards, to the streamlined data modeling platform, Looker. Pioneered the creation of data models and crafted visually engaging dashboards using Looker. Actively collaborated with Data Engineers to construct data applications capable of managing and processing real-time streaming and batch data as part of a notification system. Utilized application logs in partnership with Product Owners to measure performance and identify potential errors, ensuring optimal system functionality. Led the migration and replication of databases across various environments, employing the open-source tool, DBMATE.

Globant | Sep 2020 - Feb 2022

Bi Analyst & Data Engineer

• Leveraged SQL expertise in data modeling for both OLAP and OLTP systems, enhancing data-driven decision-making capabilities. • Drove ETL pipeline integrity through meticulous code peer reviews, upholding best practices and high data quality standards. • Provided precise project development forecasts, ensuring alignment with management on timelines and objectives for successful delivery. • Enhanced query performance in collaboration with Data Engineers and BI teams, accelerating dashboard responsiveness and user experience. • Led the refinement and scaling of data management and analytics, optimizing operational efficiency and strategic insights. • Analyzed research data to uncover opportunities, delivering actionable recommendations for informed management decisions. • Led SQL data modeling for OLAP/OLTP, enhancing decision-making • Developed Python scripts for efficient API data manipulation, improving data extraction and integration workflows. • Executed comprehensive unit testing on data processes, guaranteeing adherence to management's quality and performance expectations.

Globant | Oct 2019 - Sep 2020

.NET Developer

N/A

VATES - Ingeniería en Software | May 2019 - Aug 2019

QA Tester

N/A

Powered by

  • Work
  • Courses
  • Experience
  • Create Your Data Portfolio for Free