Project Finance Coordinator

SUMMARY

Provides controlling assistance and support to the Controller/Project Manager/Director/Vice President. This position will interface with the project management department, estimating department, supply chain department, and accounting department to setup the project workbooks and support files, follow engineering change cost tracking and track invoicing status.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

• Work with the controlling/ accounting department to acquire the respective job costs in terms of material, labor, and expense from the internal job tracking system and format this information in a manner that can be quickly analyzed by the Project Manager.
• Work with the Project Managers, Business directors, and Controller to establish a work breakdown structure, ensuring the correct sell price and budget, including all engineering change notices (ECN's), are updated in the internal job tracking system and project performance report.
• Track missing customer purchase orders and notify accounting when to invoice the customer and follow up with the customer to ensure timely payment of invoices.
• Timely monitoring of ECN's being correctly loaded into the ONE11 workbook.
• Interface with the Project Manager to review the appropriate "Cost to Go" values for each cost category.
• Create and update project cashflow forecast and customer invoicing forecast based on the latest project information, including change orders and project timeline changes.
• Review the following ONE11 workbook updates to ensure correct results. "Cost to Go" evaluation, Cost for Labor and material spent vs. progress, Approved ECN's are loaded and reflected in budget/ sell price. Verify sell price queries in ONE11.
• Interface with the Estimating department for budget worksheets for ECN's and new projects. Obtain Estimate Sheets for ECN's and Baseline quotes and prepare them to be incorporated into budgets by reviewing content, assigning Job Tree subcodes, by reviewing sell prices, and obtaining target margins, risk factors, and PM and Engineering reserves from Director/Vice President.
• Update and maintain project summary book for bi-weekly review meetings with following print outs: Budget Variance Report, Margin Variance Report, Rate Table Report with Sell Price Risk Report, Detailed Sell Price Report
• Support Project Manager when required to maintain or make changes to Job Tree, Schedule, ECN Log to ensure accurate tracking and timely closure of said items.
• Update Project Management reserve account matrix for bi-weekly review meeting.
• Provide bi-weekly updated data for department measurable charts.
• Prepare summary of potential invoicing on a weekly basis.
• Generate a job summary report of all projects in process in the business unit, on a bi-weekly basis that will be used by the respective Director and Vice President to make any required economical and strategic business adjustments.
• Support internal and external audits by providing supporting documents including approved quotation, budget, customer purchase order, customer invoice, customer buy-off and project close out document.
• Work on various departmental improvements such as: Internal cost analysis and reporting, Project risk analysis and Project Management Tools.

EDUCATION AND/OR EXPERIENCE

Bachelor's degree (B.A.) or equivalent from an Accounting/ Business college; or equivalent combination of education and experience.

KUKA is an Equal Opportunity Employer committed to building an inclusive and diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other factor protected by applicable federal, state or local laws.