Lead BI & Analytics Engineering Consultant

I make complex data useful.

I design modern analytics platforms and BI products that turn enterprise-scale data into clear, trusted decisions.

Explore experience Selected work

Based near Frankfurt · Germany

8+years shaping
enterprise analytics

3B+records handled in
large-scale BI models

400+manager-level users
served by one solution

5languages spoken
across global teams

Experience

Work across complex enterprises.

Choose a company to expand the roles, technologies, and detailed contributions behind the work.

Building a Microsoft Fabric Lakehouse platform and migrating complex Tableau estates to high-performance Power BI.

Deutsche BahnLead MS Fabric and Power BI ConsultantSep 2025 — presentClient engagement

Microsoft FabricPower BITableauSQLPython

Migrating complex Tableau dashboards to Power BI, modernizing visual design and improving report performance.
Redesigning Tableau data models as optimized Power BI semantic models following VertiPaq best practices.
Architecting and implementing Lakehouse solutions in Microsoft Fabric using Medallion Architecture and metadata-driven ingestion pipelines.
Building and orchestrating Microsoft Fabric Data Pipelines and PySpark notebooks for large-scale analytics workloads.
Designing and delivering Power BI reports applying modern UI/UX and data storytelling principles.
Working within an Agile SAFe framework across multiple product teams.

Leading trusted Tableau delivery and analytics engineering for 400+ manager-level stakeholders.

Deutsche LeasingLead Analytics Engineering and Tableau ConsultantJun 2025 — May 2026Client engagement

TableauSQLPythondbt

Acted as technical lead for team members, guiding best practices in data modelling, testing, and dashboard design aligned with industry standards.
Partnered closely with stakeholders and business analysts to translate requirements into scalable analytical solutions.
Designed and delivered Tableau dashboards distributed to 400+ manager-level stakeholders across the organization.
Designed custom SQL data models to optimize Tableau dashboard performance within the constraints of the backend data architecture.
Prototyped improved data architecture on top of a Data Vault 2.0 warehouse to support long-term scalability.
Implemented dbt workflows for data quality testing and systematic debugging of data pipeline issues.

Planning and architecting an end-to-end Tableau-to-Power BI migration, from ETL to semantic models.

Cocomore / SamsungLead Power BI Migration ConsultantApr 2025 — Sep 2025Client engagement

Power BITableaudbtSQLPython

Planned and architected the end-to-end migration of complex ETL processes, data models, and dashboards from Tableau to Power BI.
Led knowledge-transfer sessions on Power BI data architecture best practices for project team members.
Introduced dbt to replace a heavy Tableau Prep-based ETL pipeline, significantly improving maintainability and scalability.
Redesigned data models for reusability and performance at scale, adopting star schema and optimized DAX patterns.

Standardizing the Power BI estate and re-architecting models so one semantic model serves many reports.

WIRTGEN GROUPLead Power BI ConsultantOct 2024 — Oct 2025Client engagement

Power BIPython

Standardized report templates and enforced design best practices across the Power BI environment, improving consistency and user experience.
Delivered end-user training programs for Power BI ranging from beginner to advanced level.
Developed Python scripts to automate data-refresh workflows, reducing manual intervention.
Redesigned data models for scalability, enabling a single semantic model to serve multiple reports.
Resolved complex DAX calculation issues and introduced modern DAX patterns—including variables, iterator functions, and optimized CALCULATE usage—to improve performance and maintainability.
Implemented cross-report filter-sharing strategies to improve navigation and analytical continuity.

Migrating reporting from Power BI to Tableau and rebuilding dashboards around UX and performance.

INNIO GroupLead Tableau ConsultantJan 2023 — Dec 2024Client engagement

TableauPower BISQLPython

Led the migration of Power BI reports to Tableau, ensuring feature parity and improved performance.
Built advanced Tableau dashboards applying UX best practices and data storytelling principles.
Designed custom SQL data models to optimize extract performance and overcome data-source limitations.
Refactored and modernized legacy reports, improving visual clarity and analytical depth.
Collaborated with stakeholders to identify business requirements and deliver tailored analytical solutions.

Optimizing Power BI and Tableau models over 3B+ records, with CI/CD and automated report testing.

Deutsche BahnLead Power BI and Tableau ConsultantOct 2022 — Dec 2024Client engagement · Frankfurt, Germany

TableauPower BISQLPython

Optimized Power BI and Tableau data models for Big Data workloads processing 3B+ records, including DirectQuery connections to Amazon Redshift.
Developed complex geospatial map visualizations in both Power BI and Tableau for operational analytics.
Led the migration of Tableau reports to Power BI while maintaining analytical integrity across platforms.
Mentored team members on Power BI and Tableau best practices, accelerating team capability.
Implemented CI/CD workflows for Power BI and Tableau using GitHub, enabling collaborative development.
Developed Python scripts for Tableau Hyper extract generation and data-pipeline automation.
Built automated test suites for BI reports using Playwright, improving release confidence.
Operated within an Agile SAFe framework across multiple product teams.

Optimizing and embedding Tableau analytics over 100M+ records inside an internal data platform.

Mercedes-Benz Tech InnovationSenior Business Intelligence DeveloperOct 2021 — Nov 2022In-house role · Stuttgart, Germany

TableauDatabricksSQLPython

