Capacity and load windows
Full loads filling a SKU (e.g. F16), queues backing up, shared workspaces suffering. I redesign incremental patterns, business keys, processing order and what it takes to reprocess without drama.
Analytics engineering · microsoft fabric
Microsoft certified
Analytics Engineer | Fabric, lakehouse and Big Data.
When pipelines get heavy, numbers disagree with operations or leadership stops trusting the report, I rework ingestion, modeling and consumption. The goal is simple: data stops being overhead and becomes something you can decide on, with SQL, PySpark, notebooks, OneLake, Power BI and automation when the bottleneck isn’t “just ETL”.
Where I usually show up
The kind of thing that lands at 6pm or when the CFO asks “why did this number move?”. If the scenario sounds familiar, the next step is usually a technical conversation with a sponsor in the loop.
Full loads filling a SKU (e.g. F16), queues backing up, shared workspaces suffering. I redesign incremental patterns, business keys, processing order and what it takes to reprocess without drama.
P&L, accounting, project cost, HR: wrong grain or duplicated rules. I align sources, definitions and the semantic layer so BI stops being “a chart with opinions”.
Moving off on-prem or Report Server without losing history or trust. Phased plan, workspaces, lineage and what becomes a new semantic model vs legacy.
Bronze without contracts, same entity in different shapes, consumption from the wrong layer. I tighten silver/gold, contracts and ownership: real Medallion, not just folders.
Heavy models, long refresh or executive views inconsistent with operations. I decide what lives in the lake vs the model and where Direct Lake actually earns its keep.
Processes living in email and spreadsheets, data born outside systems. Power Apps, Automate and lake landing zones when the bottleneck is human, not only transformation.
How I decide
Short notes from the kind of conversations I have with architects, business and operations, no “innovation” slide deck.
When the window or SKU can’t afford to reload everything every time, the design shifts: watermark, business key, idempotency where needed and reprocess testing.
Trade-off: more operational and test complexity in exchange for stable capacity.
Direct Lake when model latency and scale matter; import when DAX/transform flexibility still wins over refresh pain.
Trade-off: tighter coupling to the lake vs freedom inside the model.
Without metric owners, folder standards and promotion rules between layers, “gold” becomes a shared drive and BI becomes an endless debate.
Trade-off: a bit of process in exchange for one official number.
A report without committee, owner or cadence becomes wallpaper. I structure KPIs and views to support a meeting that already exists, or kill a meeting that only existed for lack of data.
Trade-off: less “creative layout” freedom, more adoption and use.
Bronze lands; silver standardizes and tests; gold answers the business question. Skip a layer and you pay later in reconciliation and BI rework.
Trade-off: longer path to the first pretty SELECT in exchange for fewer surprises later.
I translate technical constraints into impact (time, risk, cost) and pull the business into grain decisions early, so nobody “signs off” a BI artifact they don’t actually own.
Trade-off: tougher meetings up front in exchange for less rework at the end.
About
I work hands-on in the Microsoft analytics stack: lakehouse, layers, incremental loads, semantics, governance and consumption. I’ve been in the room for Fabric capacity pain, migrations off on-prem / Report Server, and models that only behaved once grain and layers were right.
What shows up in a meeting may be a report; what sustains a decision is data contracts, pipeline cost, metric definition and who runs it after the project “ends”. That’s why I document and standardize: analytics without operations becomes shelfware.
In hybrid teams I often sit between business, platform and IT: translate real constraints (window, SKU, policy) into a design that doesn’t depend on a hero engineer.
Cases
Each write-up is a closed narrative: context, what was breaking (capacity, trust, time), architecture choices, stack and impact. BI shows up when it supports a committee, P&L, ops or HR, not as a lonely screenshot.
Cases are being published. The full list is coming soon.
Solutions
Depends on the stage: sometimes pipeline triage, sometimes lakehouse design, sometimes executive BI with an official metric. The thread is closing the loop between engineering and decision, with something your team can run.
I turn business questions into reliable metrics, the right grain, and an analytical narrative that supports executive committees.
Deliverables
Incremental pipelines, source contracts, and minimum observability: Fabric, notebooks, or equivalent stack.
Deliverables
OneLake, domain-based lakehouse structure, PySpark notebooks, and BI publishing with lightweight, repeatable governance.
Deliverables
Dashboards tied to real decisions: visual hierarchy, agreed KPIs, and performance that supports daily use.
Deliverables
Path
From IT operations to analytics engineering: infrastructure, BI, projects and now Fabric/lakehouse with the business problem in the center.
São Paulo, Brasil
End-to-end analytics architecture on Microsoft Fabric, from ingestion and lakehouse design to executive consumption with BI and applied AI.
São Paulo, Brasil
Leading BI and analytics projects focused on metric standardization, architectural evolution, and predictable delivery.
São Paulo, Brasil
BI initiatives with project perspective, integrating business needs, analytical modeling, and delivery quality.
São Paulo, Brasil
Outsourcing engagement for Sao Paulo State Finance and Planning Department, focused on analytical reliability and public management support.
Mogi das Cruzes, São Paulo, Brasil
Corporate BI role connecting operational performance to business indicators for decision-making.
Mogi das Cruzes, São Paulo, Brasil
Transition from operational support to performance analysis, focused on KPI monitoring and process efficiency.
Mogi das Cruzes, São Paulo, Brasil
Work in infrastructure and technical support focused on operational continuity, foundation for later growth in data and analytics.
Mogi das Cruzes, São Paulo, Brasil
Beginning of my technology journey, with operational support and technical routines that built process discipline and quality.
Credentials
Certification doesn’t replace delivery, but it shows I play by platform rules. Highlight on what backs serious BI; the rest is grouped as Microsoft, data and methods.
Microsoft
Microsoft
2024
View credential
Power Platform
Microsoft
2025
View credential
Power Platform
Microsoft
2025
View credential
Power Platform
Microsoft
2025
View credential
Power Platform
Microsoft
2025
View credential
Governance & Methods
Scrum.org
2024
View credential
Governance & Methods
EXIN
2024
View credential
Data & Analytics
Databricks
2024
View credential
Data & Analytics
IBM
2024
Governance & Methods
Código da credencial GR671531620CD
2023
Stack
Stack organized by workstream.
Send one sentence on the problem (e.g. full loads killing capacity, CFO mistrust in the P&L, leaving Report Server). I’ll reply with what I’d do first and what I wouldn’t promise.