Logo
Guillermo – Apache Airflow, Redshift, AWS, experts in Lemon.io

Guillermo

From Argentina (GMT-3)

flag
Data EngineerSenior
Data AnalystSenior
Business AnalystSenior
Hire developer
25 years of commercial experience
Analytics
Business intelligence
Data analytics
Human resources
Retail
Lemon.io stats

Guillermo – Apache Airflow, Redshift, AWS

Guillermo brings over 20 years of tech experience to the table, having navigated roles from Business Analyst to Senior Data Engineer and Project Manager. He thrives on continuous learning, recently adding AI and Machine Learning certifications to his arsenal. With extensive managerial experience leading a team of 4 data engineers and handling a project with 30 team members, Guillermo's expertise shines in AWS and DBT, underlining his deep understanding of data engineering principles and effective communication skills.

Main technologies
Apache Airflow
2 years
Redshift
2 years
AWS
2 years
Python
3 years
SQL
8 years
Additional skills
Docker
Data Modeling
Business intelligence
AI
Machine learning
Snowflake
ETL
Git
PostgreSQL
Apache Hadoop
Apache Spark
Microsoft SQL Server
Microsoft Azure
Microsoft Power BI
Databricks
Ready to start
ASAP
Direct hire
Potentially possible

Experience Highlights

Data Engineer, Analytics Engineer
Jul 2023 - Ongoing10 months
Project Overview

It's a DBT implementation for the recruitment automation platform.

Skeleton
Skeleton
Skeleton
Responsibilities:
  • Integrated DBT into the existing Redshift Data Warehouse, streamlining data transformation processes and enhancing data quality;
  • Translated complex transformation SQL queries into modular and maintainable DBT workflows;
  • Developed comprehensive quality assurance procedures and built custom tests for DBT pipelines;
  • Created documentation for DBT workflows, including data models, transformations, and scheduling, facilitating smooth onboarding and ongoing maintenance;
  • Delivered a proof of concept (POC) for the first DBT model;
  • Led training sessions for the team on DBT best practices.
Project Tech stack:
Redshift
Apache Airflow
Python
Senior Data Engineer
Jun 2022 - Nov 20231 year 5 months
Project Overview

It's a Data Warehouse implementation for the recruitment automation platform.

Skeleton
Skeleton
Skeleton
Responsibilities:
  • Evaluated Data Warehouse technologies such as Redshift and Snowflake, including creating proof of concepts (POCs) and ultimately selecting Redshift as the preferred solution;
  • Built the Data Warehouse from scratch in AWS, managing all infrastructure aspects;
  • Integrated Airflow Directed Acyclic Graphs (DAGs) to work seamlessly with Redshift alongside existing systems on Postgres;
  • Translated over 300 tables and transformations from Postgres to Redshift dialect;
  • Conducted quality assurance for the entire migration, including custom functions;
  • Monitored and troubleshoot ETL processes;
  • Provided support for Metabase, creating new queries and optimizing existing ones.
Project Tech stack:
Redshift
AWS
Apache Airflow
PostgreSQL
Python
Docker
Data Scientist, Data Engineer
Jan 2019 - May 20223 years 3 months
Project Overview

The project is focused on Data Lake creation for the largest privately owned oil company in Argentina.

Skeleton
Skeleton
Skeleton
Responsibilities:
  • Led Data Lake implementation strategy;
  • Selected vendor and managed a team of 4 data scientists/engineers;
  • Defined Data Model for DL (8 databases, 100's of tables);
  • Built ETL model to migrate fleet data, reducing freeze time from 1 month to a few hours;
  • Standardized ETL process to ingest promotion data on Dynamics Mkt;
  • Supervised implementation of 2 fraud detection models.
Project Tech stack:
Databricks
SQL
Project Manager
Dec 2013 - Dec 20152 years
Project Overview

It's a tailored Microsoft Dynamics CRM system for a major oil company's commercial sector, previously without a CRM solution.

Skeleton
Skeleton
Skeleton
Responsibilities:
  • Managed a $4M project budget;
  • Led a 30-member team, including direct reports, business reps, and vendor staff;
  • Conducted a discovery phase to define the project scope;
  • Handled hardware provisioning, including importing servers from another country.
  • Handled business interactions with Microsoft, guaranteeing seamless cooperation;
  • Recruited and managed a specialized technical team, crucial for project success.
Project Tech stack:
Microsoft Azure
Business Intelligence Lead
Sep 2012 - Nov 20131 year 2 months
Project Overview

The project is focused on a Data Warehouse establishment, which is crucial for retail operations and strategic decision-making for a major oil company.

Skeleton
Skeleton
Skeleton
Responsibilities:
  • Set up the Data Warehouse from scratch using MS SSAS and SSIS technologies;
  • Replaced the discontinued SAP data warehouse, ensuring seamless continuity of data operations;
  • Established and led a BI team, fostering collaboration and expertise in data analytics and management;
  • Completed the project within a tight timeframe of less than 6 months, meeting aggressive deadlines.
Project Tech stack:
Microsoft SQL Server

Education

2010
Data Mining
Post graduate

Copyright © 2024 lemon.io. All rights reserved.