Andreas Rothmann - Power BI Consultant

Q: Where is Andreas based?

Andreas is based in Ringsheim, Germany .

Q: What languages does Andreas speak?

Andreas speaks the following languages: German (Native) .

Q: How many years of experience does Andreas have?

Andreas has at least 17 years of experience. During this time, Andreas has worked in at least 3 different roles and for 20 different companies . The average length of individual experience is 1 year and 10 months . Note that Andreas may not have shared all experience and actually has more experience.

Q: What companies has Andreas worked for in recent years?

In recent years, Andreas has worked for Mid-sized manufacturer of adhesive systems , Austrian machine manufacturer , Machine manufacturer , Mid-sized machine manufacturer , and Mid-sized temperature control systems manufacturer .

Q: Which industries is Andreas most experienced in?

Andreas is most experienced in industries like Manufacturing , Information Technology , and Pharmaceutical . Andreas also has some experience in Retail , Construction , and Cosmetics .

Q: Which business areas is Andreas most experienced in?

Andreas is most experienced in business areas like Business Intelligence , Information Technology , and Supply Chain Management . Andreas also has some experience in Project Management , Finance , and Product Development .

Q: Which industries has Andreas worked in recently?

Andreas has recently worked in industries like Manufacturing , Pharmaceutical , and Information Technology .

Q: Which business areas has Andreas worked in recently?

Andreas has recently worked in business areas like Business Intelligence , Information Technology , and Supply Chain Management .

Q: What is Andreas's education?

Andreas holds a Master in Master of Business Administration – General Management from Offenburg University of Applied Sciences and a Bachelor in Applied Computer Science from Offenburg University of Applied Sciences .

Recommended expert

Ringsheim, Germany

Check rate

Experience

Jan 2025 - Present

1 year 8 months

Mid-sized manufacturer of adhesive systems

Migrated sales reporting to Power BI
Trained the department in Power Query and DAX
Set up a data warehouse for optimal data processing

Jan 2025 - Present

1 year 8 months

Austrian machine manufacturer

Migrated the KPI landscape (production/sales/purchasing) to Power BI
Trained expert teams (in-house knowledge transfer)

Jul 2024 - Present

2 years 2 months

Machine manufacturer

Supported the creation of Oracle-based reports
Implemented ETL processes in PL/SQL

Jun 2023 - Present

3 years 3 months

Mid-sized machine manufacturer

Migrated existing analyses to a Power BI infrastructure
Conducted requirements analysis with the business department

Mar 2023 - Present

3 years 6 months

Mid-sized temperature control systems manufacturer

