Junior Cost Analyst - Excel Automation & Costing Support

AJ Personnel; Gauteng; On-site; ZAR 240,000 - 360,000; Full time

Job summary

AJ Personnel is seeking a costing professional in Gauteng to manage daily costing sheets, extract and interpret drawings for sheet metal costs, and maintain accurate pricing across products. The role requires advanced Excel skills, experience with BOMs, and the ability to automate complex calculations.

Responsibilities include updating costing tools, supporting sales with analytical insights, and ensuring timely, accurate quotes.

Qualifications

• Matric with Mathematics preferred
• 3–4 years experience in a similar costing role
• Proficient in Microsoft Excel at superuser level with query writing
• Experience creating and automating Excel workbooks for costing
• Ability to interpret and translate bill of materials for costing purposes
• Technical/mechanical knowledge is advantageous

Responsibilities

• Update at least one catalogue costing sheet daily
• Retrieve drawings to re-evaluate sheet metal costs
• Validate and revise coil codes for pricing accuracy
• Maintain weighted averages from Visual purchase history
• Assist with updating Excel costing tools for complex calculations
• Regularly monitor price fluctuations and automation in Excel
• Provide analytical support to sales and management
• Ensure quotes and reports are up to date for meetings
• Assist Costing Manager with costing requests via email

Skills

Excel expert

Query writing

Costing analysis

Bill of materials

Analytical mindset

Education

Matric

Business/Finance degree

Tools

Infor Visual

Job description

AJ Personnel is seeking a costing professional in Gauteng to manage daily costing sheets, extract and interpret drawings for sheet metal costs, and maintain accurate pricing across products. The role requires advanced Excel skills, experience with BOMs, and the ability to automate complex calculations.

Responsibilities include updating costing tools, supporting sales with analytical insights, and ensuring timely, accurate quotes.