Business Analyst

About Core Group

Core Group represents some of the world's most valued and loved brands in Sub-Saharan Africa. It's our mission to empower individuals and organisations with the world's leading personal technology products and services.

We are the leading distributor of Apple in Sub-Saharan Africa, proudly representing the brand in South Africa since 1995. We also distribute other global brands such as DJI and Nintendo.

Our responsibilities are all-encompassing, spanning supply chain management, marketing management, channel management, enterprise sales, and media relations. Our operational footprint extends across Botswana, Namibia, Nigeria, South Africa.

About the role

We are looking for a Business Analyst to join our team. This role is ideal for someone who thrives in a data-driven environment and enjoys translating business needs into actionable insights. You'll work closely with various stakeholders to support strategic decision-making, enhance reporting capabilities, and optimise processes through data analysis and automation.

Key Responsibilities

• Data and reporting integrity; continuous evaluation of data sources, stored data sets and business reports to support decision making. Collate, assess and analyse data for accuracy and relevance. Define relationships between different data sets and sources. Identify shortcomings in existing data sources and define the requirements for new data sets to address the shortcomings.
• Operational and Performance reporting; Build out a comprehensive set of reports and/or dashboards that represent the status of the business across all its functions.
  Pre-empt any new reporting requirements based on future operations or business initiatives.
  Prepare and present improvements, updates and new insights to support better decision making.
• Specific business requirements include, but are not limited to
  • Purchasing and cost price analysis
  • Inventory metrics and process throughput
  • OPEX analysis
  • Repairs and BOM analysis
  • Sales pricing and margin analysis
  • Competitor pricing and market trend analysis
  • Maintenance of internal pricing tools
  • Analysis to support promotional campaigns
• Insights and business decision support; provide weekly updates on all key metrics and suggest updates and changes to improve efficiencies and improve business performance.
• Provide input into continuous improvement initiatives; Continuously assess all operations and performance reporting against industry and business best practices.
  Identify new reporting requirements based on new insight or future business requirements.
  Review all data sets and sources for relevance and identify areas of improvements. Evaluate and improve business processes through analysis, automation, and best practice recommendations.
• Work with stakeholders to define business requirements and translate them into functional specifications.
• Design and maintain dashboards and analytics solutions that enable self-service and data-driven decisions.
• Extract and analyse data using SQL, identifying patterns, trends, and opportunities for improvement.

Required Skills & Experience

• 4–6 years' relevant experience in business analysis, business intelligence, data analytics or a similar field.
• Strong SQL skills (MS SQL, PostgreSQL or MySQL).
• Advanced Power BI capabilities (including DAX, Power Query, custom visuals).
• Proficiency in Excel (Power Query, PivotTables, VBA).
• Knowledge of Microsoft Fabric or similar data integration tools is beneficial.
• Experience engaging with cross-functional teams and presenting insights clearly to non-technical stakeholders.
• Bachelor's degree in Information Technology, Data Science, Statistics or a related field (Honours preferred).
• CBAP or similar certification is advantageous.

Key Competencies

• Excellent verbal and written communication skills
• High attention to detail and data accuracy
• Logical, analytical thinker with strong problem-solving ability
• Results-oriented, with good time management and organisational skills
• Adaptable and comfortable working in a dynamic environment

Note: If your application is successful, background checks will be conducted (criminal record, credit, ID verification, matric verification, and references.