Kai Pohl
Managing Director + Azure & Power BI Consultant
Microsoft Azure Synapse and Power BI Developer
innomotion media GmbH
- Supported the setup of the Microsoft Azure Synapse data warehouse (DWH) solution and Power BI reports for controlling and tax reporting at an international insurance broker
- Developed tables, views, and ETL structures in Azure Synapse
- Created various reports for controlling and tax reporting such as cost accounting sheet (BAB) and integrated income statement (IER)
- Microsoft Azure Synapse: Synapse SQL, Synapse Pipelines
- Microsoft Power BI: Semantic data model, reports
- Azure DevOps: Boards (backlog management), Repos (version control)
- DAX
- M
- SQL
Microsoft Fabric Consultant/Developer
innomotion media GmbH
- Advised and trained management on Microsoft Fabric after a migration project from TARGIT to Fabric
- Optimized and enhanced the Fabric architecture and sales reporting
- Trained staff on using and developing Fabric with a focus on Power BI
- Microsoft Fabric: Dataflow, Datamart, Data warehouse, Semantic model, Power BI
- DAX
- M
- SQL
Consultant, Developer
innomotion media GmbH
- Supported architecture, development, optimization, and operation of Azure subscriptions, Power BI tenant, and Databricks account
- Created and improved global reporting solutions using Microsoft technology
- Documentation and training
- Azure: Managed Instance, SQL Server (Database), Data Factory, Entra ID, App registrations, Functions, Databricks, Virtual Machines, Storage Account/blob storage, Key Vault
- Azure DevOps: Boards (backlog management), Repos (version control), Pipelines (CI/CD)
- Microsoft Fabric
- Power BI
- Power Automate
- Atlassian JIRA
- Atlassian Confluence
- Dynamics CRM
- Data Lake/Lakehouse
- IAAC: ARM, Terraform
- DAX
- M
- SQL
- PowerShell
- Python
- SCALA
Data Analyst, Power BI Developer
innomotion media GmbH
- Built a data quality framework in Fabric/Power BI and developed department and management reporting on top of it
- As part of a comprehensive data quality assessment, defined the desired data quality within a clearly defined topic. Department staff created a three-digit number of data quality rules for critical business attributes. The next step is to measure and show the differences between the target (TO-BE) and current (AS-IS) data quality.
- The visualization of these differences will be done using a Power BI dashboard. Before that can happen, the business rules must be translated into automated measurable rules.
- The project goal is to provide a solid and clear view of data quality and precisely highlight the differences between the TO-BE and AS-IS states.
- Microsoft Fabric/Power BI: Reports, semantic models, dataflows, templates
- Oracle
- DAX
- M/Power Query
- SQL
System Owner, Subproject Lead
innomotion media GmbH
Built and operated the Azure Data Platform as a central data enrichment and exchange platform for BI data
Ran ETL processes within project environments according to the cloud blueprint
Implemented a hub & spoke architecture for networking, access management, and governance via AAD groups and RBAC roles
Defined and deployed infrastructure with Terraform via Azure DevOps pipeline
Data Lake architecture with five main zones:
Ingestion Zone: data landing area, non-permanent storage, real-time and batch loading
Raw Zone (Bronze Layer): raw data in Delta format (structured, semi-structured), unstructured data in original format
Qualified Zone (Silver Layer): cleaned raw data, deduplication, schema enforcement, naming conventions
Curated Zone (Gold Layer): consumption layer optimized for analytics
Archive Zone: archiving inactive data
Worked in Scrum with agile sprints
Documentation in Markdown in the repo and in Confluence
Operational project management with Jira
Azure: Azure Databricks, Azure Data Factory, Azure Data Lake Storage Gen2, Azure Key Vault, Azure Virtual Network (vNet), Azure DevOps, ARM, Terraform
Python
SQL
JSON
HCL (HashiCorp Configuration Language)
System Analyst Power BI & Analytics, System Owner, Subproject Lead
innomotion media GmbH
- Architecture, application design, implementation, and operation of BI applications focusing on Microsoft Power BI and Azure services
- System owner for Microsoft Fabric tenant, Databricks account, global reports, Azure subscription, ETL tools
- Designed and introduced the global Power BI strategy and governance
- Led a subproject of the IT transformation
- Key user for Jira & Confluence; agile Scrum work
- Azure: Managed Instance, SQL Server (Database/Analysis Services), Data Factory, Synapse, Entra ID, App registrations, Functions, Databricks, Virtual Machines, Storage Account/blob storage, Key Vault
- Azure DevOps: Boards (backlog management), Repos (version control), Pipelines (CI/CD)
- Microsoft Fabric
- Power BI
- Power Automate
- Atlassian JIRA
- Atlassian Confluence
- Dynamics CRM
- Data Lake/Lakehouse
- IAAC: ARM, Terraform
- DAX
- M
- SQL
- PowerShell
- Python
- SCALA
I am a Business Intelligence Consultant with over 9 years of experience in the Microsoft BI stack and Managing Director of innomotion media GmbH. I have worked as a developer, consultant, and project manager on various projects, serving both mid-sized companies and large corporations.
Leuphana University Lüneburg
Master of Arts · Management & Controlling, Information Systems · Lüneburg, Germany
Leuphana University Lüneburg
Bachelor of Science · Business Informatics with Industrial Engineering · Lüneburg, Germany
Microsoft Certified: Data Analyst Associate
Strategic Applications of IT Project & Program Management
Similar Freelancers
Discover other experts with similar qualifications and experience
