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.
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 executive dashboards that drive strategic business decisions.
Based in Portugal, working with clients across Europe, fluent in Portuguese and English.
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
15+ years of
real experience
A journey built in demanding enterprise environments — from Brazil to Europe.
End-to-end BI solution development in the financial sector — from large-scale data ingestion with Python and PySpark to executive dashboards in Power BI. CI/CD pipeline management and deployments on Azure.
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.
Processing and organising clinical and operational data. Power BI dashboards for real-time operational monitoring integrated with SQL databases.
Full-stack data solution development — ETL pipelines, BI reports and interactive dashboards. Data-driven recommendations with direct impact on commercial strategy.
Academic Background
What I can do
for you
End-to-end data solutions — from architecture to dashboard.
Power BI
Advanced M queries and optimised DAX, complex semantic models, RLS and deployment pipelines. From operational reports to executive dashboards.
Python
Robust ETL pipeline development, large-scale data processing and workflow automation with the most relevant Python ecosystem frameworks.
Azure Cloud
Data pipeline orchestration with Azure Data Factory and relational database management with Azure SQL Database, integrated with the Microsoft ecosystem.
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.
Audit & Optimisation
Review of existing Power BI models, DAX and M query optimisation, bottleneck identification and performance improvement in production environments.
Training & Mentoring
Training and mentoring in 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.
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.
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.
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.
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.
Shall we work together?
Have a data project, need support with Power BI or Python, or just want to exchange ideas? Reach out — I always reply.
Documents for download
Resources available for download.