Consolidations & Reporting Analyst

Stellantis; Auburn Hills (MI); On-site; USD 120,000 - 180,000; Full time

Job summary

Stellantis is seeking a senior finance professional in Auburn Hills, MI, to lead month-end reporting, consolidation, and forecasting activities within the Purchasing/FP&A domain.

The role requires strong expertise in SAP and OneStream, plus a track record of delivering accurate financial analyses and management reports to senior leadership. You will collaborate across functions to improve processes and ensure timely financial closes.

Qualifications

• Bachelor's degree in Accounting/Finance or MBA if not accounting/finance
• Minimum of 8 years of professional finance experience
• Minimum of 5 years in budgeting and forecasting
• Strong PC skills including Word, Excel and PowerPoint
• Working knowledge of SAP and OneStream
• Ability to work under pressure in a time constrained environment
• Strong communication and presentation skills to leadership groups

Responsibilities

• Prepare month-end reporting materials and sign-off for Senior Leadership
• Consolidate OneStream reconciliations for purchasing accounts with timely sign-off
• Manage PPO line item including accruals and reconciliations
• Assist with general ledger analysis and month-end JVs
• Coordinate with Commercial Savings and Commodity Controllers for revenue recording
• Develop reports and financial analyses for data-driven decisions
• Lead cross-functional process improvements in consolidation activities
• Support Consolidation Manager with ad hoc reports and projects
• Deliver written and oral briefings to Senior Leadership
• Provide ad-hoc management reports as needed
• Understand Purchasing role and performance metrics such as Incremental, PYA, Flow Through
• Involve in Forecasting, budgeting, planning, accounting close

Skills

Budgeting

Forecasting

Financial analysis

Presentation skills

Communication

Education

Bachelor's degree in Accounting/Finance or related field

MBA preferred

Tools

SAP

OneStream

Excel

PowerPoint

Job description

Responsibilities

• Responsible for month-end reporting materials, including preparation, review and management sign-off (Senior Leadership Reporting Materials, Trend Analysis, JV Checklist and quarterly Out of Period adjustments)
• Consolidation of Onestream reconciliation summary for all purchasing finance accounts; ensure timely sign-off by management for all key and non-key accounts
• Manage the Purchase Price Other (PPO) line item, which includes preparing accruals, account reconciliation as well as a monthly deep dive analysis of all financial activity
• Assist with general ledger analysis and prepare month-end JV's as required
• Work with the Commercial Savings team and Commodity Controllers to ensure proper accounting between short term and long term as well as proper recording and reconciliation of Deferred Revenues
• Understand customer needs for data analysis, develop and provide pertinent, easy to understand reports and financial analysis
• Lead cross functional process improvement recommendations for continuous enhancement in the areas of efficiency and accuracy for all related Financial Consolidation activities
• Assist the Consolidation Manager with Ad hoc reports and special projects as required
• Perform written and oral communication/presentations to Senior Level Management
• Provide ad-hoc reporting as needed for all levels of management
• Understand the role of Purchasing at Stellantis and how Purchasing performance is measured including: Incremental, PYA, Flow Through, Year over Year, Net Off Standard, Reclass, PCS Controls
• Forecasting, budgeting, business planning, accounting close

Basic Qualifications

• Bachelor's degree in Accounting/Finance or related field OR Master's degree in Business Administration (MBA), Finance or Accounting (if undergraduate degree not Accounting/Finance)
• Minimum of 8 years of professional finance experience
• Minimum of 5 years' experience specifically in budgeting and forecasting
• Strong personal computer skills including Word, Excel and PowerPoint
• Working knowledge of SAP and OneStream
• Ability to work under pressure and in a time constrained environment
• Strong communication and presentation skills to various leadership groups

Preferred Qualifications

• Knowledge of accounting including JVs, month-end close
• Excellent accounting, analytical and teamwork skills
• Problem solving and ability to multitask
• Variance Analysis & Period-to-Period Reporting
• Forecasting, Budgeting, Business Planning, Accounting Close
• Interactions with Purchasing Operations and FP&A

At Stellantis, we assess candidates based on qualifications, merit, and business needs. We welcome applications from all people without regard to sex, age, ethnicity, nationality, religion, sexual orientation, disability, or any characteristic protected by law. We believe that diverse teams reflect our identity as a global company, enabling us to better address the evolving needs of our customers and care for our future.