Stefan Dangubic
BI Consultant in Controlling
Experience
BI Consultant in Controlling
Reutter GmbH
- Extracting, transforming and cleaning data from Microsoft Dynamics AX
- Creating sales reports in Power BI
- Training staff in business intelligence
- Technologies: Power BI, SQL, SQL Server Integration Services (SSIS)
BI & Data App Developer
A&W Holding GmbH
- Automating the controlling process
- Extracting, transforming and cleaning data from various data sources and consolidating it 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
Business Data Engineer
Gebauer & Griller Kabelwerke GmbH
- 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 (Bronze/Silver/Gold medallion architecture)
- Preparing reports in Power BI
- Collaborating with stakeholders: business analysts, SAP consultants and DevOps engineers
- Technologies: Azure Data Factory, Databricks, Power BI, Apache Spark
Senior Data Engineer
Glasfaser Spezial-Bau GmbH
- Developing a Python pipeline to load data from two construction planning systems into a data warehouse
- Creating a Power BI report with detailed fiber network maps to monitor construction progress and costs
- Technologies: Power BI, Python, MySQL, Git
BI Consultant
Von Greyerz AG
- Creating comprehensive Power BI reports on managed assets, inventory movements, financial metrics and customer KPIs
- Ensuring the highest level of data security due to highly confidential client data
- Technologies: Power BI, SQL
Financial Modelling Consultant
Zolar GmbH
- Created the financial plan for a special purpose vehicle (SPV) to approach investors
- Technologies: Excel, VBA
BI Consultant
DHL Consulting GmbH
- Acted as a sparring partner in building an HR dashboard and supported complex DAX formulas
- Technologies: Power BI
BI Consultant
DZ-4 GmbH
- Developed a controlling tool in Power BI for the plan vs. actual comparison of the solar panel portfolio
- Technologies: Power BI
Manager (Freelance)
Ernst & Young
- Project manager at EY Germany in Strategy & Transactions focusing 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
Financial Modelling Consultant
Bausparkasse Wüstenrot AG
- Developed a budget plan for the capital market as part of launching a retail bank, taking regulatory requirements into account
- Technologies: Excel, VBA
Energy Data Analyst
Power2X Services B.V.
- Modeling the European electricity market (supply and demand modeling) to develop electricity price scenarios
- Technologies: Python, PLEXOS
Financial Modelling Consultant
Ring International Holding AG
- Creating planning calculations for different RIH companies
- Technologies: Excel
Founder & Consultant
Walecon e.U.
- Founded the consulting firm Walecon, focused on business intelligence, data analytics, and financial modelling
Manager
Ernst & Young
- Part of the EY Strategy & Transactions team, responsible for business analytics and financial modelling
- Projects in business intelligence and data warehousing, integrated financial planning, statistical modelling
Portfolio Optimisation Expert
MET International AG
- Part of the power & gas trading team
- Responsible for controlling and optimising electricity and gas supply contracts
- Conducting market analyses using statistical methods
Commodities and Financial Analyst
Sibex GmbH
- Data Warehousing, Data Analytics and Financial Planning in commodity trading
Consultant
Deloitte
- Part of the Financial Advisory team with a focus on Quantitative Finance, Financial Modelling and Business Analytics
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Professional Services, Banking and Finance, Energy, Manufacturing, and Construction.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Finance, Strategy, Information Technology, Project Management, and Research and Development.
Summary
Business Intelligence expert with extensive experience in developing data-driven solutions, the automation of processes and business data visualization. Supporting the entire data-driven decision-making process from raw data preparation through statistical analysis to transparent communication with decision-makers:
- Implementation of end-to-end solutions to automate processes, including data integration, transformation and dashboarding.
- Preparation and consolidation of business data from various data sources (ETL & Data Warehousing).
- Development of interactive BI dashboards and visualization of complex business data to support data-driven decisions.
- Conducting analyses using statistical methods (machine learning).
Skills
- Programming: Python, Sql
- Data Visualization & Bi: Power Bi, Dax, Power Query
- Cloud & Big Data: Azure Databricks, Azure Data Factory (Adf), Azure Synapse Analytics, Microsoft Fabric, Apache Airflow, Delta Lake
- Frameworks: Pandas, Numpy, Scikit-learn, Pyspark, Sqlalchemy, Streamlit
- Version Control & Deployment: Git, Azure Devops
- Financial Modelling: Excel, Vba
Languages
Education
University of Geneva
Diploma of Advanced Studies · Commodity Trading · Geneva, Switzerland
University of Vienna
Master · Data Science · Vienna, Austria
University of Vienna
Bachelor · Statistics and Data Analytics · Vienna, Austria
Certifications & licenses
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Azure Enterprise Data Analyst
Microsoft Certified: Power BI Data Analyst
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Stefan based?
What languages does Stefan speak?
How many years of experience does Stefan have?
What roles would Stefan be best suited for?
What is Stefan's latest experience?
What companies has Stefan worked for in recent years?
Which industries is Stefan most experienced in?
Which business areas is Stefan most experienced in?
Which industries has Stefan worked in recently?
Which business areas has Stefan worked in recently?
What is Stefan's education?
Does Stefan have any certificates?
What is the availability of Stefan?
What is the rate of Stefan?
How to hire Stefan?
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
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a BI Consultant in Controlling
Nearby freelancers
Professionals working in or nearby Vienna, Austria