PostgreSQL Data Warehouse
Kimball star schema on a self-hosted VPS, federated via postgres_fdw, ETL automated with n8n and Python, metrics surfaced in Power BI with DAX.
Data Analyst and Full-Stack Developer who builds end-to-end solutions across the stack. Python and SQL pipelines, Power BI dashboards, React web apps — and the infrastructure to run all of it.
Data Engineering & Analytics
I'm a Data Analyst and Full-Stack Developer with a multidisciplinary background spanning data engineering, software development, and design. I build the pipeline, the dashboard, and the application — without gaps or handoffs between specialists. Fluent in English and Portuguese, based in Fortaleza, Brazil.
End-to-end analytical work: exploratory data analysis in pandas, metric modeling in Power BI with substantial DAX development, and interactive analytics apps built in Streamlit. I handle the full journey from raw data to a clear, usable answer — including the pipeline that feeds it.
Front-to-back web applications built with React, Node.js, and Express, backed by PostgreSQL. Clean, responsive front ends from a Figma design background, combined with well-structured REST APIs and reliable server-side logic. UI/UX handled in the same pass as the code.
Kimball-style star-schema data warehouses in PostgreSQL, ETL pipelines orchestrated with n8n and Python, and self-hosted Docker infrastructure with Traefik, Redis, and VPS administration. I design, build, and keep running the infrastructure that makes the rest of it work.
Selected projects in data analysis, full-stack development, and automation infrastructure. Each one was designed, built, and deployed by one person — from the data model to the live URL.
Kimball star schema on a self-hosted VPS, federated via postgres_fdw, ETL automated with n8n and Python, metrics surfaced in Power BI with DAX.
Company website and Power BI dashboard suite for process monitoring and business reporting — designed, built, and maintained end to end.
Exploratory data analysis, Power BI dashboards with DAX modeling, and interactive analytics apps in Streamlit. I work with pandas, Altair, and Matplotlib to turn messy data into clear, actionable insight — and I speak to stakeholders in plain language, not jargon.
React front ends, Node.js and Express APIs, PostgreSQL databases. I've contributed to platforms serving 10M+ users (Portal Regularize / PGFN) and built internal tools for business reporting and process monitoring. UI/UX and front-end design come from the same background as the code.
ETL pipelines, dimensional data warehouses, and workflow automation with n8n and Python. Self-hosted production infrastructure on Docker Compose with Traefik, Redis, and PostgreSQL. I build it, deploy it, and keep it running — including debugging production incidents when they happen.
Tell me what data you have and what decisions you need to make from it — or describe what you want to build. I work in plain language, give clear timelines, and keep you in the loop from start to deployment.