Junior Cost Analyst (Mechanical Engineering)

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

Minimum Requirements:

• Matric (preferably with Mathematics)
• Tertiary qualification in Business, Finance, or a related field will be beneficial
• 3 to 4 Years' experience in a similar role
• Proficient in Microsoft Excel (superuser level) with query writing
• Create complex Excel worksheets and automate Excel workbooks
• Understand and use cross multiplication as well as perform complex calculations
• Able to interpret and understand technical drawings for costing purposes
• Able to understand and translate bill of material for costing purpose
• Technical/mechanical knowledge advantageous
• Experience working with Infor Visual advantageous
• Flexibility to work additional hours when necessary to meet deadlines

Responsibilities:

• Update at least one catalogue costing sheet on a daily basis
• Retrieve drawings from the Drawing Office folder to re-evaluate sheet metal costs across the entire product range
• Validate and revise all coil codes related to the respective range to ensure accuracy in coil prices
• Daily update and maintain weighted averages by capturing new orders from Visual purchase history
• Conduct random cross-checks to verify accuracy
• Assist with updating Excel costing tools for complex calculations upon request
• Regularly maintain and monitor price fluctuations
• Calculate crating and sheet metal costs for the HVAC Department
• Provide analytical support to sales
• Ensure reports are up to date for sales meetings
• Implement automation in Excel workbooks to enhance efficiency in processes
• Assist with special projects upon requests
• Regularly clean, run, and update the sales folder to ensure that prices are consistently current for accurate quoting
• Provide assistance to the Costing Manager by responding to all costing requests via email and addressing various managerial enquiries