Experience
Freelance Consultant Business Intelligence (Self-employed)
mw-consult.it
Data Engineering
Business Analyst
Consulting
2025 – present
Data Engineer & Architect
- Azure Data Factory
- Azure Databricks (PySpark)
- PowerBI Service
Lead developer for the further development of the Modern Data Warehouse, as well as Power BI reports and data models based on the ERP systems Amparex and EyeOffice. Focus on topics for the marketing department with data connection via API to Amplitude and Klaviyo with Python
- 2024 – present
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL)
- SSAS Tabular
- PowerBI Report Server
- Atlassian Jira & migration to Azure DevOps with GIT (KANBAN)
Development of Power BI reports and data models based on Infor LN ERP data after migration from Baan, including the underlying data structures with Microsoft SQL Server for further development of the Data Warehouse
Consulting for controlling on the specification of business requirements and development of reporting solutions
- 2025 – 06.2025
Data Engineer & Architect
- PowerBI Dataflows
- PowerBI Service
Cloud migration of the Data Warehouse, as well as Power BI reports and data models from Microsoft Dynamics BC 2021 to Microsoft Dynamics BC Cloud, including migration of the underlying data structures from Microsoft SQL Server to Power BI Dataflows
- 2022 – 06.2024 (ongoing support for data engineers)
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- SSAS Tabular
- Azure DevOps with GIT (SCRUM)
Development of analytical models based on Microsoft Dynamics BC 2021 in combination with data from the company's own MariaDB database, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse. Merging of the ERP systems BC 2021 and DATEV in the Data Warehouse
Consulting for business users on the specification of business requirements and coaching of developers for the development of reporting solutions
- 2022 – 08.2023
Business Analyst & Interim Manager
- PowerBI Service
- Azure Databricks (PySpark)
- Atlassian Jira (SCRUM)
Project management for reporting solution requirements, as well as development of Power BI reports and data models with data from Azure Databricks based on SAP R/3, Google Analytics, webshop and CRM with a business focus on customer, sales and marketing
- 2022 – 05.2022
Power BI Specialist
- PowerBI Service
- Azure DevOps with GIT (SCRUM)
Development of Power BI reports and data models based on data from Exasol with a business focus on assortment management in purchasing
- 2021 – present (ongoing support for existing customers)
Power BI Specialist & Data Engineer
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- PowerBI Service
- Azure DevOps with GIT (KANBAN)
- Azure Functions (Python)
Development of Power BI reports and data models based on abas ERP data, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse.
Synchronization of customer data for Pipedrive CRM via Azure Functions with Python.
Consulting for controlling and management on agile project management, the specification of business requirements and development of reporting solutions
- 2021 – present (ongoing support for existing customers)
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- SSAS Tabular
- Azure DevOps with GIT (SCRUM)
Development of analytical models based on Microsoft Dynamics 365 FO, CS & CRM in combination with Microsoft Dynamics AX 2012 R3, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse
Concept for the migration of the SQL Server-based Data Warehouse to Microsoft Fabric with planned future implementation and temporary use of a hybrid data architecture for the introduction of Power BI Service during the migration phase
Consulting for business users on the specification of business requirements and development of reporting solutions
Senior Consultant Business Intelligence
adesso SE
- Development
- Consulting
- Coaching
Technologies: MS SQL Server, SSIS, BIML, SSAS Tabular, PowerBI, Excel, Azure DevOps
- 2020 – 04.2021
Development of a company-wide data platform and analytical models based on Microsoft Dynamics AX 2012 R3 for the sales and controlling departments, from the automated connection of source data to the provision of analytical models. Consulting for business users on the specification of business requirements and reporting solutions for implementation in Tableau and Excel in combination with analytical models. Coordination of internal developers in connection with task planning and distribution
- 2020 – 12.2020
Development of a custom automation in the area of relational databases and integration of source data
Consultant Business Intelligence
adesso SE
- Development
- Consulting
- Coaching
Technologies: MS SQL Server, SSIS, BIML, SSAS Tabular, PowerBI, Azure DevOps
- 2019 – 06.2020
Development of an analytical model and related reports for market analysis, including the setup of the underlying data structures and semi-automated development processes for the department. Coordination of the SCRUM developer team in connection with task planning and distribution. Coaching of the developer team for the implementation of solutions based on Microsoft BI technologies
- 2018 – 01.2019
Management and execution of the project to build development processes with Microsoft SQL Server 2016 and semi-automated development processes. Coaching of the customer's project staff. Review and optimization of SSIS packages
- 2018 – 01.2019
Project management and development of an automated data transfer from Oracle to Microsoft SQL Server 2016, taking into account a data protection catalog
- 2017 – 06.2017
Development of a database system to calculate reimbursements for medical aid contracts for health insurance companies
- 2017 – 05.2018
Development of an enterprise DWH according to Data Vault 2.0 in the SCRUM team
Application Developer BI / SAP
KNIPEX-Werk C. Gustav Putsch KG
- Building a new company reporting system
- Consulting and training the controlling department for reporting solutions
- Use and administration of the BI system
- Database development, modeling and integration
- Data extraction from SAP
- Development of multidimensional cubes
- Development of Excel applications
Technologies: Evidanza BI, MS SQL Server 2008 R2, SSIS, SSAS Multidimensional, Theobald Xtract IS, SAP R/3, Excel (VBA)
Projects:
- BI sales controlling
- Cost analysis
- Purchasing controlling
- Quality management
- Price development in online retail
- Excel / VBA optimization of business processes
- Reduction of stock levels
- Document creation and distribution
- Quote creation with product images
- Price calculation in online retail
Sales Clerk D-A-CH
KNIPEX-Werk C. Gustav Putsch KG
- Processing of quotes (SAP SD and Excel), order processing (SAP SD), customer support and working with sales representatives
- Creation and analysis of sales statistics
Skills: SAP SD, SER Doxis, MS Office
Further details:
- Support of online retail with focus on IT projects
- Project support for the introduction of the document management system (SER Doxis) and the electronic customer file as key user, as well as the development of changed business processes
- User training in the area of the electronic customer file for employees in sales and subsidiaries
- Sales reporting, especially for sales agencies and field sales
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Professional Services, Manufacturing, Healthcare, and Insurance.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Project Management, Operations, Quality Assurance, and Customer Service.
Frequently asked questions
Have questions? Find more information here.
Matthias is based in Ennepetal, Germany.
Matthias speaks the following languages: German (Advanced).
Matthias has at least 15 years of experience. During this time, Matthias has worked in at least 5 different roles and for 3 different companies. The average length of individual experience is 3 years and 11 months. Note that Matthias may not have shared all experience and actually has more experience.
Based on recent experience, Matthias would be well-suited for roles such as: Freelance Consultant Business Intelligence (Self-employed), Senior Consultant Business Intelligence, Consultant Business Intelligence.
Matthias's most recent position is Freelance Consultant Business Intelligence (Self-employed) at mw-consult.it.
In recent years, Matthias has worked for mw-consult.it.
Matthias is most experienced in industries like Information Technology, Professional Services, and Manufacturing. Matthias also has some experience in Healthcare and Insurance.
Matthias is most experienced in business areas like Business Intelligence, Information Technology, and Project Management. Matthias also has some experience in Operations, Quality Assurance, and Customer Service.
Matthias has recently worked in industries like Information Technology and Professional Services.
Matthias has recently worked in business areas like Business Intelligence, Information Technology, and Project Management.
Matthias attended KNIPEX-Werk C. Gustav Putsch KG for Industrial clerk.
Matthias has 2 certificates. These include: Microsoft Certified Solution Associate (MCSA) SQL Server and Professional Scrum Master (PSM I).
The availability of Matthias needs to be confirmed.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 18 Nov 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Marco S.
Last position:
MS Power BI Developer at Bayern Facility Management GmbH
- Co-development of a data and analytics platform with MS Fabric, Power BI, Power Automate and Foundry
- Development of Power BI reports and data models with DAX
- Data from Microsoft Dynamics 365 Business Central and from documents scanned and processed with Azure Content Understanding (Foundry)
Technologies: MS Fabric, MS Power Automate, Foundry, MS Power BI, DAX
Tobias H.
Last position:
SAP Technology Expert / SAP BO Basis Administrator at Talanx AG/ HDI Versicherung
- Incident Management
- User management: creating, maintaining, and deactivating users as well as maintaining roles
- Updates and upgrades: planning and executing updates and upgrades
- Operations: performance analysis, daily monitoring, and applying SNotes
- Job management: creating, maintaining, and monitoring jobs
- Training of employees
- Development and extension of reports
- Development and extension of universes
- Technologies: SAP BusinessObjects (SAP BO 4.3), Oracle SQL Developer, SAP Information Design Tool, Octane
- Methods: Scrum
Germo G.
Last position:
BI Developer at Rhenus Logistics
- Business intelligence development in the logistics sector.
- Migrating existing reporting and analysis solutions from Cognos to Microsoft BI.
- Using Microsoft SQL Server, SSAS, Power BI, and other Microsoft BI platform components.
Vitali H.
Last position:
Power BI Expert at Media Agency
The project aims to migrate the company's existing Power BI Premium environment to Microsoft Fabric. This migration includes moving the existing data models, reports, and dashboards to the new platform to take advantage of the extended features and improved performance of Microsoft Fabric. The solution will be deployed in various regions worldwide to ensure a unified and consistent reporting and analytics environment for all locations.
Requirements analysis, migration planning, data migration, adapting reports and dashboards, testing and validation, training and support, deployment and monitoring, regional rollout.
Christian P.
Last position:
Power BI Developer & Consultant in an Agile Team (SAFe) at DB InfraGO AG
Further Development of the Integrated Capacity Management Platform InKa
Rail Infrastructure
- Power BI shared datasets and reports via DirectQuery on Amazon Redshift (timetable, construction and capacity data)
- Automated report testing with Playwright in Docker containers, version control with GitLab
- Concept and implementation of user communication (information page, changelog, known bugs)
Initial Situation:
The integrated capacity management platform (InKa) is a monitoring and analysis platform for data from timetable and capacity management: customer orders, infrastructure, timetable operations, construction, as well as route capacity and width. The data is stored and linked in a structured data warehouse. This makes it possible to create complex KPIs across different source systems and display current and future route utilization as well as construction activity across the network. The goal is to improve strategic, medium-term and intra-year planning and provide users with easy access to capacity management analyses.
Measures:
- Enablement: Introduction of Power BI with training and workshops for development teams.
- Consulting & Design: Problem analysis, concepts and solution consulting for reporting requirements; implementation of reporting solution plans.
- Data Model: Development of shared datasets with DirectQuery on Amazon Redshift and import tables; DAX measures for utilization and capacity KPIs.
- Development: Data analysis, data transformation and visualization in Power BI; extension and migration of business applications to Power BI; AI-supported development in VS Code with GitHub Copilot.
- Test Automation: Automated testing of Power BI reports with Playwright; setup of the test environment in Docker containers.
- User Communication: Concept and implementation of a central information page with hot news, changelog and known bugs, access from reports with report filters, updates via Power Automate.
- Deployment: Management of Power BI Deployment Pipelines across the DEV, TEST and PROD environments.
- Agile Working: Work in an agile team according to SAFe (Scaled Agile Framework); refinement of user stories and features including effort estimates in Jira; version control with Git and GitLab.
- Quality & Documentation: Reviews for quality assurance, error analysis and resolution, technical documentation in AsciiDoc and Confluence.
Technologies: Power BI, DAX, Power Query, DirectQuery, Amazon Redshift, Git / GitLab, Deployment Pipelines, Playwright, Docker, AsciiDoc, Power Automate, Jira, Confluence, VS Code with GitHub Copilot, SAFe
Results:
- Capacity management KPIs from multiple source systems combined on one platform
- Transparency regarding current and future route utilization and construction activity across the network
- Easy access to analyses for users
- Automated regression testing of Power BI reports
- User communication implemented: central information page with hot news, changelog and known bugs, directly accessible from the reports
Henok A.
Last position:
Founder and Managing Director at Afworki GmbH IT-Consulting
The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.
Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.
Analyzing the company's current situation and developing the best possible solution together with the client.
Using both agile and classical IT project management methods to deliver projects on time and within budget.
Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.
Considering the dependencies between IT and business to achieve sustainable positive effects.
Employing modern strategies and tools specifically tailored to the company's needs.
Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.
Objective: streamlining management and enabling well-founded, data-driven decision-making.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Freelance Consultant Business Intelligence (Self-employed)
Nearby freelancers
Professionals working in or nearby Ennepetal, Germany

