FP&A Consolidation – GPSC Finance Analyst

GM•Warren, MI

2d•Hybrid

About The Position

This role is responsible for preparing and performing key monthly data integrity checks, developing and implementing timelines for data input, monitoring monthly processes, troubleshooting data errors, and running/analyzing reports for stakeholders. The analyst will also submit GPSC performance, support allocation methodologies, and collaborate with team members on presentation materials. Additionally, the role involves supporting FP&A forecast reviews, answering leadership questions on material cost performance, developing monthly GPSC MoR reviews, and supporting budget and LTP material development. The position requires preparing and performing monthly data integrity checks, determining budget deadlines, monitoring budget processes, running system calculations, and documenting/reporting system errors during the budget cycle. The analyst will also develop and maintain the Material Over and Under account forecast, understand actuals' impact on the material cost forecast, and summarize cost drivers for the Material Over and Under account balance. This is a hybrid role requiring 3 days in-office and 2 days remote, with the ability 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
Six (6) years of experience with Supply Chain and Procurement
Four (4) years of experience with cost accounting principles
Four (4) years of experience with 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 (GM Material Reporting System) timelines for successful data input of actuals & forecast consolidation.
Determine 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 by data feeders.
Run various system calculations after key due dates to prepare the system for data processing and meet monthly process milestones.
Troubleshoot data errors.
Run and analyze various reports for stakeholders, including regional and corporate, data bridges, and data reconciliations.
Document and report system and process errors during the monthly cycle 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, ensuring data ties to leadership dashboards.
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.
Support answering 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 Monthly Operating Review with senior leaders match functional analysis.
Support the development of budget and LTP (Long-Term Plan) 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 by data feeders.
Run various system calculations after key due dates to prepare the system for data processing and meet budget process milestones.
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.