FP&A Consolidation – GPSC Finance Analyst

General Motors•Warren, MI

2d•Hybrid

About The Position

The FP&A Consolidation – GPSC Finance Analyst role is responsible for preparing and performing key monthly data integrity checks to ensure the completeness and accuracy of data for actuals and forecast consolidation. This role involves developing and implementing timelines for the GM Material Reporting System (GMRS), monitoring the monthly close cycle, and troubleshooting data errors. The analyst will run and analyze various reports for stakeholders, document system and process errors, and support the allocation methodology for GPSC performance. Additionally, the role involves providing performance variance analysis, collaborating on presentation materials, supporting forecast reviews, and assisting with budget and Long-Term Plan (LTP) development. The position requires understanding actuals and their impact on the material cost forecast, summarizing cost drivers, and maintaining the Material Over and Under account forecast. This is a hybrid role requiring 3 days in-office and 2 days remote, with the expectation to report to the local office.

Requirements

Bachelor’s degree in Finance, Accounting, International Commerce, or related field of study.
Eight (8) years of experience as a Financial Analyst or related role.
Eight (8) years of experience with managerial reporting including KPIs, dashboards and product line profitability reporting.
Six (6) years of experience with FP&A skills including budgets, forecasts, and product cost run rates variance analysis and Supply Chain and Procurement.
Four (4) years of experience with cost accounting principles, SAP navigation and T-Codes.
Four (4) years of experience with Procurement processes and procedures.
Three (3) years of experience with basic accounting principles.
Three (3) years of experience with local vs global bills of material.
Three (3) years of experience with inter-company profit.
Two (2) years of experience with Hyperion navigation and structure.

Responsibilities

Prepare and perform key monthly data integrity checks to ensure data completeness and accuracy.
Develop and implement GMRS timelines for successful data input for actuals & forecast consolidation.
Determine and communicate deadlines for key inputs to ensure the monthly close cycle runs on time.
Monitor and manage the monthly process to ensure system deadlines are met.
Run various system calculations after key due dates to prepare the system for subsequent processes.
Troubleshoot data errors.
Run and analyze various reports for regional and corporate stakeholders, including data bridges and reconciliations.
Document and report system and process errors to ensure root cause determination and corrective actions.
Submit GPSC performance by vehicle line and support the allocation methodology.
Determine calculation correctness and exclude irrelevant contracts.
Run the process to allocate performance to the vehicle cost forecast.
Check allocations for reasonableness, finalize, and archive the system.
Run system calculations and deliver bridge data to Regional & Corp FP&A teams.
Provide actual month performance forecast variance, YoY performance, and budget performance variances to the material cost analyst.
Ensure data ties to dashboards presented to leadership.
Collaborate with team members to develop presentation materials for key meetings.
Work closely with peers on presentations to ensure performance metrics tie out.
Support monthly GMNA FP&A and CFP&A forecast reviews.
Answer questions from regional and corporate leadership on material cost performance, including research and analysis of prior periods.
Develop monthly GPSC MoR reviews and supporting material.
Ensure materials for the Monthly Operating Review with senior leaders match functional analysis.
Support the development of budget and LTP material for leadership forums.
Take key performance inputs from the LTP model and prepare the load template into the LTP consolidation system.
Assist in preparing presentation materials for LTP results.
Determine budget deadlines for key inputs to ensure the monthly close cycle runs on time.
Monitor and manage the budget process to ensure system deadlines are met.
Document and report system and process errors during the budget cycle to ensure root cause determination and corrective actions.
Develop and maintain the Material Over and Under account forecast.
Understand actuals and their impact on the overall material cost forecast.
Summarize and understand the cost drivers for the Material Over and Under account balance.