Optimized Tableau dashboards for large-scale data sources with 100M+ records, significantly reducing load times.
Developed embedded Tableau reports integrated into a custom internal data platform.
Built custom Tableau data extracts using Python and the Hyper API for improved extract performance.
Maintained a CI/CD workflow in GitHub for BI report versioning and deployment.
Integrated Tableau with Databricks as a data source for scalable, cloud-based analytics.
Worked in an Agile team alongside backend developers and data scientists to deliver analytics features.

Delivering governed, GDPR-compliant BI dashboards end to end, from ETL to row-level security.

Deutsche BankSenior Business Intelligence DeveloperMay 2019 — Oct 2021Consultant, then in-house role

TableauSQLPython

Delivered end-to-end BI dashboard development in close collaboration with subject-matter experts and stakeholders to gather requirements and validate outputs.
Built ETL processes using Pentaho and Power Query to integrate multiple data sources in support of BI reporting.
Designed Row-Level Security data models to enforce data governance and comply with GDPR regulations.
Developed ad-hoc analytical reports to support day-to-day business decision-making.
Operated within an Agile development team, contributing to sprint planning and delivery cycles.

Building financial-controlling dashboards and forecasting analytics for senior-management decisions.

Roche DiagnosticsData Analyst in Project ControlsFeb 2018 — Jan 2019Internship · Penzberg, Germany

TableauExcelPower QueryVBA

Developed Tableau dashboards providing cash-flow analysis, forecast trends, and portfolio KPIs for senior-management decision-making.
Built a Power Query ETL process to consolidate multiple data sources in support of BI reporting.
Supported monthly cost reporting in Excel across individual projects and portfolios.
Assisted project-risk analysis using Monte Carlo simulations in Excel to estimate contingency budgets.
Worked with SAP to support bookkeeping and resolve contractor workflow issues.

Selected work

Built for real-world complexity.

Representative engagements across mobility, finance, manufacturing, and consumer technology.

Deutsche Bahn

A modern analytics platform for operational intelligence

Architecting Microsoft Fabric Lakehouses and metadata-driven ingestion while migrating complex Tableau experiences to high-performance Power BI semantic models.

Microsoft FabricPower BIPySparkTableau

Impact signalMedallion architecture

Deutsche Leasing

Trusted analytics for hundreds of decision-makers

Leading the technical delivery of scalable Tableau products, custom SQL models, and dbt quality workflows for an enterprise-wide management audience.

TableauSQLdbtAnalytics engineering

Impact signal400+ stakeholders

Cocomore / Samsung

Rebuilding a BI stack, not just moving dashboards

Planning the end-to-end move from Tableau to Power BI, replacing a heavy Tableau Prep pipeline with dbt and redesigning models around star-schema and optimized DAX patterns.

Power BIdbtDAXData modelling

Impact signalEnd-to-end migration

Deutsche Bahn

BI engineering at genuinely large scale

Optimizing Tableau and Power BI models over billions of records, adding CI/CD, automated report tests, geospatial analytics, and Python-powered extract pipelines.

3B+ recordsCI/CDPythonRedshift

Impact signal3B+ records

Currently building

Tools built from the problems worth solving once.

Side projects that came out of consulting work, built to remove the manual step the next time it appears.

Metadata-driven Medallion for Fabric

A config-over-code ingestion framework. Metadata control tables drive the Bronze, Silver, and bridge layers feeding a Direct Lake semantic model, so onboarding a table means inserting metadata rows rather than writing code. Reconciliation fails loudly on mismatch, and the whole framework installs from the browser.

Microsoft FabricPySparkPythonMedallion

Deployed and runningPrivate repository

Fabric semantic-model toolkit

Notebook drivers for the model operations that otherwise get clicked through a UI: incremental-refresh lifecycle, read-only diagnostics down to per-column VertiPaq footprint, TOM metadata surgery, and cross-workspace model cloning with report rebinding.

Microsoft FabricTOMXMLAPython

In use · v0.6.0Private repository

Power BI design ecosystem

Three reusable layers so Power BI design stops re-solving the same problems on every project: a brand-aware theme system, a typed registry of report components, and a builder that assembles reports from a spec under a theme.

Power BIPBIRThemingPython

Theme layer built · components and builder in progressPrivate repository

What I bring

From raw data to confident action.

I work across the full analytics journey—with particular depth where engineering, BI design, and adoption meet.

BI products

Power BI and Tableau experiences built around the decisions people actually need to make.

Power BI · Tableau · DAX · UX

Analytics engineering

Reusable semantic models, tested transformations, and pipelines that stay understandable as they scale.

SQL · Python · dbt · PySpark

Modern data platforms

Pragmatic architectures spanning ingestion, Lakehouse layers, modelling, and governed consumption.

Fabric · Azure · Databricks · AWS

Technical leadership

A collaborative lead for migrations, standards, mentoring, stakeholder alignment, and team enablement.

Strategy · Training · CI/CD · SAFe

The best analytics product isn't the busiest dashboard. It's the one people trust enough to act on.

I combine hands-on engineering with a consultant's eye for the wider system: the business question, the data model, the interface, and the people who will own it next.

Frame the decision

Start with the business question, the audience, and what a better decision should look like.

Engineer the foundation

Build the models, pipelines, and delivery practices that make trustworthy analytics repeatable.

Leave the team stronger

Share patterns, coach collaborators, and make the finished system easier to own and improve.

Available for selected hybrid and remote projects

Have a complex BI challenge?

Let's turn it into a clear next step.

Start a conversation

rafael.figueiredo@datanative.solutions LinkedIn GitHub

Aschaffenburg · Frankfurt areaEnglish · German · Portuguese