Replaced manual Excel analyses in human resources with Tabular models
Modified local web applications (C#)
Trained the department on data warehousing

Jul 2022 - Present

4 years 2 months

Mid-sized software manufacturer

Data migrations from legacy systems
Interface programming
Support in data analytics
Consulting in the Power Platform

Jun 2022 - Dec 2023

1 year 7 months

International crane manufacturer

Implementation of reports based on Power BI on-premises using Tabular Models
Implementation of dynamic planning tools to optimize make-or-buy decisions
Implementation of bill of materials analyses as a basis for design optimizations

Apr 2022 - Jun 2022

3 months

Cosmetics manufacturer

Development of Power BI reports in sales, inventory, and financial accounting
Maintenance of the reports through MSSQL Server views
Implementation of dataflows

Sep 2021 - Dec 2021

4 months

International pharmaceutical company (Germany)

Development of Power BI reports in supplier evaluation, lab analytics, and quality assurance
Maintenance of the reports through the Enterprise Data Backbone (Databricks) and Oracle
Implementation of dataflows
Implementation of Power Apps for data collection within Power BI
Implementation of Power Automate flows for further processing and extraction of Teams data

May 2021 - Jun 2022

1 year 2 months

International pharmaceutical company (Austria)

Implementation of custom visuals
Creation of software for automatic KPI generation using templates

Feb 2021 - Present

5 years 7 months

International pharmaceutical group (Austria)

Developed Power BI reports in warehouse management and change management
Managed reports via Enterprise Data Backbone (Databricks), SharePoint files (exported from SAP), and Excel (manual entries)
Refactored existing reports using DAX Studio and Tabular Editor

Feb 2021 - Jun 2021

5 months

Medium-sized e-commerce retailer

Implemented ETL processes in Python for Amazon (REST API, Selenium)
Created reports for sales and warehouse management

Feb 2021 - Jun 2021

5 months

Software vendor

Implemented an import interface to Mercateo using PL/SQL

Nov 2020 - Dec 2020

2 months

Software vendor

Developed a system for the automatic detection of incoming invoices and order confirmations using Azure Cognitive Services and Azure Data Lake

Sep 2020 - Dec 2022

2 years 4 months

International construction group

Developed Power BI reports using Power BI dataflows (including linked entities)
Implemented new requirements in finance and sales reporting
Refactored existing reports using DAX Studio and Tabular Editor
Optimized performance of existing reports
Requirements engineering in an international team
Developed and populated streaming datasets using C#
Connected Azure Data Lakes as a data source
Conducted training sessions
Implemented ETL processes using Data Factory
Administered and deployed Azure ML models (via Visual Studio Code)

Jan 2020 - Jul 2020

7 months

Own SaaS product

Developed custom connectors and Power BI template apps as a SaaS product in my own shop

Jun 2019 - Present

7 years 3 months

Mid-sized variant manufacturer

Replaced existing controlling landscape (SSAS cube, Excel as frontend) with Power BI
Connected and consolidated heterogeneous data sources
Carried out all common project phases: requirements engineering, implementation, testing, training, support
Source systems: Microsoft Business Central, Microsoft Dynamics NAV ERP/CRM, proprietary production system

Jan 2019 - May 2019

5 months

Mid-sized e-commerce retailer

Introduced Power BI as an analytics tool
Connected various cloud systems (Facebook, inventory management system, currency service provider, Sheet) via REST API
Training and administration including administrative tasks

May 2015 - May 2020

5 years 1 month

Offenburg, Germany

Information Warehouse Manager

Printus GmbH

Introduced Power BI and conducted training sessions
Developed connections to external cloud-based systems
Translated domain-specific requirements from SAP into reports
Implemented SSAS tabular models and SSAS cubes as sources for Power BI
Implemented and maintained ETL processes (Oracle DWH/SQL Server)

Mar 2010 - May 2015

5 years 3 months

Lahr, Germany

ERP/BI Consultant/Project Manager

Schrempp EDV

Developed the in-house ERP software SIVAS
Developed the in-house business intelligence software BI.Analyzer
Led subprojects in material management/internal logistics, programming mobile devices
Led full projects in the mechanical engineering industry: created technical concepts, conducted training, implemented process reliability
Advised new and existing clients on business intelligence: defining key metrics, documentation, evaluation, knowledge transfer to end users
Completed over 20 business intelligence projects for clients of various sizes

Mar 2009 - Feb 2010

1 year

Sindelfingen, Germany

Junior ERP-Consultant

COMPUTENZ

Creation of custom programming/reports
Migration of the COMPUTENZ industry software to the Role Tailored Client
Knowledge transfer of new technologies to colleagues

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Manufacturing, Information Technology, Pharmaceutical, Retail, and Construction.

Manufacturing

Information Technology

Pharmaceutical

Retail

Construction

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Information Technology, Supply Chain Management, Project Management, Finance, and Product Development.

Business Intelligence

Information Technology

Supply Chain Management

Project Management

Finance

Product Development

Summary

I have over 10 years of experience in developing and optimizing data warehouses and reporting solutions. I focus on implementing and enhancing Power BI, ETL processes, and dataflows while ensuring that users understand and benefit from new tools.

I have helped companies in manufacturing, healthcare, software, and e-commerce modernize their data strategies. My strength lies in creating practical reporting solutions, providing clear training, and streamlining processes to deliver valuable insights and improved performance.

Skills

Power Bi

Backend Modeling (Power Query M, Sql, Rest Api)
Creating Reports/Dashboards/Dataflows/Metrics (Dax)
Administering Power Bi Service/On-Premises
Implementing Custom Connectors
Implementing Power Bi Apps
Optimizing Existing Models Using Daxstudio, Tabular Editor

Databases

Oracle (Sql/Plsql)
Sql Server (Relational Database/Ssas Cube/Ssas Tabular/Ssis)
Various Cloud-Based Erp Systems

Erp Systems

Microsoft Dynamics Erp
Microsoft Business Central
Microsoft Dynamics Crm
Sivas Erp 360
Sap

Programming

C#
Plsql
Powershell
Python

Microsoft Azure

Data Factory
Azure Data Lake
Cognitive Services

Other

Business Mediator (Ihk Certificate)
Istqb Certified Tester (Foundation Level)

Languages

German

Native

Education

Oct 2011 - Jun 2013

Offenburg University of Applied Sciences

Master of Business Administration – General Management · Master of Business Administration – General Management · Offenburg, Germany · 1.7

Oct 2005 - Jun 2009

Offenburg University of Applied Sciences

Bachelor of Science · Applied Computer Science · Offenburg, Germany · 2.1

Certifications & licenses

IHK Certificate

Statistics

Experience

Total positions 21

Experience in Manufacturing 12.5 y

Avg length 2 y 3 m

Longest experience 7 y 2 m

Global Experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Recent roles Information Warehouse Manager, ERP/BI Consultant/Project Manager, Junior ERP-Consultant

Main industries Manufacturing, Information Technology, Pharmaceutical

Main business areas Business Intelligence, Information Technology, Supply Chain Management

Qualifications

Highest degree Master

Certifications earned 2

Profile

Created

October 2025

Last Update

February 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Andreas is based in Ringsheim, Germany.

Andreas speaks the following languages: German (Native).

Andreas has at least 17 years of experience. During this time, Andreas has worked in at least 3 different roles and for 20 different companies. The average length of individual experience is 1 year and 10 months. Note that Andreas may not have shared all experience and actually has more experience.

Based on recent experience, Andreas would be well-suited for roles such as: Information Warehouse Manager, ERP/BI Consultant/Project Manager, Junior ERP-Consultant.

In recent years, Andreas has worked for Mid-sized manufacturer of adhesive systems, Austrian machine manufacturer, Machine manufacturer, Mid-sized machine manufacturer, and Mid-sized temperature control systems manufacturer.

Andreas is most experienced in industries like Manufacturing, Information Technology, and Pharmaceutical. Andreas also has some experience in Retail, Construction, and Cosmetics.

Andreas is most experienced in business areas like Business Intelligence, Information Technology, and Supply Chain Management. Andreas also has some experience in Project Management, Finance, and Product Development.

Andreas has recently worked in industries like Manufacturing, Pharmaceutical, and Information Technology.

Andreas has recently worked in business areas like Business Intelligence, Information Technology, and Supply Chain Management.

Andreas holds a Master in Master of Business Administration – General Management from Offenburg University of Applied Sciences and a Bachelor in Applied Computer Science from Offenburg University of Applied Sciences.

Andreas has 2 certificates. These include: Istqb Certified Tester (Foundation Level) and Business mediator.

Andreas is immediately available for suitable projects.

Andreas's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

To hire Andreas, click the Meet button on the profile to request a meeting and discuss your project needs.

Daily Rate Distribution

0 2 4 6 8

<€800 €800-1200 €1200-1600 €1600+

The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.

Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200

900

600

300

Daily rate avg. 1000 €

The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.

1200

900

600

300

Median rate 800 €

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.

Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.