Job Location : East Peoria,IL, USA
The primary function of this role will be the optimization of the profitability of service parts. The duties of this role will entail the analysis of the gross margin of service parts families to identify and prioritize opportunities to improve profit margins through cost reduction and/or price realization actions. Such projects will require the role to coordinate with engineering and purchasing to identify value/cost drivers, coordinate through third party consultants the collection of market-based component pricing data, and collaborate with the Parts Pricing team to enact recommended changes to service parts pricing. The role will also be responsible for providing monthly summary reports of the service parts portfolio financial results, including gross revenue, gross profit and status of margin improvement projects. Required Technical Skills: Microsoft Office 365 suite of applications (must have strong Excel skills, including pivot tables) Power-BI (dashboard creation) General business acumen Familiarity with mechanical drivetrain components is desired Desired Soft Skills: Organized and process-oriented approach to completing tasks Ability to summarize and present findings of analysis in a clear, concise manner Required Skills : Top requirements: 3+ years of experience with data/financial analysis, excel (pivot tables, v lookups), and Bachelor's degree degree in business management, economics, finance, accounting, engineering or relevant field Basic Qualification : Top requirements: 3+ years of experience with data/financial analysis, excel (pivot tables, v lookups), and Bachelor's degree degree in business management, economics, finance, accounting, engineering or relevant field Additional Skills : Top requirements: 3+ years of experience with data/financial analysis, excel (pivot tables, v lookups), and Bachelor's degree degree in business management, economics, finance, accounting, engineering or relevant field Background Check :Yes Notes : Selling points for candidate : Project Verification Info : Candidate must be your W2 Employee :No Exclusive to Apex :No Face to face interview required :No Candidate must be local :Yes Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project :Administration/Support Master Job Title :Data Analyst Branch Code :Bloomington