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  Cape Town City Centre: Azure Engineer

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: Senior Travel Expert Southern and Eastern Africa posted by abc worldwide

Tavel Expert SampE AfricaOffices are in Rondebosch in the Southern Suburbs of Cape Town. Hybrid working week. additional benefits include29 days holiday per...


View Job
Senior Travel Expert Southern and Eastern Africa

Cape Town: Junior Reservationist posted by Kendrick Recruitment

Junior Reservationist Luxury Safari Lodge Cape TownLocation Cape Town Position Type Full-Time Salary Negotiable, Dependent on ExperienceKendrick...


View Job
Junior Reservationist

Cape Town City Centre: New Vehicle Sales Manager

Minimum Requirements Must have at least 3 to 5 years Dealership New Vehicle Sales Management experience within the Automotive Industry Grade 12...


View Job
New Vehicle Sales Manager

Cape Town: Area Manager posted by TradeOn

Exciting Opportunity for an Area Coach to Join our Dynamic Company and work within SAs No. 1 Fast Food brand!The successful candidate MUST possess the...

View Job  Western Cape: Software Engineer – Technology Innovation posted by Communicate Finance

View Job
Area Manager

Cape Town: PA/ Executive Assistant posted by The Key Recruitment Group

Our client based in Tokai , is looking for an experienced and highly capable PA Executive Assistant. The ideal candidate should be proactive, reliable, and...


View Job
PA/ Executive Assistant

Cape Town: SENIOR ARCHITECTURAL TECHNOLOGIST posted by TradeOn

SENIOR ARCHITECTURAL TECHNOLOGISTTradeOn is a KFC Franchisee with outlets across South Africa. We attribute our success not only to everyones favourite...


View Job
SENIOR ARCHITECTURAL TECHNOLOGIST

Cape Town: Porter posted by Lewis Stores (PTY) Ltd

Porter9 hrs pday TBC pmonthPermanent - Full-timeWork schedule As NeededStart date ASAPJob descriptionThis is a summary of what the job involves to help you...


View Job
Porter

Cape Town: Facilities Manager posted by Leeu Collection South Africa (Pty) Ltd.

Leeu Collection is known for sophisticated escapes and unique guest experiences. Its ever-expanding luxury hospitality portfolio offers dynamic career...


View Job
Facilities Manager

Cape Town: Night Auditor posted by Leeu Collection South Africa (Pty) Ltd.

The successful candidate will have to excel in providing service excellence and ensuring that the guest experience is prioritised above all else. As the...


View Job
Night Auditor

Cape Town: New Vehicle Sales Executives – Sell more thank 40 units pm. posted by Bonafide Human Capital

Our well-known automotive dealership client based in Cape Town is looking to employ 12 x New Car Sales Executive, with a proven track record.Must be able to...


View Job
New Vehicle Sales Executives – Sell more thank 40 units pm.

Cape Town: Agent (Sales Engineer) posted by Profile Personnel

This position is for an Independent ContractorSalary Commission onlyRequirementsMust have valid drivers licence and own vehicleMust have previous experience...


View Job
Agent (Sales Engineer)

Cape Town: New Vehicle Sales Manager – Sell bet. 40 & 50 units posted by Bonafide Human Capital

A vacancy for exists for 3 x New Car Sales Managers at our automotive dealership client in Cape Town with a proven track record.Must be able sell 40 - 50...


View Job
New Vehicle Sales Manager – Sell bet. 40 & 50 units

Cape Town: Senior Inbound Consultant posted by Telebest

We are looking for a friendly, energetic and driven individual to complement our vibrant office environment and to handle international inbound tour...


View Job
Senior Inbound Consultant

Cape Town: Copywriter posted by Career Custodians

Job DescriptionAbout usVillage N Life is a leading local Tourism and Hospitality group, committed to delivering excellence and ensuring the last 10 of...

View Job  Johannesburg: Diesel Generator Specialist - Expat oppertunity! Zimbabwe

View Job
Copywriter

Cape Town: Training Coordinator (Hospitality Industry) – Camps Bay posted by Career Custodians

Are you passionate about developing people and creating impactful learning experiences? Do you thrive in fast-paced environments and have a flair for...


View Job
Training Coordinator (Hospitality Industry) – Camps Bay

Cape Town: Incentives Manager – Newlands posted by abc worldwide

Incentives ManagerROLE The main purpose of the Incentive Manager meetings, incentives, conventions, conferences and exhibitions is to manage, grow and...


View Job
Incentives Manager – Newlands

Cape Town: Intermediate to Senior Travel Consultant posted by abc worldwide

Position Travel Consultant Sales Specialist German Spanish Portuguese Location Anywhere in South Africa Hybrid in PretoriaJoburg, otherwise remoteSalary...


View Job
Intermediate to Senior Travel Consultant

Cape Town: Hotel Manager posted by abc worldwide

DivisionCape CadoganBusiness UnitManagementMinimum experienceNot ApplicableCompany primary industryHospitalityJob functional areaManagementJob...


View Job
Hotel Manager

Cape Town: Senior Tour Consultant (Work from Home) posted by People Dimension

IntroductionA well-established Travel and Tour Consultancy is looking for an experienced Senior Tour Consultant to join their dynamic company.Duties amp...


View Job
Senior Tour Consultant (Work from Home)

Blackheath: ACCOUNTING & INVOICING CLERK – Blackheath, Cape Town

ACCOUNTING INVOICING CLERK Blackheath, Cape Town R15 000 R18 000 Per Month Negotiable based on qualification and relevant experience gained Highly...


View Job
ACCOUNTING & INVOICING CLERK – Blackheath, Cape Town

Cape Town City Centre: Hotel Debtors Clerk

The President Hotel is on a journey to be considered luxury. Our purpose is simple yet powerful to create and inspire memorable experiences. Our vision to...


View Job
Hotel Debtors Clerk

Cape Town: Housekeepers posted by Leeu Collection South Africa (Pty) Ltd.

You will excel in this role if you are flexible and able to multitask working at a faster than average speed. Your high level of attention to detail with...


View Job
Housekeepers

Cape Town City Centre: Administrator

Claremont Administrator position available for an experience person in Admin for a Senior Management team Matric Grade 12 Certificate or Diploma...


View Job
Administrator

Cape Town City Centre: Finance Assistant

Responsibilities Assist with daily accounting functions, including capturing invoices, reconciliations, and processing payments. Manage timesheets using our...


View Job
Finance Assistant

Cape Town City Centre: Sales Assistant

Requirements Matric Grade 12 Strong computer literacy with excellent Excel and Word skills Must have a clear criminal record Limited creditdebt issues only...


View Job
Sales Assistant

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