10/22/2026 updated
100 % available
Senior Analytics & BI Engineer | Data Modeling & Semantic Architecture
Palma de Mallorca, Spain
Only remote
Energy Engineering studies, Universidad Politecnica de Madrid (UPM)About me
Senior Data & Business Intelligence professional with 9+ years of experience across energy markets, financial services, and enterprise analytics, specializing in BI engineering, dimensional data modeling, semantic architecture, and data-driven process optimization.
Business Intelligence DevelopmentData IntegrationMicrosoft Power BIReverse EngineeringMicrosoft Fabric
Power BI & Semantic Engineering
Expertise in Power BI Desktop, Service and Report Server, including DAX authoring, Power Query (M), DAX Studio, Tabular Editor, Bravo and RLS. Deep knowledge in re-architecting semantic models, reverse-engineering legacy reporting logic and progressing redesigned models within controlled on-premise and cloud environments.
Data Modeling & Dimensional Architecture
Proficiency in Kimball star schema design, fact and dimension granularity, conformed dimensions and keys, semantic model refactoring, KPI governance and lineage. Design of target-state semantic architectures with centrally governed KPI definitions and calendar strategies.
SQL & Data Engineering
Advanced SQL skills applied to ETL/ELT pipelines, data transformations, REST API integration, SAP R/3 and S/4HANA connectivity, and databases including SQL Server, PostgreSQL and Oracle. Experience with Python automation, AWS S3/Glue and Azure Data Factory for end-to-end data integration.
Microsoft Cloud & Azure Analytics
Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory, semantic models), Azure Data Factory, ADLS Gen2 and Azure SQL. Application of cloud-oriented data lake design patterns and analytics governance within enterprise environments.
Modern Data Stack
Developing skills in Databricks (notebooks, Spark, Delta Lake) and dbt (SQL models, tests, documentation) for ELT pipeline orchestration and scalable analytical workflows.
Automation & Delivery
Development of automated semantic-model audit workflows using MCP servers, Git/GitLab version control, VS Code and CI/CD concepts. Automation of recurrent reporting, data quality checks and Excel/VBA calculation engines with technical documentation.
BI Tools & Visualization
Additional experience with Tableau, Looker Studio, Qlik Sense and Amazon QuickSight for business intelligence reporting and dashboard delivery across energy, financial services and public-sector domains.
Pricing & Market Analytics
Engineering of pricing and margin analytics by integrating SQL, SAP/S4HANA, external market APIs and commercial sources. Development of SQL/VBA forecasting tools for electricity trading (OMIE), combining market prices, production forecasts and risk drivers.
SCADA & Operational Analytics
Preparation of SCADA and operational datasets with SQL, VBA and Power Query (M) for renewable asset monitoring. Design and maintenance of Power BI dashboards covering generation, availability, losses, downtime and deviations from expected production.
Expertise in Power BI Desktop, Service and Report Server, including DAX authoring, Power Query (M), DAX Studio, Tabular Editor, Bravo and RLS. Deep knowledge in re-architecting semantic models, reverse-engineering legacy reporting logic and progressing redesigned models within controlled on-premise and cloud environments.
Data Modeling & Dimensional Architecture
Proficiency in Kimball star schema design, fact and dimension granularity, conformed dimensions and keys, semantic model refactoring, KPI governance and lineage. Design of target-state semantic architectures with centrally governed KPI definitions and calendar strategies.
SQL & Data Engineering
Advanced SQL skills applied to ETL/ELT pipelines, data transformations, REST API integration, SAP R/3 and S/4HANA connectivity, and databases including SQL Server, PostgreSQL and Oracle. Experience with Python automation, AWS S3/Glue and Azure Data Factory for end-to-end data integration.
Microsoft Cloud & Azure Analytics
Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory, semantic models), Azure Data Factory, ADLS Gen2 and Azure SQL. Application of cloud-oriented data lake design patterns and analytics governance within enterprise environments.
Modern Data Stack
Developing skills in Databricks (notebooks, Spark, Delta Lake) and dbt (SQL models, tests, documentation) for ELT pipeline orchestration and scalable analytical workflows.
Automation & Delivery
Development of automated semantic-model audit workflows using MCP servers, Git/GitLab version control, VS Code and CI/CD concepts. Automation of recurrent reporting, data quality checks and Excel/VBA calculation engines with technical documentation.
BI Tools & Visualization
Additional experience with Tableau, Looker Studio, Qlik Sense and Amazon QuickSight for business intelligence reporting and dashboard delivery across energy, financial services and public-sector domains.
Pricing & Market Analytics
Engineering of pricing and margin analytics by integrating SQL, SAP/S4HANA, external market APIs and commercial sources. Development of SQL/VBA forecasting tools for electricity trading (OMIE), combining market prices, production forecasts and risk drivers.
SCADA & Operational Analytics
Preparation of SCADA and operational datasets with SQL, VBA and Power Query (M) for renewable asset monitoring. Design and maintenance of Power BI dashboards covering generation, availability, losses, downtime and deviations from expected production.
Languages
EnglishFluentSpanishNative speaker
Project history
Financial services engagement focused on ITSM Support Model, semantic architecture and reporting re-engineering. Led a technical audit of existing Power BI Report Server models assessing dimensional consistency, relationships, date logic, DAX measures and business KPI integrity. Designed a target-state semantic architecture based on Kimball modeling with redesigned facts, dimensions, conformed keys, calendar strategy and centrally governed KPI definitions. Reverse-engineered legacy reporting logic and validated functional requirements with business stakeholders. Progressing the redesigned semantic model within a controlled on-premise Citrix/Report Server environment using Power BI, SQL, DAX Studio, Tabular Editor, Bravo and Power Query (M).
Public-sector analytics project covering BI re-engineering, technical audit automation and cloud integration. Re-engineered BI and reporting assets, redesigning semantic-model structures, DAX logic, SQL transformations and KPI definitions toward reusable documented dimensional models. Developed automated semantic-model audit workflows using MCP servers. Worked with Power BI Service and Microsoft Fabric on analytics governance, workspaces, RLS and integration flows with Azure Data Factory and Data Lake design patterns. Produced technical design documentation covering data lineage, semantic-model architecture, KPI definitions and remediation recommendations under Git version control.
Pricing analytics for fuel, biofuels, commercial margins and market intelligence. Engineered pricing and margin analytics integrating SQL, SAP/S4HANA, external market APIs and commercial sources into validated reusable data transformations. Re-engineered complex legacy Excel/VBA calculation engines, automating controls and modernizing ETL workflows with Python, SQL and Microsoft Fabric. Designed Power BI reporting and semantic KPI layers covering price formation, margins, hedging exposure and commercial performance. Automated recurrent reporting and data quality checks with data-flow mapping, audit evidence and maintainable documentation.