Menu Close

Cape Town Region: Business Analyst

Cape Town Region: Business Analyst

Posted on 2025-09-01 00:00:00

Job Summary

Role Purpose: This is a project-based position. The Business/Data Analyst will review existing data structures, consolidate information from Excel-based systems, and design insights-driven reporting. This individual will advise on the best-fit system to migrate data into, ensuring accurate visibility of sales, margins, service performance, and operational efficiency across multiple sites. The Business Analyst will be responsible for analyzing and interpreting data from Xero (accounting software) and DEAR Inventory (inventory management system) to provide insights into cost structures, profit margins, and process optimization. A key focus will be on working with the Bill of Materials (BOM) to determine cost per can under different scenarios, highlighting areas for improved efficiency and profitability. As a strategic thinker, this role will report directly to the CEO/MD, providing high-level analysis and recommendations. The consultant will review progress post-implementation to ensure initiatives remain on track and that systems are being optimized. A key part of the role will be identifying process-driven time and cost-cutting opportunities and reducing waste to protect profitability. Key Responsibilities: ● Extract, reconcile, and analyse financial, inventory, and sales data from Xero, DEAR Inventory, and other systems to ensure accurate reporting. ● Work with the Bill of Materials (BOM) to calculate cost per unit across production scenarios and support accurate costing and forecasting. ● Develop, maintain, and present dashboards/reports highlighting key metrics such as profit margins, cost breakdowns, process efficiencies, sales performance, and service effectiveness. ● Identify data discrepancies or anomalies, troubleshoot proactively, and ensure data accuracy and integrity. ● Conduct scenario analyses, build financial models, and provide insights to support decision-making, strategic planning, and board reviews. ● Analyse sales data, customer behaviour, product/service performance, and margins across locations to identify growth opportunities and areas for optimisation. ● Recommend and implement strategies for pricing, promotions, bundling, and new revenue streams to enhance profitability and customer offering. ● Collaborate with finance, operations, production, warehouse, sales, and front-line teams to align goals, streamline processes, and improve cross-functional performance. ● Provide actionable recommendations for process optimisation, waste reduction, and cost efficiencies across departments. ● Research, evaluate, and recommend data systems beyond Excel to improve reporting capabilities. ● Lead and evaluate data-driven marketing campaigns, ensuring initiatives deliver ROI and align with business objectives. ● Monitor market trends, competitor activity, and customer behaviours to inform business strategies. ● Review and track initiatives post-implementation to confirm effectiveness and alignment with business goals. ● Important focus: Expanding use of Dear inventory Defining and calculating inputs to BOM Implementation of BOM on Dear Assistance with embedding new processes. Requirements Education & Experience: ● Bachelors degree in Data Analytics, Business (BCom), Engineering (BEng), or similar field. ● 5 years experience in a business/data analyst role. ● Experience in FMCG, retail, or service-based industries is advantageous. ● Strong experience with Microsoft Excel (pivot tables, data modelling); proficiency in other analysis/reporting tools is highly desirable. Skills & Competencies: ● Strategic thinker with commercial acumen and problem-solving ability. ● Strong analytical and critical thinking skills. ● Proficiency in working with Xero and DEAR Inventory (or similar systems). ● Commercially minded with a clear understanding of profitability and cost drivers. ● Excellent communication, reporting, and presentation skills (written & verbal). ● Proven ability to translate complex data into clear, actionable insights. ● Highly detail-oriented with a methodical and structured approach. ● Strong collaboration skills, able to work effectively with cross-functional teams. ● Fluent in English with strong business writing skills. ● Quick learner, able to grasp concepts rapidly and conceptualise solutions.

View Job  Pretoria: Business Analyst

Click Go Apply to apply online!


Get Similar Job Alerts
Enter your WhatsApp number (e.g., +27740908132)
You'll receive alerts for new jobs in Cape Town Region, Western Cape

Apply directly for this position. Please read all instructions carefully.

We do not process job applications; we simply aggregate and display job listings.

More related positions


Cape Town: Engineering Lecturer posted by The Talent Room

A private higher education institution in Cape Town is seeking a qualified Engineering Lecturer to join their academic team.The successful candidate will be...


View Job
Engineering Lecturer

Cape Town: Sales Manager posted by Daisy JHB (Pty) Ltd

Staff ManagementSet targets, performance plans, and rigorous, objective standards for sales representatives.Meet with reps one-on-one weekly to review...


View Job
Sales Manager

Cape Town: Luxury Showroom Consultant – High-End Furnishes and Interiors Finishes posted by Lumina Personnel

Position Luxury Showroom Consultant High-End Furnishes and Interiors FinishesLocation Cape Town - Somerset WestSalary Basic Commission benefits.Market...


View Job
Luxury Showroom Consultant – High-End Furnishes and Interiors Finishes

Cape Town: Showroom Sales Consultant-Trade Specialist (Luxury Furniture, Textiles & Interior Finishes) posted by Lumina Personnel

Position Showroom Sales Consultant-Trade Specialist Luxury Furniture, Textiles amp Interior FinishesLocation Gardens - Western CapeSalary Basic Plus Comm...

View Job  Pretoria: Chef de Partie (Hot Kitchen) - Urgent Position posted by Scholtz Partners International (Pty) Ltd

View Job
Showroom Sales Consultant-Trade Specialist (Luxury Furniture, Textiles & Interior Finishes)

Cape Town: Finishing Foreman posted by The Recruitment Pro

Minimum 5 years experience in finishing work on commercial or residential projectsStrong attention to detail with the ability to deliver high-end...


View Job
Finishing Foreman

Cape Town: OPERATIONS AND SALES SUPPORT EXECUTIVE posted by Tower Group

