Data Engineer

JoãoBorges

Transforming data into actionable insights through scalable pipelines and high-performance analytics solutions.

Yes, this layout was designed during a nice chat with an AI.

DATA_STREAM: ACTIVE

STENCIL_V.1.0

ISO_400 // F.1.4

SOURCE: /ME.JPEG

João Borges

Scroll

About

Data engineer with experience in migrating data from legacy systems to modern data warehouses, such as Amazon Redshift. Experience in data modeling with DBT, data visualization on platforms such as Power BI and Metabase, and optimization of ELT pipelines. Ability to overcome business logic challenges and lead process transformation, ensuring the adaptation of teams to new tools and the delivery of value insights. Graduated in Database and Big Data.

1

Migration from legacy systems (DB2) to modern data warehouses (Amazon Redshift)

2

Data modeling and transformation with DBT using medallion architecture

3

Data visualization with Power BI, Metabase, and ClickView

4

ELT pipeline optimization and cost control in AWS

Tech Stack

Data Engineering

DBTApache AirflowDatabricksApache SparkELT Pipelines

Cloud Platforms

AWSAmazon RedshiftAmazon S3Amazon RDS

Languages

PythonSQLGo

Tools

Power BIMetabaseGrafanaGitDockerK8S

Experience

Data Engineer

Cognitivo AI

Nov 2025 - Present

Working on data engineering projects with focus on AI and machine learning pipelines.

Data Engineer

Escola DNC

Jan 2025 - Nov 2025

Development of new Go API for CRM data ingestion. Complete database restructuring. Led DBT architecture refactoring, organizing the project with medallion architecture to unify product versions and business rules.

Data Engineer

Grupo OSCAR

Aug 2024 - Jan 2025

Responsible for migrating data from a legacy database (DB2) to a Data Warehouse on Amazon Redshift. Used DBT and Power BI for data modeling, transformation, and visualization. Migrated multiple dashboards from ClickView to Metabase.

Junior Data Engineer

Quero Educação

May 2024 - Aug 2024

Promoted to Junior Data Engineer, taking on greater autonomy and responsibility in project execution and delivery. Development and maintenance of data pipelines with Apache Airflow and Databricks.

Data Engineer Intern

Quero Educação

May 2023 - May 2024

Development and maintenance of data pipelines with Apache Airflow and Databricks. Data analysis with Spark and Python. Building dashboards in Metabase and Power BI. Implementation of query monitoring with Grafana and AWS cost control.

Data Engineer Intern

3778

Jan 2022 - Oct 2022

Development of data pipelines and work with SQL, Amazon S3, and other data engineering tools.

Projects

01

DB2 to Redshift Migration

Complete data migration from legacy DB2 system to Amazon Redshift, including dimensional modeling and query optimization.

DBTAmazon RedshiftDB2SQLPython
02

DBT Medallion Architecture

Complete DBT architecture refactoring implementing medallion pattern (bronze, silver, gold) to unify business rules.

DBTSQLData ModelingMedallion Architecture
03

CRM Ingestion API

Development of Go API for CRM data ingestion, ensuring performance and scalability.

GoAPICRMData Ingestion
04

Metabase Dashboards

Migration of dashboards from ClickView to Metabase, improving accessibility and visualization performance.

MetabaseSQLBIData Visualization
05

Airflow + Databricks Pipelines

Development and maintenance of data pipelines with Apache Airflow and Databricks, including monitoring with Grafana.

Apache AirflowDatabricksSparkPythonGrafana
06

AWS Cost Control

Implementation of monitoring and cost control system for Databricks jobs on AWS.

AWSDatabricksCost OptimizationGrafana

Contact

I'm always open to discuss new projects, opportunities, or partnerships. Let's chat!