Data Analyst

The Legends Agency; Cape Town; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading manufacturing company is seeking a Business and Data Analyst in Cape Town. In this full-time role, you will analyze key data to drive strategic decisions, working closely with various departments to enhance reports and tools, ensuring meaningful insights for business growth.

Benefits

Stable work environment

Opportunity for growth and innovation

Qualifications

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

Responsibilities

• Generate and set up management reports for various data.
• Collaborate across departments to improve data tools.
• Assist with product specifications and QA.

Skills

Excel proficiency

Data analysis

Problem-solving

Communication skills

Job description

BUSINESS and DATA AND BUSINESS ANALYST MANUFACTURING

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. Youll 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 differencesecuring 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.

Key tasks

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

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

Job Type: Full-time

Experience:

• Data/Business Analyst: 3 years (Required)