BI Transformation (Fabric/Power BI) + AI Agent Solutions (Claude)
Cologne, Deutschland
Nur Remote
Master of Science (MSc) in Finance
Cologne, Deutschland
Nur Remote
Master of Science (MSc) in Finance
Profilanlagen
Niklas_Hoeppener_CV_Microsoft_Fabric.pdf
Über mich
I help companies replace Excel chaos with scalable BI: Microsoft Fabric, Power BI and SQL, governed semantic models and KPI frameworks. Strategy plus hands-on delivery — including the clean data foundation that makes AI reliable. Less manual reporting, faster decisions, real ROI.
Skills
AI AgentsData AnalysisAutomatisierungBusiness IntelligenceBig DataCloud ComputingData GovernanceETLData TransformationData WarehousingMachine LearningPredictive AnalyticsMicrosoft Power BIProzessautomatisierungSQLTransact-SqlSnowflakeMicrosoft Fabric (Analytics-Plattform)Databricks
Identifying and prioritising AI use cases that attach to the existing model — foundation first
Key Technologies
Microsoft Fabric, Power BI, DAX, Semantic Modeling, Direct Lake, OneLake, Dataflows Gen2, Data Factory, SQL/T-SQL, Spark, Databricks, SAP, Eventstream/KQL, Azure, Purview, Git/Azure DevOps
Took over a stalled Power BI implementation: audited existing reports, cleaned up inconsistent models and measures, and connected source systems that had never been integrated.
Built a coherent report catalogue with clear ownership and purpose per report, replacing an uncontrolled sprawl of one-off files.
Defined a binding KPI framework (definitions, time intelligence, variance logic) as the single source of truth.
Redesigned the entire budgeting process end-to-end, from data collection to plan-vs-actual reporting in the model.
Established operating procedures: refresh and release routines, naming conventions, documentation and handover.
Key Technologies: Power BI, DAX, Semantic Modeling, SQL, Dataflows, Data Governance
Microsoft Fabric Architect & Lead BI Consultant
Sonstiges
250-500 Mitarbeiter
Responsibilities & Impact:
Introduced Microsoft Fabric from scratch for a multi-division group (Corporate, Real Estate, Hospitality) and built a group-wide Performance Cockpit as the single source of truth for month-end close.
Designed the full architecture in a complex data landscape: medallion layering, Fabric Data Factory ingestion and a cross-tenant Databricks Mirrored Catalog into OneLake — no copies, Direct Lake framing in seconds.
Built three domain-focused semantic models (Finance, Operational, Executive) with group P&L to EBT, multi-scenario logic (actual / budget / forecast / prior year), ledger switch and row-level security.
Delivered one model for two front-ends: Power BI plus Excel via Analyze in Excel against the same model.
Established validation-first reporting: every cell reconciled to source before close and signed off by Finance.
Advised on the greenfield Fabric environment (workspace topology, identities, Key Vault, Purview) with .pbip under Git and approval-gated deployment.
Kept the platform on entry-level capacity through modelling discipline instead of a capacity upgrade, and built the foundation so AI extensions (Copilot Q&A, AI-assisted commentary) can attach without re-architecting.
Key Technologies: Microsoft Fabric, OneLake, Direct Lake, Databricks (Mirrored Catalog), Fabric Data Factory, Power BI Semantic Models, DAX, Calculation Groups, RLS, Azure DevOps, Purview
BI & Analytics Consultant — Fabric Platform
Konsumgüter und Handel
500-1000 Mitarbeiter
Responsibilities & Tasks:
Architectural stewardship of the Fabric platform
Established the governance rhythm: monthly semantic model review, quarterly KPI review, runbooks and monitoring.
Identified and prepared AI use cases on the existing semantic layer — demand forecasting, Copilot Q&A on the executive model, anomaly detection on the store-revenue stream — as extensions on clean data, not separate projects.
Prepared the executive model for Copilot (descriptive measure annotations, dimension synonyms, simple executive-level RLS).
Key Technologies: Microsoft Fabric, Power BI Semantic Models, Direct Lake, Copilot in Power BI, Fabric AI Functions, Activator
Microsoft Fabric Architect & Lead Consultant
Konsumgüter und Handel
500-1000 Mitarbeiter
Responsibilities & Impact:
Introduced Microsoft Fabric from scratch for a multi-brand retail group (~50 stores, three online shops, wholesale, ~200 BI consumers), replacing an eight-year-old SQL Server DWH and a nightly Excel chain.
Anchored Databricks as the processing engine (cross-tenant Mirrored Catalog into OneLake), with Power BI over Direct Lake — no copies, no nightly import.
Designed a four-layer medallion architecture with an explicit ownership split between group truth and consumer-ready views.
Built three domain-focused semantic models (Finance, Commercial, Executive) plus a later Marketing / Customer model.
Delivered Real-Time Intelligence for store revenue (POS via Eventstream into a KQL database), replacing a two-day reporting delay.
Built Customer Identity Resolution as its own data product, producing a persistent cross-channel customer master.
Introduced a channel-agnostic definition of revenue, margin and inventory — consolidation became a filter selection.
Ran .pbip under Git from day one, optimised the model before raising capacity, and handed over with runbooks and Analyze-in-Excel enablement.
Delivered as lead architect with a specialist delivery team.
Key Technologies: Microsoft Fabric, OneLake, Direct Lake, Databricks (Mirrored Catalog), Eventstream, KQL Database, Real-Time Intelligence, Power BI Semantic Models, DAX, SAP, Salesforce, Azure DevOps
Microsoft Fabric Consultant & BI Developer
Konsumgüter und Handel
50-250 Mitarbeiter
Responsibilities & Impact:
Replaced a manual Excel-based month-end process with a daily Finance cockpit on a Fabric foundation for an omnichannel e-commerce retailer.
Automated ingestion from all revenue and cost sources via Fabric Data Factory (shop, payment provider, marketplaces, ad platforms, ERP), with an Eventstream for near-real-time DTC orders.
Solved reconciliation (shop = payment = ERP) once in the Silver layer via a unified order key, instead of in every Excel file.
Anchored contribution-margin logic (CM1, CM2) in Gold and made margin per channel and per SKU a standard view.
Built the semantic model over Direct Lake and served Finance via Analyze in Excel.
Added data-quality rules with alerting so discrepancies surface immediately, not at month-end.
Reduced reporting turnaround by ~50%; the foundation is AI-ready for later forecasting and Copilot Q&A.
Key Technologies: Microsoft Fabric, OneLake, Direct Lake, Fabric Data Factory, Eventstream, Power BI, DAX, REST APIs, ERP Integration
Microsoft Fabric Architect & Data Platform Lead
Industrie und Maschinenbau
1000-5000 Mitarbeiter
Responsibilities & Impact:
Introduced Microsoft Fabric from scratch for a manufacturer with ~25 production sites, moving the group from site-level Excel to one group-wide reporting platform.
Designed the workspace topology (Bronze / Silver / Gold across DEV, TEST, PROD) and enforced site isolation via roles, not separate systems.
Integrated SAP, MES and OPC UA shopfloor data into a common site and asset model.
Built three domain-focused semantic models (Operations, Controlling, Executive) over Direct Lake.
Implemented a role-based security model (~60 roles) in OneLake Security, driven entirely by Entra security groups.
Set up enterprise-grade network and data protection (Private Link, managed private endpoints, customer-managed keys, Purview labels, dynamic data masking).
Established capacity governance and sized production from measured load, not assumption.
Result: one screen for the group-wide OEE comparison across all sites, month-end on the cockpit, and onboarding a new plant as a standard operation.
Delivered as lead architect with a specialist delivery team.
Key Technologies: Microsoft Fabric, OneLake, OneLake Security, Direct Lake, Spark, SAP, MES, OPC UA, Power BI Semantic Models, DAX, Azure Key Vault, Purview, Azure DevOps
Microsoft Fabric Consultant & Semantic Model Developer
Konsumgüter und Handel
50-250 Mitarbeiter
Responsibilities & Tasks:
Built a Fabric analytics foundation (Lakehouse to curated model to semantic model to Power BI) for a mid-size retail client.
Implemented a Finance & Sales KPI layer (time intelligence, variance, YTD / MTD) with consistent naming and documentation standards.
Created executive Power BI report templates (overview, AR / cash-flow, sales performance) optimised for performance and clear drill paths.
Key Technologies: Microsoft Fabric, Power BI, DAX, OneLake, SQL, Dataflows Gen2
BI Consultant & Data Platform Developer
Telekommunikation
250-500 Mitarbeiter
Responsibilities & Tasks:
Consolidated enterprise reporting from legacy SQL and Excel onto a governed data platform for finance and sales.
Designed data pipelines and a central reporting model across multiple source systems.
Developed reusable DAX patterns and Power BI templates for consistent, maintainable reporting.
Ran adoption workshops for the in-house BI team.
Key Technologies: Power BI, DAX, SQL, Azure Data Factory, Azure Synapse
BI Consultant — Various Reporting & Automation Engagements
Sonstiges
50-250 Mitarbeiter
Responsibilities & Tasks:
A series of smaller BI engagements alongside the main projects — Excel-to-Power BI financial reporting, HR performance reporting, production KPI dashboards and reporting automation.
Recurring pattern: governed Power BI models replacing manual Excel, ETL / Dataflows automation and consistent KPI logic.
SQL performance tuning for BI workloads (query optimisation, indexing).
Power BI enablement and training for finance, HR and operations teams.
Key Technologies: Power BI, DAX, SQL, Azure Synapse, Azure Data Factory, Dataflows
BI Consultant & Power BI Developer
Internet und Informationstechnologie
50-250 Mitarbeiter
Responsibilities & Tasks:
Built the client's first governed Power BI environment, replacing spreadsheet reporting that had grown up separately across finance, product and customer teams.
Designed a semantic model consolidating billing, CRM and product-usage data into consistent, reusable definitions.
Implemented a subscription and revenue KPI layer (recurring revenue, cohort retention, expansion and contraction) with standardised time intelligence.
Automated refresh and delivery through Dataflows and SQL-based transformations, removing recurring manual preparation.
Established workspace structure, naming conventions and role-based access, plus documentation and training for business users.
Key Technologies: Power BI, DAX, SQL, Dataflows, Azure Data Factory, Semantic Modeling
Cloud Data Engineer & BI Developer
Internet und Informationstechnologie
250-500 Mitarbeiter
Responsibilities & Tasks:
Migrated fragmented client data to a Snowflake cloud data warehouse as a central reporting environment.
Designed ETL pipelines to automate ingestion across multiple business units.
Built automated Power BI dashboards for customer usage and behaviour.
Enabled churn monitoring, contributing to a ~20% reduction in customer attrition.
Key Technologies: Snowflake, Databricks, Azure Data Factory, Power BI, SQL
BI Consultant & Power BI Developer
Transport und Logistik
50-250 Mitarbeiter
Responsibilities & Tasks:
Consolidated supply-chain data fragmented across multiple Excel files into a single reporting model.
Built interactive dashboards for shipment tracking and warehouse efficiency.
Enabled self-service analytics for end users and ran Power BI training.
Improved shipment tracking efficiency by ~45% and reduced manual reporting hours by ~30%.
Key Technologies:Power BI, DAX, SQL, Snowflake
Zertifikate
PL-300 — Microsoft Power BI Data Analyst Associate
Microsoft
2026
Portfolio
Kontaktanfrage
Einloggen & anfragen.
Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.
