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 thirdgeneration familyowned 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
- Sales Team Sales tracking
- 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
- Pricing Master Database
- HR Assistance
- Absenteeism tracking tool
- Timekeeping tool
Competencies
- 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 problemsolving and communication skills
Qualification:
Bachelors degree
Job Type: Fulltime
Experience:
- Data/Business Analyst: 3 years (Required)
Language: