Profile Picture

Guilherme Oliveira

Analytics Engineer | Data Analyst

Passionate data professional with 6+ years transforming business challenges into scalable data products that drive measurable outcomes. From data viz to robust data pipelines and AI projects, I bridge technical execution with strategic goals to deliver value in different industries.

#Python/Pyspark #SQL #Databricks #Airflow #Excel/PowerBI

Published Articles

Empowering local large dataset data analysis with duckDB

Case study on Brazilian companies demonstrating how DuckDB enables efficient analysis of large datasets locally, combining SQL performance with Python flexibility for comprehensive data visualization.

Read Article

Weather Analytics Made Simple with Airflow, PostgreSQL, and Metabase

Complete data pipeline solution using Apache Airflow for orchestration, PostgreSQL for storage, and Metabase for visualization, creating an automated weather analytics system.

Read Article

Starbucks Offer Acceptance Forecast Model With AWS

Machine learning project using AWS SageMaker to predict customer offer acceptance patterns, implementing end-to-end ML pipeline with data visualization and model deployment.

Read Article

Federal highways occurrences time series forecasting from Gov.br open data

Time series forecasting analysis using Brazilian government open data to predict highway occurrences, implementing machine learning models for traffic safety insights.

Read Article

Docker-driven Home Server Experience on Ubuntu with CasaOS

Complete guide to setting up a home server using Docker containers on Ubuntu with CasaOS, including database management and Airflow orchestration for personal data projects.

Read Article