Business Analyst

Introduction:

The candidate is an experienced Business Analyst with a strong background in commercial controlling, profitability analysis, and financial reporting. They are skilled in Excel and Power BI, with a proven ability to develop and maintain dashboards and financial models that support decision-making. The candidate has a solid understanding of financial metrics, key performance indicators, and profitability reporting. They have successfully led initiatives in digitalization and automation, including implementing software solutions and ERP systems. The candidate has also demonstrated expertise in sales forecasting, budget variance analysis, and process improvements, identifying cost-saving opportunities and streamlining workflows. Additionally, they have experience in training employees on Microsoft Office Suite, focusing on enhancing Excel skills for improved productivity. The candidate’s experience spans across various roles where they collaborated with management teams to provide strategic insights and support. Their background in financial analysis, digitalization projects, and sales forecasting enables them to drive operational efficiency and contribute effectively to business growth.

Responsibilities:

• Prepare and analyze monthly, quarterly, and annual financial statements and reports.
• Identify and analyze financial risks and opportunities, providing recommendations to management.
• Collaborate with management teams to support strategic decision-making.
• Develop and maintain dashboards in Power BI for various departments (Commercial, Operational, HR).
• Lead discussions with stakeholders to gather requirements and tailor dashboards to departmental needs.
• Develop and maintain profitability and sales reports, securely stored in the cloud for collaboration.
• Spearhead digitalization and automation of reporting processes, including software implementations and ERP systems.
• Conduct comprehensive training sessions on Microsoft Office Suite, focusing on Excel skills.
• Manage the development of cloud-based Excel files for sales forecasting, enabling easy tracking of forecasts.
• Perform detailed variance analysis comparing actual results against budgeted figures to support decision-making.
• Lead the design and implementation of commission calculation systems for commercial and operational teams.
• Create and update variable costs matrices for products sold, supporting profitability and sales analysis.
• Provide support to sales teams by delivering required variable costs for accurate pricing calculations.
• Perform orderbook analysis and profitability reports for multiple product lines.
• Oversee Power BI implementation for commercial controlling and profitability departments.
• Manage the preparation of financial reports, including forecast vs. actual analysis.
• Ensure compliance with policies, procedures, and internal controls through continuous audits and process improvements.