1.Operational support related to the OFOG divisionValue add in the supply chain by engaging with existing and future suppliers of equipment and allied...


View Job
OPERATIONS AND SALES SUPPORT EXECUTIVE

Cape Town: Operations Manager posted by Elchemie

Operations ManagerLocation Milnerton, Western CapeIndustry Facilities amp Cleaning Services Experience 5 - 10 yearsType Full-time Environment...


View Job
Operations Manager

Cape Town: Production Planner posted by Hire Resolve

Are you a detail-driven Production Planner ready for your next career-defining move? Our client, a well-established player in the fast-moving consumer goods...


View Job
Production Planner

Cape Town: Data Integrity and Systems Support Analyst posted by Hire Resolve

One of the countrys largest fruit exporters, offers a challenging role to a dynamic individualin the capacity of a Data Integrity and Systems Support...


View Job
Data Integrity and Systems Support Analyst

Cape Town: Sales Hunter – Urgently Required posted by bh.

This is not a job for the faint-hearted. This is for the hungry.Were looking for a high-performance sales closer - someone who thrives under pressure, moves...


View Job
Sales Hunter – Urgently Required

Cape Town: Centre Manager (Paarl) posted by Flair TM

Key Responsibilities1. Financial Management amp BudgetingPrepare and manage the centrersquos annual income and expense budgets.Track rental income,...


View Job
Centre Manager (Paarl)

Cape Town: People and Culture Manager posted by SET Consulting

People and Culture ManagerR1.8m plus bonusCape TownExcellent career opportunity with global FMCG market leader for a highly seasoned HR expert. Reporting to...


View Job
People and Culture Manager

Cape Town: Senior .Net Full Stack Developer posted by Plus1X Solutions (Pty) Ltd

Job Title Senior .NET Full Stack DeveloperLocation Cape TownJob Type 12 Month Contract Potential to convert to permRole OverviewWe are seeking a highly...


View Job
Senior .Net Full Stack Developer

Cape Town: MILLWRIGHT / WORKSHOP TECHNICIAN – Urgently needed posted by CROWN STAFFING Pty Ltd

MILLWRIGHT WORKSHOP TECHNICIAN required for BLACKHEATH CAPE TOWN position to start ASAPMillwright Trade Test certificate essential.Minimum of 2 years POST...


View Job
MILLWRIGHT / WORKSHOP TECHNICIAN – Urgently needed

Cape Town: Project Manager posted by Hire Resolve

Location Ottery, Cape Town Type Full-Time On-Site Salary R 50nbsp000.00 Industry ManufacturingAn established industrial refrigeration company based in...

View Job  Centurion: DevOps and Automation Engineer

View Job
Project Manager

Cape Town: Structural Foreman posted by The Recruitment Pro

Structural Foreman with experience in concrete, high rise buildings, etc. Based in Cape Town.4-month contract. If both parties are happy at the end of the...


View Job
Structural Foreman

Cape Town: Technical Director–Network Planning & Optimization posted by Future Africa Consulting (Pty)Ltd

Responsibilities Provide strategic leadership for end-to-end radio and transmission network planning and optimization across multi-technology environments...


View Job
Technical Director–Network Planning & Optimization

Cape Town: Fleet Controller posted by Qetello

An exciting opportunity awaits a results-driven and detail-oriented Fleet Controller in the logistics industry based in Cape Town. Our client is seeking an...


View Job
Fleet Controller

Centurion: Financial Advisors Specializing in Health (Centurion and Cape Town) posted by AtripleA recruitment & temps

Financial Advisors Specializing in Health Centurion and Cape TownRole PurposeThe Financial Advisor specialising in Health will be responsible for acquiring,...


View Job
Financial Advisors Specializing in Health (Centurion and Cape Town)

Cape Town: Full Stack Engineer (Vue, Flutter or React Native) (Onsite CPT) posted by Datafin

Full Stack Engineer - Vue, Flutter or React Native Onsite - CPTEngineeringTechnicalCape Town - Western Cape - South AfricaENVIRONMENT A rapidly growing Cape...


View Job
Full Stack Engineer (Vue, Flutter or React Native) (Onsite CPT)

Cape Town: Senior Full Stack (AI) Engineer (TypeScript, Angular, Python, Node.js) (CPT Hybrid) posted by Datafin

Senior Full Stack AI Engineer TypeScript, Angular, Python, Node.js CPT HybridIT - Software DevelopmentCape Town - Western Cape - South AfricaENVIRONMENT A...


View Job
Senior Full Stack (AI) Engineer (TypeScript, Angular, Python, Node.js) (CPT Hybrid)

Cape Town: Sales Representitive posted by National Reps (Pty) Ltd

NATIONAL CONCERN SEEKS SALES REPRESENTATIVEWe are a National Sales Rep Company seeking a Sales Representative to complete our footprint in the Western Cape...


View Job
Sales Representitive

Cape Town: Occupational Health & Safety Officer posted by SA Metal

The company currently has a vacancy for a motivated, professional and attentive to detail Health and Safety Officer to join their team and drive company...


View Job
Occupational Health & Safety Officer

Cape Town: Mechanical Engineer posted by SA Metal

Job descriptionThe purpose of this position is to provide the essential technical knowledge, evaluate, select, and apply advanced engineering techniques to...


View Job
Mechanical Engineer

Cape Town: General Manager posted by Hire Resolve

A leading food manufacturer specializing in private-label perishable and shelf-stable foods is seeking an experienced General Manager to oversee all staff,...


View Job
General Manager

Share this to someone who needs a job:
Posted in Jobs in Cape Peninsula, Jobs in Cape Town Region, Jobs in South Africa, Jobs in Western Cape

More Jobs in Your Area