Hybrid Inventory Reconciliation Analyst — Data-Driven

USA GPC Genuine Parts Company; United States; Hybrid; USD 65,000 - 90,000; Full time

Job summary

GPC Genuine Parts Company is seeking an Inventory Controls Analyst to support the Finance Department in enhancing the monthly inventory reconciliation process and related initiatives. You will enforce reconciliation policies, collaborate with NAPA Finance and Supply Chain teams, and drive accurate data-driven insights.

The role requires a Bachelor’s degree in analytics/finance, 1+ year in business analysis, and strong PowerBI/Excel skills to identify trends, summarize results, and propose

Qualifications

• Bachelor's degree in business analytics with a concentration in Finance preferred.
• Minimum 1 year of experience with business analysis and reporting.
• Proficiency using Microsoft PowerBI and Excel Power Query, PowerPivot.
• Strong verbal skills and written communication skills with demonstrated ability to communicate complex topics to a variety of experience level.
• Team player; demonstrate success working well with department leaders and peers.
• Must be able to understand, explain, and solve complex problems.
• Must be technologically astute at learning new business technologies.
• Strong detail orientation and organization.
• Ability to manage time effectively, multi-task, prioritize, and work well under tight timelines.

Responsibilities

• Create inventory reconciliation events as needed to meet control requirements and established business practices.
• Execute the review and reconciliation of the physical inventory records and inventory ledger on a monthly schedule, and additionally as needed.
• Complete data review for reasonableness.
• Identify data trends for changes in business activity impacting inventory.
• Review inventory investment for non-contributing inventory.
• Collect and enter in-transit data for compilation.
• Compile inventory reconciliation results and investigate any material variance between the ledger and physical inventory.
• Validate the accuracy of results.
• Summarize analysis of review and results investigation into actionable items for the business.
• Detail specific inventory or ledger items that need to be addressed or reviewed by the business.
• Routinely communicate reconciliation results to key NAPA Finance and Supply Chain partners.
• Identify locations with results outside of variance thresholds and report out to NAPA Finance and Supply Chain leaders.
• Meet with the local business to review the reconciliation results and recap recommendations on areas the business can develop action plans to mitigate shrink or improve process related to inventory.
• Review the trends in the analytics for year to date and month over month to demonstrate the directional impact to the business.

Skills

PowerBI

Excel Power Query

PowerPivot

Communication skills

Time management

Education

Bachelor's degree in business analytics with finance concentration

Tools

JDE

PeopleSoft Financials

Power Query / Data Modeling

Power BI

Microsoft Dynamics D365

Job description

GPC Genuine Parts Company is seeking an Inventory Controls Analyst to support the Finance Department in enhancing the monthly inventory reconciliation process and related initiatives. You will enforce reconciliation policies, collaborate with NAPA Finance and Supply Chain teams, and drive accurate data-driven insights.

The role requires a Bachelor’s degree in analytics/finance, 1+ year in business analysis, and strong PowerBI/Excel skills to identify trends, summarize results, and propose