Data Analyst

The Legends Agency; Cape Town; On-site; ZAR 300,000 - 450,000; Full time

Job summary

A family-owned manufacturing company in Cape Town seeks a Business and Data Analyst to analyze financial and production data, generating reports to support strategic decisions. Requires strong Excel skills, and 3+ years' experience in data analysis. Join to contribute to impactful work in the South African infrastructure sector.

Benefits

Stable work environment

Opportunities for growth

Purposeful work with industry impact

Qualifications

• Strong Excel proficiency, including VBA.
• Solid grasp of financial statements and accounting principles.
• Experience working with large datasets and optimizing reporting.

Responsibilities

• Generate management reports on specific data.
• Assist with product specs and QA.
• Track daily stock and assist in data analysis.

Skills

Excel proficiency

Financial analysis

Data visualization

Problem-solving skills

Communication skills

Job description

Overview

Cape Town

Do you have a passion for analytics, process improvement, and making a tangible business impact? Join a third-generation, family-owned business with over 60 years of excellence in manufacturing wire products.

We are seeking an experienced Business and Data Analyst to extract, analyze, and transform financial and production data into meaningful reports and tools that drive strategic business decisions. You’ll collaborate with all departments to design, create, maintain and monitor reports and tools.

Why Join?

• Stability & Growth: With over 60 years of history and an average employee tenure exceeding 15 years, the company offers a stable and nurturing environment for your career.
• Purposeful Work: Be part of a company whose products make a tangible difference, securing homes and businesses, supporting infrastructure, and contributing to the development of South Africa and beyond.
• Opportunity to Shape the Future: Play a key role in a business that values innovation, development, and leadership.

Responsibilities

• Generating/setting up management reports on specific data
• Daily Contribution report
• Weekly Management Report
• Electricity tracking
• Ad hoc reporting requirements
• Production Data
• Production History
• Raw material purchase management tool
• Outstanding orders tracking tool
• Stock Take
• Stock take area sheets
• Stock layout
• Calculating the stock tons
• Calculating the stock valuation
• Daily stock tracking tools and templates
• Min/Max levels calculations and tool
• Assistance with product specs and QA
• Stock code and Product class management
• Product type mass calculations
• Wire and product database
• QA Check tools
• Cost modeling
• Product class costing for sales analysis and stock valuation
• Cost modeling of Galvanizing Plant
• Cost modeling of Coater Plant
• Sales team tools
• Sales rep monthly sales tracking
• Quoting Tool
• HR Assistance
• Absenteeism tracking tool
• Timekeeping tool
• 35 years in a data or business analyst role

Qualifications

• Strong Excel proficiency, including VBA
• Solid grasp of financial statements, accounting principles, and data visualization
• Experience working with large datasets, cleaning data, and optimizing reporting
• Excellent problem-solving and communication skills
• Experience: Data/Business Analyst: 3 years (Required)

Job Type: Full-time