Cost Engineer

We are seeking a Cost Engineer with expertise in Customer Portal Management and Microsoft Excel skills. The ideal candidate will be responsible for managing the customer portal and maintaining accurate cost data. This role requires a highly organized individual with strong written and verbal communication skills in English, capable of collaborating with cross-functional teams with cost projections and optimizing the ongoing projects through data analysis.

Key Responsibilities

Customer Portal Management
1. Administer and maintain the customer portal, ensuring all data related to parts, materials, and customer quotes are secure, functional, and user-friendly.
2. Translate the internal Master quote into multiple customer-specific forms, each with its own unique method for calculating the final price.
3. Input and update new quotes, including material and scrap rates, ensuring accuracy and timeliness.
Material Content Breakdown Forms (MCBFs)
1. Create and maintain Material Content Breakdown Forms (MCBFs), detailing material data such as weight, size, and other specifications for individual parts.
2. Collect and input all necessary material information into MCBFs to facilitate requests for material price quotations.
Excel Analysis
1. Use advanced Microsoft Excel to analyze data, compare multiple sheets, and perform detailed cost analysis (e.g., VLOOKUP, PivotTables, complex formulas).
Cost Estimation and Control
1. Collaborate with engineering, quality, and project management teams to gather accurate cost data and develop cost estimates.
2. Compare actual costs to budgeted costs, perform variance analysis, and recommend corrective actions to stay within budget.
3. Monitor project financials and assist in cost forecasting using Excel to identify potential cost overruns or savings.
Continuous Improvement
1. Regularly update and improve Excel-based reporting tools to increase efficiency, reduce errors, and improve decision-making.
2. Assist in the development and implementation of best practices for cost and data management processes.
Reporting and Documentation
1. Provide regular forecast reports to management from the portal.
2. Maintain accurate documentation and records for cost-related files, ensuring they are easily accessible and up to date.

Qualifications and Requirements

Education: Bachelor’s degree in Engineering, Finance, or a related field.
Experience: 0 to 2 years of experience in engineering, data management, or finance.
Technical Skills: Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP, INDEX/MATCH, data comparison, macros, and report automation).
Problem-Solving and Analytical Skills: Strong ability to analyze data, perform cost comparisons, identify trends, and propose effective solutions for cost forecasting and control, while maintaining a keen attention to detail.
Communication and Teamwork: Strong written and verbal communication skills in English to create reports and collaborate with cross-functional teams, with the ability to convey technical information clearly and interact effectively at all organizational levels.

Additional Information:

Working Hours: 5:00 PM to 2:00 AM (Monday to Friday) to support our North American-based clients.
Salary: Rs. 50,000 to Rs. 60,000 per month.
Application Deadline: 30th November 2024.