Business Intelligence Officer at Food Concepts Plc

Job Purpose

• To support decision-making through precise financial analysis, comprehensive reporting, and actionable insights that enhance profitability and operational efficiency. This role involves analysing key financial and market trends to ensure the organization responds effectively to inflationary pressures and competitive challenges. It also emphasizes collaboration with cross-functional teams to streamline business processes and guide strategic initiatives.

Core Responsibilities and Key Result Areas

Financial Analysis

• Analyse profitability trends across products, categories, and business units.
• Identify drivers of positive and negative EBITDA and provide actionable insights to management.
• Develop periodic financial reports and dashboards to support data-driven decision-making.
• Prepare reports on macroeconomic trends, including inflation, exchange rates, and their potential impact on the FMCG sector.
• Conduct analysis of FMCG market performance, competitor pricing, and consumer

Pricing and Inflation Management

• Regularly update raw material cost trends and recommend adjustments to pricing strategies tools.
• Maintain an up-to-date database of raw material prices for reference.
• Prepare supporting data and insights for management discussions on price adjustments

Business Intelligence.

• Gather and organize data from various sources to support business decision-making.
• Create reports and dashboards that highlight key business metrics.
• Perform basic analysis on financial and operational data to identify trends and patterns.
• Use tools like Excel or Power BI to create clear visual representations of data

Key Performance Indicators

• Accurate profitability trend reports and actionable insights provided to management.
• Identifying key drivers of negative EBITDA leading to measurable improvements in margins.
• Timely reports on macroeconomic, and FMCG reports delivered on time to stakeholders.
• Frequency and accuracy of raw material cost updates and recommended pricing strategy adjustments
• Number of actionable insights derived from business intelligence reports and dashboards created for decision-making.

Knowledge Requirements

• Understanding of financial statements, profitability analysis, and key financial metrics like EBITDA, margins, and cost structures.
• Knowledge of macroeconomic factors such as inflation, exchange rates, and their impact on the FMCG sector.
• Proficiency in tools like Excel, Power BI, or other data visualization software to create reports and dashboards.
• Excellent analytical, problem-solving, and critical-thinking skills.
• Understanding of FMCG market dynamics, including competitor analysis, consumer behaviour, and industry performance.

Requirements

• Bachelor’s degree in accounting, Finance, Economics, Business Administration, or a related field.
• Certifications in Business Intelligence or any relevant certifications (e.g., Microsoft Certified: Excel, Power BI) are an asset.
• Minimum of 2 years’ experience as Business intelligence officer or similar role.
• Proven experience in financial analysis, business intelligence, or a related role.
• Experience in a QSR company in a similar role is an asset