Guilherme is available for hire

Guilherme Landim

Verified Expert in Engineering

Data Engineer and Developer

Location

Rio de Janeiro - State of Rio de Janeiro, Brazil

Toptal Member Since

September 27, 2022

Guilherme has over nine years of experience as a data engineer, data analyst, software developer, technical leader, and business intelligence consultant. He specializes in big data projects, Google Cloud Platform, AWS, data analysis, ETL/ELT, data pipelines, data lakes, data warehouses, KPIs, and report and dashboard development. Guilherme has extensive knowledge and practice working in the business area, understanding the company's needs and helping it with its demands.

SQL Data Modeling Big Data Data Engineering Data Warehousing Data Visualization Data Pipelines ETL Python C++Microsoft Power BI Java Amazon Web Services (AWS)Pentaho PySpark K2

Portfolio

TeamIt

SQL, Python 3, Fivetran, Apache Airflow, PySpark, Looker...

Rain

PySpark, SQL, Data Build Tool (dbt), Python 3, Amazon Web Services (AWS)...

Ubiminds

Python 3, PHP, SQL, Data Build Tool (dbt), Data Warehousing, ELT, ETL, Big Data...

Experience

SQL - 8 years Data Pipelines - 6 years Data Engineering - 6 years Python - 5 years Amazon Web Services (AWS) - 2 years PySpark - 2 years Google Cloud Platform (GCP) - 1 year Data Build Tool (dbt) - 1 year

Availability

Part-time

Preferred Environment

SQL, Python, Data Build Tool (dbt)

The most amazing...

...thing I've created is a reconciliation pipeline to understand if the whole company business is working as expected.

Work Experience

Senior Data Engineer

2022 - PRESENT

TeamIt

Developed and maintained data pipelines to ingest, clean, and transform data to a data warehouse.
Used Jira to manage, write what was done and other comments, and help track tasks.
Audited ingestion pipelines, cutting costs by more than 30%.
Developed models for the data warehouse to be used by data scientists, analysts, and business people.
Developed and maintained dashboards to help stakeholders get accurate information faster.

Technologies: SQL, Python 3, Fivetran, Apache Airflow, PySpark, Looker, Amazon Web Services (AWS), Git, Data Modeling

Senior Data Engineer

2022 - 2022

Rain

Developed and maintained data pipelines to ingest a large volume of data in a data lake.
Created models for the data warehouse with dimension and fact tables for stakeholders with self-service BI.
Developed and maintained data pipelines to ingest, clean, and transform data into a data warehouse.
Helped stakeholders get accurate information faster by developing and maintaining dashboards.
Developed and maintained a reconciliation pipeline flow and dash.

Technologies: PySpark, SQL, Data Build Tool (dbt), Python 3, Amazon Web Services (AWS), Microsoft Power BI, Data Visualization, Data Warehousing, ELT, ETL, Big Data, Data Modeling

Senior Data Engineer

2021 - 2022

Ubiminds

Created a model and the first publisher on the back-end side to stream data with pub/sub to a data lake.
Developed and maintained data pipelines in the Google Cloud Platform environment to ingest data in several reports and dashboards.
Created a data catalog model to help every stakeholder to understand our data.
Built a data lake and data warehouse to ingest all gathered data.

Technologies: Python 3, PHP, SQL, Data Build Tool (dbt), Data Warehousing, ELT, ETL, Big Data, Data Modeling

Instructor, Mentor, and Course Co-creator

2020 - 2021

Awari

Designed and taught a course on data analytics at Awari.
Mentored students via a weekly 30-minute call, helping them with several needs.
Taught data analytics in two classes, with several students landing their first jobs.

Technologies: Python 3, SQL, Microsoft Power BI, Data Visualization

Senior Data Engineer

2019 - 2021

Accenture Brasil

Developed and maintained data warehouses for companies in telecommunications and logistics.
Created and maintained data pipelines to ingest, clean, and treat data for these data warehouses.
Developed and maintained dashboards and reports to enable fast insights into operational areas.
Built and maintained bots to improve the workflow of call center representatives, improving some key metrics for the business and simplifying their tasks and activities.

Technologies: Python, SQL, PySpark, Google Cloud Platform (GCP), Microsoft Power BI, Data Warehousing, ELT, ETL, Data Visualization, Big Data, Data Modeling

Mentor and Reviewer

2019 - 2020

Udacity

Acted as a mentor to students of the Programming for Data Science nanodegree program.
Reviewed projects for several Udacity course modules.
Mentored students of the nanodegree program called Predictive Analytics for Business.

Technologies: Python, SQL

Tech Lead Data Engineer

2019 - 2019

Globo

Developed a Power Apps application to map and gather data from the filming of soap operas.
Created data pipelines to ingest, store, and transform data according to the company's needs.
Built a Power BI dashboard to give insights on where the products were in the production steps.

Technologies: Python, SQL, Microsoft Power Apps, Excel VBA, Data Visualization, Data Warehousing, ELT, ETL, Big Data, Data Modeling

Senior Data Engineer and Data Analyst

2015 - 2019

Accenture Brasil

Developed and maintained dashboards and reports to give stakeholders better data insights.
Created and maintained data pipelines for several clients with different needs.
Developed and maintained automation to increase productivity for a call center field force.
Built and maintained data warehouses to support several clients and their needs.

Technologies: Java, SQL, Python, Pentaho, PySpark, Tableau, Microsoft Power BI, Data Visualization, Data Warehousing, ELT, ETL, Big Data, Data Modeling

Junior Software Engineer

2013 - 2015

K2 Sistemas

Developed software models for data analysis, simulations, and profiling for oil wells.
Created software models for data visualization on several types of graphs.
Developed and reviewed the formulas used for oil extractions calculus inside the software.

Technologies: C++

Experience

Sell Here Fake Company

https://github.com/guilhermelfl/sell_here_data_engineering_fake_company

A data engineering project that creates a batch pipeline idea to help the data team workflow. In this project, data is generated, ingested, processed, and merged to deliver a clean and reliable source for data scientists and data analysts to work on.

Education

2008 - 2014

Bioprocess Engineering Degree in Chemical Engineering

Federal University of Rio de Janeiro - Rio de Janeiro, Brazil

Certifications

MAY 2022 - PRESENT

dbt Fundamentals

DBT

SEPTEMBER 2021 - PRESENT

Data Engineering, Big Data, and Machine Learning on GCP

Coursera

JUNE 2021 - PRESENT

Google Analytics Certification

Coursera

Skills

Libraries/APIs

PySpark

Tools

Microsoft Power BI, Tableau, Microsoft Power Apps, Apache Airflow, Looker, Git

Languages

SQL, Python, C++, Java, Excel VBA, PHP, Python 3

Platforms

Amazon Web Services (AWS), Pentaho, Google Cloud Platform (GCP), Docker

Paradigms

ETL

Storage

Data Pipelines

Other

Data Build Tool (dbt), Big Data, Data Engineering, ELT, Data Warehousing, Data Visualization, Data Modeling, Fivetran

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring