Data & BI Architect - Power BI & SAP Expert

Daniel Ariza Diaz

Barcelona, Catalonia, Spain *****.****.******@*****.*** +34-661-**-**-** linkedin.com/in/arizadiazdaniel Professional Summary

Data & BI Architect specializing in Power BI and enterprise analytics modernization, with 9+ years of experience leading digital transformation initiatives across multinational organizations. Recognized for delivering sophisticated Power BI solutions — semantic layer design, DAX mastery, automated data pipelines, and scalable report architectures — that replace legacy tools and accelerate decision-making at the executive and operational level. Extensive SAP expertise (BW/4HANA, Datasphere, SAP Analytics Cloud) acts as a strategic differentiator, enabling the design of robust data flows from SAP ERP systems directly into Power BI consumption layers. Fluent in English (C1), Spanish (native), and Catalan (native). Core Competencies

• Microsoft BI & Power Platform

• Power BI — Expert-level DAX, data modeling, RLS, row-level security, incremental refresh

• Power BI Service — Governance, deployment pipelines, dataflows Gen2, shared datasets

• Power BI Embedded & Power BI Report Server (PBIRS)

• Microsoft Fabric (Lakehouse, Direct Lake mode for Power BI)

• Azure Data Factory & Azure Synapse Analytics as Power BI data sources

• Real-time Reporting Architectures & Streaming Datasets

• SAP & Data Architecture

• SAP BW/4HANA (Advanced Modeling, DSO Design, InfoCube Architecture)

• SAP Datasphere & SAP HANA Cloud

• ODP Extractors Configuration & Advanced Process Chains Management

• Data Warehouse Optimization & Performance Tuning

• SAP Analytics Cloud (SAC) & SAP BusinessObjects

• Modern Data Platforms

• Microsoft Fabric (Data Engineering, Lakehouse Architecture)

• Medallion Architecture (Bronze/Silver/Gold Layers)

• Azure Data Factory & Data Lake Design

• Python for Data Transformation & Orchestration

• Apache Airflow, Apache Hop, dbt

• Data Integration & Transformation

• SAP ABAP (Function Modules, Data Extraction)

• SQL (Advanced - T-SQL, optimization, complex queries)

• ETL/ELT Pipeline Design & Automation

• Advanced Process Chain Orchestration

• Data Mesh Frameworks

• BI & Reporting

• Power BI (Data Modeling, DAX, Advanced Visualizations)

• Tableau, QlikView, Looker

• Dashboard Design & Storytelling

• Real-time Reporting Architectures

• SAP Functional Modules

• Finance & Controlling (FI-CO) - Data modeling for financial reporting

• Materials Management (MM) - Supply chain analytics

• Project Systems (PS) - Project controlling architectures

• Technical Leadership & Governance

• Cross-functional team coordination (Business, IT, Development)

• Data Governance Frameworks & Master Data Management (MDM)

• Data Quality Assurance & Compliance (GxP, GDPR, 21 CFR Part 11)

• Agile/Scrum Methodologies, PMO Functions

• Solution Architecture & Technical Decision-Making Professional Experience

Business Intelligence Director Service Next

Barcelona, Spain April 2025 – Present

• Leading enterprise data architecture strategy with emphasis on Microsoft Fabric integration and modern data platform adoption, architecting scalable data models leveraging Bronze/Silver/Gold Medallion layers in Fabric

• Implemented and optimized ETL/ELT pipelines processing 2M+ records daily using Python, dbt, Apache Airflow, and Apache Hop, reducing report generation time by 40% through workflow automation

• Overseeing design and deployment of advanced BI solutions connecting operational systems to modern cloud ecosystems, managing data analysis and visualization teams serving 500+ daily users

• Managed Docker containerization for Apache Airflow and Hop Web automation, implementing DAG generation automation and scheduling configuration

• Mentoring technical teams on data governance, data quality, and architectural best practices in modern data environments

• Key Technologies: Microsoft Fabric, Power BI, Python, dbt, Apache Airflow, Modern Data Architecture, Medallion Pattern, Docker

Custom Software Engineering Specialist / PMO Accenture Barcelona, Spain May 2024 – November 2024

• Designed and implemented Microsoft Fabric solutions for technology sector clients, focusing on data lakehouse architectures and cloud data integration

• Architected data pipelines integrating SAP BW/4HANA systems with modern cloud platforms, demonstrating bridge expertise between legacy and modern ecosystems

• Applied Medallion architecture methodology (Bronze/Silver/Gold) for optimal data processing and consumption patterns

• Coordinated international teams across US, Poland, and Germany applying Agile/Scrum methodologies to deliver cross-functional data projects

• Developed scalable, maintainable data pipelines using SAP BW, Python, dbt, Apache Airflow, and SAP DataServices, implementing data mesh frameworks enabling self-service analytics and reducing data delivery time by 35%

• Implemented Python-based transformation scripts for complex data processing workflows and automated validation processes

• Key Technologies: Microsoft Fabric, SAP BW/4HANA, Python, Power BI, Lakehouse Architecture, Medallion Pattern, Data Mesh

BI Manager / PMO Grupo Profármaco

Barcelona, Spain January 2024 – May 2024

• Designed advanced SAP BW/4HANA data models for supply chain and financial analytics, implementing DSO and InfoCube architectures for enterprise-scale reporting

• Configured ODP extractors for real-time and batch data extraction from SAP ERP systems, managing complex Process Chains for automated data loading, transformation, and aggregation

• Implemented SAP Datasphere for unified data governance and semantic layer management, establishing master data frameworks

• Led modernization initiative exploring Microsoft Fabric integration for next-generation data architecture, piloting Medallion layer design

• Implemented data transformation workflows ensuring regulatory compliance (GxP, GDPR, 21 CFR Part 11), improving data quality by 30% through MDM principles

• Delivered Power BI dashboards for executive reporting and operational KPIs, serving pharmaceutical supply chain stakeholders

• Optimized data warehouse performance through advanced modeling techniques and partitioning strategies

• Key Technologies: SAP BW/4HANA, SAP Datasphere, ODP, Process Chains, Power BI, SAP HANA Cloud, Microsoft Fabric (pilot), MDM

BI Manager / PMO Nikel

Barcelona, Spain September 2022 – December 2023

• Spearheaded digital transformation initiative to modernize legacy BI architecture

• Designed and implemented Microsoft Fabric-based data lakehouse for consolidated analytics across logistics operations

• Developed Python scripts for advanced data quality checks and automated transformations, automating previously manual processes

• Led deployment of Power BI dashboards replacing legacy reporting tools, managing team of analysts through architectural evolution

• Managed PMO functions including data analysis, reporting model generation, and BI architecture design for logistics sector serving 200+ users

• Implemented predictive models for demand forecasting and inventory optimization, reducing stock-out incidents by 25% and increasing operational visibility by 45%

• Key Technologies: Microsoft Fabric, Python, Power BI, Medallion Architecture, Lakehouse Design, Informatica, SAP BI modules

BI Consultant Deloitte

Barcelona, Spain March 2022 – September 2022

• Consulted on SAP BW/4HANA implementations and data warehouse modernization strategies, guiding legacy system optimization

• Architected solutions integrating SAP Datasphere for semantic layer and data governance, establishing MDM frameworks for multinational clients

• Assessed and designed SAP HANA Cloud infrastructure for hybrid cloud data scenarios, evaluating modernization pathways

• Provided technical guidance on advanced SAP BW/4HANA modeling and process automation, conducting international workshops

• Conducted FI-CO and MM module analytics assessments for financial and supply chain optimization

• Key Technologies: SAP BW/4HANA, SAP Datasphere, SAP HANA Cloud, Data Strategy, MDM, DMBOK frameworks Business & Technology Integration Analyst Accenture Barcelona, Spain November 2016 – March 2021

• Developed comprehensive solutions using SAP BW/4HANA, SAP BPC, and SAP Analytics Cloud, improving reporting efficiency and user adoption across enterprise clients

• Led small teams in requirements gathering, client training, and solution delivery for large-scale BI projects including database unification across multiple countries

• Participated in international projects integrating business-driven technology solutions, supporting digital transformation initiatives

• Implemented data integration workflows using SAP Data Services, Informatica, and Power BI, streamlining data flows from source systems to analytics platforms

• Mentored and supported junior analysts to accelerate onboarding and improve team delivery performance by 20%

• Key Technologies: SAP BW/4HANA, BPC, SAP Analytics Cloud, SAP Data Services, Power BI, Informatica Key Achievements

• Successfully led modernization of legacy BI infrastructure to Microsoft Fabric Lakehouse Architecture, enabling 40% faster query performance and 25% cost reduction

• Designed and implemented advanced SAP BW/4HANA data models for multinational pharmaceutical company, supporting real-time analytics across supply chain operations with 15+ business process dashboards

• Architected end-to-end Python-based transformation pipelines in Microsoft Fabric, automating complex data processing workflows previously requiring manual intervention

• Successfully deployed data mesh architecture streamlining reporting and analytics across 5+ departments, enabling self-service data access

• Built robust data pipelines and dashboards adopted by international teams across US, Poland, and Germany, increasing operational visibility by 50%

• Improved data quality and regulatory compliance through automated MDM frameworks, reducing data discrepancies by 35%

• Promoted faster delivery cycles by improving communication and reducing bottlenecks between business and IT stakeholders

• Facilitated the adoption of new BI solutions and guided stakeholders through evolutionary enhancements and technology upgrades

Technical Proficiency

SAP Platforms: SAP BW/4HANA, SAP Datasphere, SAP HANA Cloud, SAP Analytics Cloud, SAP BusinessObjects, SAP BPC, SAP Data Services

Modern Data Platforms & Engineering: Microsoft Fabric (Lakehouse, Data Engineering), Azure Data Factory, Medallion Architecture, Apache Airflow, Apache Hop, dbt, Data Mesh Architecture Programming & Scripting: SAP ABAP, SQL (T-SQL, advanced optimization), Python, PowerShell, Bash, Git, CI/CD BI & Analytics Platforms: Power BI, Tableau, QlikView, Looker, SAP Analytics Cloud (SAC), SAP BusinessObjects Data Engineering & Governance: ETL/ELT Pipeline Design, Process Chains, ODP Extractors, Data Quality Frameworks, Master Data Management (MDM), DMBOK, DAMA, DCAM, Data Mesh, Real-Time Analytics Cloud & Infrastructure: AWS, Azure, GCP, Hybrid Cloud Architectures, Cloud Data Warehousing, Docker Project Management & Compliance: Agile/Scrum, Jira, Confluence, PMO methodologies, GxP, GDPR, 21 CFR Part 11 Education

BSc in Business Management and Administration EUNCET Business School Spain 2012 – 2016

Honors: Awarded Best Final Thesis on stochastic analysis of financial assets Certifications: English Level C1.1 (UB-EIM)

Languages

Spanish: Native Catalan: Native English: C1 (Professional Proficiency) Certifications & Additional Information

• UB-EIM English C1.1

• Familiar with DMBOK, DCAM, DAMA frameworks

• GxP, GDPR, 21 CFR Part 11 compliance knowledge

• Driver's license B

Contact this candidate