Stefan D.
BI Consultant in Controlling
Experience
Apr 2025 - Present
9 monthsRemote
BI Consultant in Controlling
Reutter GmbH
- Extraction, transformation and cleaning of data from Microsoft Dynamics AX
- Creating sales reports in Power BI and consolidating them into a data warehouse.
- Training employees in Business Intelligence Technologies: Power BI, SQL, SQL Server Integration Services (SSIS)
Jul 2024 - Present
1 year 6 monthsFrankfurt, Germany
BI & Data App Developer
A&W Holding GmbH (Energievertrieb)
- Automating the controlling process.
- Extraction, transformation and cleaning of data from various data sources and consolidating into a data warehouse.
- Creating comprehensive dashboards and reports in Power BI.
- Leading a team of two data analysts.
- Technologies: Power BI, Python, SQL, Excel, Git
Apr 2024 - Present
1 year 9 monthsVienna, Austria
Business Data Engineer
Gebauer & Griller Kabelwerke GmbH (Automotive)
- Building an ETL process in Azure Data Factory to load data from SAP ERP, SAP BW and SAC.
- Cleaning, linking and analyzing data in Azure Databricks.
- Delivering reports in Power BI.
- Coordinating with stakeholders: business analysts, SAP consultants and DevOps engineers.
- Technologies: Azure Data Factory, Databricks, Power BI, Apache Spark
Apr 2024 - Nov 2024
8 monthsMunderfing, Austria
Controlling Tool Developer
Glasfaser Spezial-Bau GmbH (Bauindustrie)
- Developing a Python pipeline to load data from two construction planning systems into a data warehouse.
- Creating a Power BI report with detailed maps of the fiber network to monitor construction progress and costs.
- Technologies: Power BI, Python, MySQL, Git
Nov 2023 - Mar 2024
5 monthsZürich, Switzerland
BI Consultant
Von Greyerz AG (Asset Management)
- Creating comprehensive Power BI reports on managed assets, inventory movements, financial metrics and customer KPIs.
- Ensuring highest care for data security due to highly confidential customer data.
- Technologies: Power BI, SQL
Aug 2023 - Sep 2023
2 monthsBerlin, Germany
Financial Modelling Consultant
Zolar GmbH (Solaranlagen)
- Preparing the financial planning for a special purpose vehicle (SPV) for investor outreach.
- Technologies: Excel, VBA
Mar 2023 - Apr 2023
2 monthsBonn, Germany
BI Consultant
DHL Consulting GmbH (Management & Logistics Consulting)
- Acting as a sparring partner in creating an HR dashboard and supporting complex DAX formulas.
- Technologies: Power BI
Dec 2022 - Feb 2023
3 monthsHamburg, Germany
BI Consultant
DZ-4 GmbH (Solaranlagen)
- Developing a controlling tool in Power BI for plan vs actual comparison of the solar portfolio.
- Technologies: Power BI
May 2022 - Apr 2023
1 yearEschborn, Germany
Manager (freelance)
Ernst & Young
- Project manager at EY Germany in Strategy & Transactions focused on financial modelling and business intelligence.
- Responsible for the financial modelling workstream in 2 M&A projects and 2 controlling projects.
- Technologies: Power BI, Excel
Jun 2021 - Apr 2022
11 monthsVienna, Austria
Financial Modelling Consultant
Bausparkasse Wüstenrot AG (Bank)
- Creating budget planning for the capital market as part of launching a retail bank.
- Technologies: Excel, VBA
May 2021 - Dec 2021
8 monthsAmsterdam, Netherlands
Energy Data Analyst
Power2X Services B.V. (Energie)
- Modeling the European electricity market (supply and demand modeling) to develop electricity price scenarios.
- Technologies: Python, PLEXOS
Mar 2021 - Apr 2021
2 monthsVienna, Austria
Financial Modelling Consultant
Ring International Holding AG (Private Equity)
- Preparing planning calculations for various RIH companies.
- Technologies: Excel
Jan 2021 - Present
5 yearsVienna, Austria
Founder & Consultant
Walecon e.U.
- Founded the consulting firm Walecon focusing on business intelligence, data analytics and financial modelling
Sep 2018 - Dec 2020
2 years 4 monthsVienna, Austria
Manager
Ernst & Young
- Part of the EY Strategy & Transactions team and responsible for business analytics and financial modelling.
- Projects in business intelligence and data warehousing, integrated financial planning, statistical modeling.
Mar 2015 - Jun 2018
3 years 4 monthsZug, Switzerland
Portfolio Optimization Expert
MET International AG
- Part of the Power & Gas Trading team. Responsible for controlling and optimizing electricity and gas supply contracts. Performing market analyses using statistical methods.
Feb 2012 - Mar 2015
3 years 2 monthsVienna, Austria
Commodities and Financial Analyst
Sibex GmbH
- Data warehousing, data analytics and financial planning in commodity trading.
Feb 2009 - Feb 2012
3 years 1 monthVienna, Austria
Consultant
Deloitte
- Part of the Financial Advisory team focusing on quantitative finance, financial modelling and business analytics.
Summary
Support along the entire data-based decision-making process from raw data preparation through statistical analysis to transparent communication to decision makers:
- Implementing end-to-end solutions to automate the controlling process, including data integration, transformation and dashboarding.
- Preparing and merging business data from different data sources.
- Developing interactive BI dashboards and visualizing complex business data to support data-driven decisions.
- Conducting analyses using statistical methods (machine learning).
Languages
German
NativeEnglish
AdvancedEducation
Sep 2014 - Jul 2015
University of Geneva
Diploma of Advanced Studies · Commodity Trading · Geneva, Switzerland
Mar 2009 - Dec 2010
University of Vienna
Master, Statistical Programming · Data Science · Vienna, Austria · Graduated with distinction
Jul 2007 - Mar 2009
University of Vienna
Bachelor · Statistics and Data Analytics · Vienna, Austria · Graduated with distinction
...and 1 more
Certifications & licenses
Microsoft Certified: Azure Data Fundamentals
Microsoft
Microsoft Certified: Azure Enterprise Data Analyst
Microsoft
Microsoft Certified: Power BI Data Analyst
Microsoft
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
Philipp G.
Building a Modern Compensation System
View Profile
Marco S.
Business Analyst, Data Warehouse Developer
View Profile
Germo G.
BI Development
View Profile
Nikolaus J.
Solution Architect
View Profile
Ildar A.
Senior Data Engineer
View Profile
Tarek S.
Cloud Analytics Developer
View Profile
Thomas U.
Corporate Reporting
View Profile
Vitali H.
Power BI Expert
View Profile
Ursula M.
Data Scientist & AI Engineer & AI Architect
View Profile
Tobias B.
Project Management, Consulting
View Profile
Andreas F.
Head of Data Platforms SAP & Non-SAP
View Profile
Gerald G.
Data Warehouse Architect and Lead Data Modeler
View Profile
Bernd S.
Business Data Analyst | PowerBI & Microsoft SQL Server
View Profile
Karl E.
Hiring Requirement
View Profile
Friedbert W.
Data Analyst / Business Analyst
View Profile
Henok A.
Founder and Managing Director
View Profile
Martin T.
Freelance, Interim Controller
View Profile
Stephan S.
Senior Data/ML Consultant & Technical Lead
View Profile
Willi Z.
Data Analyst
View Profile
Konstantin G.
Requirements engineer, Python Developer
View Profile
Eduard V.
Tech Lead Customer Base Documentation Automation
View Profile
Petru K.
ETL, DWH, BI Solution Design, Architecture & Development.
View Profile
Simon S.
Cloud Data Platform Product Owner & Project Manager
View Profile
Diana A.
Power BI Consultant
View Profile
Moez S.
Business Intelligence & Controlling
View Profile
Thomas R.
MS Power BI / MS SQL Developer
View Profile
Manfred S.
Data Solutions Consultant
View Profile
Jonathan S.
AI Consultant
View Profile
Christian D.
Lead Business Functional Analyst
View Profile
Reinhold S.
Senior Software Developer
View Profile
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.