Data · Python · Power BI

Marcus
Rocha

Senior BI Developer & Data Engineer

Specialist in turning data into strategic decisions. From pipeline to executive dashboard, with a focus on Python and Power BI.

MR
Marcus Rocha
Senior BI Developer & Data Engineer
📊
Fabric & Power BI
M · DAX · TMDL
🐍
Python
PySpark · Pandas · Polars
☁️
Azure Cloud
Data Factory · SQL DB
🏗️
Data Eng. & BI
DW · Data Lake · CI/CD
AZ-900 DP-900 PL-300 DP-600 → PCEP →
15+ Years exp.
3 Continents
Data processed
About me

Data is my language. Results are my product.

With 15+ years across financial services, healthcare and manufacturing, I build end-to-end data solutions — from Python pipelines to Fabric and Power BI executive dashboards that drive strategic business decisions.

Based in Portugal, working with clients across Europe, fluent in Portuguese, English and Spanish.

MS Fabric & Power BI

Advanced M queries and DAX, complex semantic models, RLS and deployment pipelines

Python

PySpark, Pandas, Polars, NumPy

Azure Cloud

Data Factory, SQL Database

Data Eng. & BI Developments

DW & Data Lake design, medallion architecture, SCD Types, CI/CD pipelines, ODBC connections

Career

15+ years of
real experience

A journey built in demanding enterprise environments — from Brazil to Europe.

Natixis in Portugal
Porto, Portugal
2023 — Present

End-to-end BI solution development in the financial sector — from large-scale data ingestion with Python and PySpark to executive dashboards in Fabric and Power BI. CI/CD pipeline management and deployments on Azure.

Power BI MS Fabric Python PySpark Azure SQL CI/CD
Banco GM S/A
São Paulo, Brazil
2020 — 2022

Development of executive dashboards for all business units and creation of KPIs that best reflect business performance and support decision-making. Data pipeline and Power BI report automation with Python and SQL — ~40% reduction in manual reporting effort.

Power BI Python SQL DAX M Query SAS
Hospital Israelita Albert Einstein
São Paulo, Brazil
2020

Processing and organising clinical and operational data. Power BI dashboards for real-time operational monitoring integrated with SQL databases.

Power BI Python SQL Azure
Brasil Brokers Participações S/A
Rio de Janeiro, Brazil
2015 — 2019

Full-stack data solution development — ETL pipelines, BI reports and interactive dashboards. Data-driven recommendations with direct impact on commercial strategy.

Power BI Python SQL ETL
Education & Certifications

Academic Background

🎓
MBA in Business Analytics & Big Data
Fundação Getúlio Vargas — FGV
2019
🎓
MBA in Financial Management, Controllership & Audit
Fundação Getúlio Vargas — FGV
2011
🎓
Bachelor's in Financial Management
Faculdade Ideal — FACI
2010

Certifications

AZ-900
Azure Fundamentals
Microsoft
DP-900
Azure Data Fundamentals
Microsoft
PL-300
Power BI Data Analyst Associate
Microsoft
DP-600
Fabric Analytics Engineer Associate
Microsoft · In progress
PCEP
Python Certified Entry-Level Programmer
Python Institute · In progress
Services

What I can do
for you

End-to-end data solutions — from architecture to dashboard.

📊

MS Fabric & Power BI

Advanced M queries and optimised DAX, complex semantic models, RLS and deployment pipelines. From operational reports to executive dashboards.

M Query DAX TMDL RLS Fabric
🐍

Python

Robust ETL pipeline development, large-scale data processing and workflow automation with the most relevant Python ecosystem frameworks.

PySpark Pandas Polars NumPy
☁️

Azure Cloud

Data pipeline orchestration with Azure Data Factory and relational database management with Azure SQL Database, integrated with the Microsoft ecosystem.

Data Factory SQL Database
🏗️

Data Eng. & BI Developments

Data warehouse and data lake design, medallion architecture, dimensional modeling with SCD Types, CI/CD pipelines and ODBC connections for enterprise environments.

DW Design Data Lake SCD Types CI/CD ODBC
🔍

Audit & Optimisation

Review of existing Fabric and Power BI models, DAX and M query optimisation, bottleneck identification and performance improvement in production environments.

Performance DAX M Query SQL
🎓

Training & Mentoring

Training and mentoring in Fabric, Power BI and Python for all levels — from juniors to C-Level. Technical communication adapted to the audience, focused on practical results and real knowledge transfer.

Power BI Python Fabric Workshops
Portfolio

Work in action

Competencies demonstrated across real enterprise environments — applicable across sectors and business contexts.

Real-time pipeline optimisation

Restructuring of batch pipelines to streaming architecture, achieving approximately 95% improvement in report loading performance. Big Data techniques implemented and adopted as a reference standard across the team's remaining projects.

Power BI Streaming PySpark Hive

Golden source of data — BI consolidation

Consolidation of multiple reports into a single BI product, from ETL with business rules to RLS by lines of business. A single source of data across the entire organisation, with visibility controlled by business area.

SQL SAS ETL Power BI DAX RLS

Financial visibility through reverse engineering

Rebuild of revenue and cost flows by segment through reverse engineering of existing data cubes. Clear P&L visibility delivered across business dimensions.

SQL Hive Python Power BI

Data-driven processes and operations

End-to-end data solutions — process automation, predictive modelling, population analysis for marketing targeting, sales optimisation and development of internal management platforms.

SQL Python R C# Power BI
Contact

Shall we work together?

Have a data project, need support with Fabric, Power BI or Python, or just want to exchange ideas? Reach out — I always reply.

Or send a direct message