Allan Machado
Allan Machado

Data & BI Engineer

Actively looking · Member since 13 Jun 2026
Message
Location
Brazil
Desired salary
from 35 USD/hourly
Work preference
Full Time, Contract, Part Time
Experience level
Not set

About

Professional summary

I am a Data Engineer with over 5 years of experience building scalable data pipelines and automations that transform raw data into strategic insights. My expertise lies in data modeling, ETL/ELT development, and modern data architectures such as Data Lakehouse and Medallion. I combine strong technical skills with business acumen to design data solutions that align with organizational goals.

I hold a postgraduate specialization in Data Engineering and am currently pursuing a second postgraduate degree in Software Engineering. Throughout my career, I have worked extensively with cloud platforms like GCP, AWS, and Azure, and have experience managing data workflows and pipelines using tools such as MageAI, Airflow, and Dagster.

My professional experience includes designing Medallion architectures with SCD Type 2 versioning in Snowflake, automating data ingestion and transformation processes, implementing data quality frameworks, and ensuring compliance with data protection regulations such as LGPD. I have also developed dashboards and reports using Power BI and Google Data Studio to support operational and strategic decision-making.

I am proficient in multiple programming languages and tools including Python, SQL, PySpark, Power Automate, and Excel VBA. Additionally, I have experience working with various databases such as PostgreSQL, ClickHouse, BigQuery, and SQL Server. I am passionate about leveraging data to drive business value and continuously improving data infrastructure and processes.

I am eager to contribute my skills and knowledge to innovative data projects and collaborate with teams to deliver impactful data solutions. I am committed to staying current with emerging technologies and best practices in data engineering and analytics.

Skills

15 capabilities

Experience

Career history

Data & BI Engineer AFM DATA & AI

Designed Medallion architecture with SCD Type 2 versioning in Snowflake. Automated data ingestion processes and optimized pipeline performance. Implemented data quality frameworks and validation routines. Orchestrated data workflows using MageAI (Airflow/Dagster equivalent). Provisioned and managed cloud instances on GCP and AWS. Ensured data compliance with LGPD principles. Extracted and modeled data from Google Ad Manager, Google Ads, Pipedrive, and legal sources (Escavador/Comunica). Implemented CI/CD pipelines in GitHub/Bitbucket (dev/staging/prod). Worked with PostgreSQL (OLTP), ClickHouse, and BigQuery (OLAP).

Data Engineer / Analytics Engineer FGV – Fundação Getulio Vargas

Set up a secure cloud VM with Ollama & OpenWebUI for LLM-powered analytical usage. Designed and implemented a Lakehouse (Medallion: RAW/BRONZE/SILVER/GOLD) on SQL Server 2019 via ELT using Python and SQL. Automated ETL processes: cleansing, ingestion, and transformation (PowerQuery, Python, Power Automate, Excel). Built and maintained Power BI reports and dashboards. Created SharePoint Wiki pages and optimized internal knowledge management.

Analytics & Data Quality Engineer Neotrust

Performed ad hoc data integrity report reviews. Tracked and reported key operational indicators. Developed Power BI and Google Data Studio dashboards. Worked with REST APIs, JSON, and SQL (SSMS / SQL Server).

Business Intelligence Analyst Zee.Now

Developed Power BI and Google Data Studio dashboards. Automated workflows using Excel Macro/VBA and Power Automate. Worked with REST APIs, JSON, and SQL (PostgreSQL / DBeaver). Delivered time-event analyses to support operational decisions.

Global Operations Intern FARM Rio

Built Google Data Studio dashboards with core operational KPIs. Automated data processes integrating multiple sources. Managed ERP, WMS, and Shopify routine operations.

Performance Evaluation Intern Stone

Built dashboards to track project KPIs. Automated data processes from multiple sources. Prepared executive presentations for Business Partners and Leaders.

Logistics & Planning / Sales Intern oficialchefbob

Managed regional inventory planning and B2B/B2C logistics routes. Analyzed product demand fluctuations and led process optimization projects. Provided customer service, internal sales support, and new hire onboarding.

Education

Learning history

Descomplica Faculdade Digital

Postgraduate in Software Engineering

In Progress

Data Science Academy

Postgraduate in Data Engineering

Completed. Covered IaC with Terraform (AWS, Azure, Databricks), Data Warehouse Modeling & Governance, Data Engineering with Airbyte, DBT & SQL, Data Lake & Lakehouse, PySpark & Apache Kafka (Batch & Streaming)

UFRJ – Universidade Federal do Rio de Janeiro

Bachelor's in Food Engineering

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

Jobs Talent Salaries
Menu