Consolidations & Reporting Analyst

Peugeot Sport (Stellantis Motorsport); Auburn Hills (MI); On-site; USD 110,000 - 165,000; Full time

Benefits offered by this job

Company vehicle lease program

Tuition reimbursement

Volunteer hours

Job summary

Peugeot Sport (Stellantis Motorsport) in Auburn Hills, MI is seeking an experienced Senior Finance Manager to lead month-end close, consolidate Onestream reconciliations, and drive financial reporting for purchasing and FP&A functions.

You will collaborate with leadership to deliver accurate budgeting, forecasting, and ad-hoc analyses, ensuring control, accuracy, and alignment with core Stellantis metrics and vehicle programs.

Qualifications

• Bachelor's degree in Accounting/Finance or related field OR MBA (if undergrad is not Accounting/Finance).
• Minimum of 8 years of professional finance experience.
• Minimum of 5 years' experience in budgeting and forecasting.

Responsibilities

• Prepare, review and sign-off month-end reporting materials for Senior Leadership.
• Consolidate OneStream reconciliation for purchasing accounts with timely management sign-off.
• Manage PPO line items, accruals, reconciliations, and monthly deep-dive analyses.
• Perform GL analysis and prepare month-end JVs as required.
• Coordinate with Commercial Savings team for proper revenue recording and reconciliation.
• Develop data-driven reports and analyses for stakeholders.
• Lead cross-functional process improvements for consolidation activities.
• Support the Consolidation Manager with ad hoc reports and projects.
• Present conclusions to Senior Level Management and provide ad-hoc reporting.

Skills

Communication skills

Presentation skills

Analytical thinking

Attention to detail

Time management

Education

Bachelor's or MBA in Accounting/Finance

Tools

SAP

OneStream

Job description

This Position Is Responsible

• 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

This Position Is Responsible

• 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

Our Benefits — Designed With You In Mind

Comprehensive Health & Well-being Coverage

From your very first day, you’ll have access to medical, dental, vision, and prescription drug coverage — ensuring you and your family stay healthy and protected. Also, our Employee Assistance Program (EAP) offers confidential support for personal and professional challenges, always ready when you need it.

Family Building Benefit

We proudly support all paths to parenthood- including fertility and infertility treatments, adoption services, and gestational surrogacy.

Generous Paid Time Off

We believe in work-life balance. That’s why we offer: 17+ paid holidays, including shut-down from December 24th through New Years Day every year. Vacation, float & wellbeing days, sick time and fully paid parental leave when your family needs you most.

Competitive Retirement Savings Plans

We Help You Plan For The Future With

• An employer match on contributions to your 401k, Roth, and Catch-Up plans
• An employer contribution, even if you don’t contribute

Income Protection & Insurance Options

Benefit from both employer-provided and voluntary plan offerings, including life insurance, group accident, critical illness, etc. - supporting the needs of you and your family and ensuring peace of mind.

Company Vehicle Lease Program

Eligible employees and their immediate families can participate in the company vehicle lease program, providing access to Stellantis vehicles with insurance, maintenance, and unlimited miles included. Plus, take advantage of exclusive discounts on Stellantis products.

Support for Your Growth and Giving Back

• Tuition reimbursement
• Student loan refinancing programs
• 18 paid volunteer hours each year to make a difference in your community

And so much more!

When you join us, you’re not just building a career — you’re joining a company that supports you, inside and outside of work.

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.