Stefan Dangubic

BI Consultant in Controlling

Vienna, Austria

Experience

Apr 2025 - Present
4 months
Remote

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 1 month
Frankfurt, 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 4 months
Vienna, 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 months
Munderfing, 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 months
Zü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 months
Berlin, 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 months
Bonn, 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 months
Hamburg, 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 year
Eschborn, 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 months
Vienna, 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 months
Amsterdam, 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 months
Vienna, Austria

Financial Modelling Consultant

Ring International Holding AG (Private Equity)

  • Preparing planning calculations for various RIH companies.
  • Technologies: Excel
Jan 2020 - Present
4 years 7 months
Vienna, 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 months
Vienna, 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 months
Zug, 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 months
Vienna, Austria

Commodities and Financial Analyst

Sibex GmbH

  • Data warehousing, data analytics and financial planning in commodity trading.
Feb 2009 - Feb 2012
3 years 1 month
Vienna, 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
Native
English
Advanced

Education

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

Certifications & licenses

Microsoft Certified: Azure Data Fundamentals

Microsoft

Microsoft Certified: Azure Enterprise Data Analyst

Microsoft

Microsoft Certified: Power BI Data Analyst

Microsoft