Matthias Wähler-Freelance Consultant Business Intelligence
Check rate
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.
Skills
- Areas Of Activity: Development Of Company-Wide Data Platforms And Reporting Applications
- Use Of Self-Developed Solutions For Automation In The Area Of Relational And Analytical Databases, As Well As Data Integration
- Consulting And Coaching For Building Development Processes And Reporting Solutions Using Agile Methods
- Technology: Microsoft Bi
Languages
Education
KNIPEX-Werk C. Gustav Putsch KG
Industrial clerk · Industrial clerk · 1,2
Berufskolleg Barmen – Europaschule
General university entrance qualification · Wuppertal, Germany · 2,5
Berufskolleg Barmen – Europaschule
State-certified commercial assistant for foreign languages · Foreign languages · Wuppertal, Germany · 1,3
Certifications & licenses
Microsoft Certified Solution Associate (MCSA) SQL Server
Professional Scrum Master (PSM I)
Scrum.org
Statistics
Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Marco Skulschus
Tobias Holtkamp
Stefan Corsten
Henok Abraham
Moez Seyedan
Torsten Feix
Umut Gülac
Guido Klein
Petru Kisalita
Ronny Herold
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Freelance Consultant Business Intelligence (Self-employed)
Torsten Feix
Marco Skulschus
Henok Abraham
Moez Seyedan
Umut Gülac
Tobias Holtkamp
Vitali Haberkorn
Eduard Van kleef
Petru Kisalita
Andreas Flegel
Denis Kirpicev
Nearby freelancers
Professionals working in or nearby Ennepetal, Germany
Stefan Hans
Alexander Bromberg
Katharina Neumann
Michael Hantschel
Florian Dieterle
Rainer Pack
Andreas Schott
Yaroslav Shargorodskiy
Martin Ejeagwu
Marcus Wolf
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
