Stefan Dangubic-BI Consultant in Controlling
Check rate
Experience
BI Consultant in Controlling
Reutter GmbH
- Extraction, transformation and cleansing of data from Microsoft Dynamics AX
- Creation of sales reports in Power BI
- Training employees in business intelligence
- Technologies: Power BI, SQL, SQL Server Integration Services (SSIS)
BI & Data App Developer
A&W Holding GmbH
- Automation of the controlling process
- Extraction, transformation and cleansing of data from various data sources and consolidation into a data warehouse
- Creation of comprehensive dashboards and reports in Power BI
- Responsible for a team of two data analysts
- Technologies: Power BI, Python, SQL, Excel, Git
Business Data Engineer
Gebauer & Griller Kabelwerke GmbH
- Development of an ETL process in Azure Data Factory to load data from SAP ERP, SAP BW and SAC
- Cleansing, linking and analysis of data in Azure Databricks (Medallion architecture Bronze/Silver/Gold)
- Deployment of reports in Power BI
- Responsible for aligning 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
- Development of a Python pipeline to load data from two construction planning systems into a data warehouse
- Creation of a Power BI report with detailed maps of the fiber network to monitor construction progress and costs
- Technologies: Power BI, Python, MySQL, Git
BI Consultant
Von Greyerz AG
- Creation of comprehensive Power BI reports on managed assets, inventory movements, financial metrics and customer KPIs
- Strict adherence to data security due to highly confidential customer data
- Technologies: Power BI, SQL
Financial Modelling Consultant
Zolar GmbH
- Prepared financial planning for a special purpose vehicle (SPV) for investor outreach
- Technologies: Excel, VBA
BI Consultant
DHL Consulting GmbH
- Served as a sparring partner for creating an HR dashboard and supported complex DAX formulas
- Technologies: Power BI
BI Consultant
DZ-4 GmbH
- Built a controlling tool in Power BI for 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
- Created a budget plan for the capital market as part of launching a retail bank, considering regulatory requirements
- Technologies: Excel, VBA
Energy Data Analyst
Power2X Services B.V.
- Modeling of the European power market (supply and demand modeling) for developing electricity price scenarios
- Technologies: Python, PLEXOS
Financial Modelling Consultant
Ring International Holding AG
- Preparation of planning calculations for various RIH companies
- Technologies: Excel
Founder & Consultant
Walecon e.U.
- Founder of the consulting firm Walecon with a focus on Business Intelligence, Data Analytics and Financial Modelling
Manager
Ernst & Young
- Part of the EY Strategy & Transactions team and responsible for the Business Analytics and Financial Modelling area
- Projects in Business Intelligence and Data Warehousing, integrated financial planning, and statistical modelling
Portfolio Optimisation Expert
MET International AG
- Part of the Power & Gas Trading team
- Responsible for controlling and optimisation of electricity and gas supply contracts
- Conducting market analyses using statistical methods
Commodities and Financial Analysts
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, automating processes and visualizing business data. Supporting the entire data-based decision-making process from preparing raw data through statistical analysis to clear 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 different data sources (ETL & data warehousing).
- Development of interactive BI dashboards and visualization of complex business data to support data-driven decisions.
- Performing 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
- Versioning & 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
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
