Schaeffler, a global automotive and industrial supplier, is seeking an "Excel Expert" to fill the position of Internal Sales Analyst in Valley City, Ohio, located 20 miles southwest of Cleveland.
The ideal candidate will have extensive training and strong competence in the major functionalities of Microsoft Excel, including but not limited to Conditional Formulas, PivotTables, and Array Functions. This role will require the candidate to work within multiple business systems, including Microsoft Office, SAP, and multiple data warehouses. A candidate must have the ability to handle multiple tasks in a fast-paced deadline oriented environment. They must also have the ability to interface with all levels of management and will possess the ability to problem solve and support the continuous improvement of the pricing processes.
In coordination with other departments, this position is responsible for the administration and analysis of all the pricing activities as needed for the Automotive Aftermarket location. Tasks include, but are not limited to the daily operational maintenance of all pricing in various systems, communication of all pricing updates internally and externally, statistical analysis of cost/price impacts and similar statistical analyses in support of proposals and quotations.
Key responsibilities include but not limited to:
Critical tasks for this role:
•Customer Price sheet creation and maintenance
•Business System price updates
•Establish and Maintain Customer Master data, including pricing.
•Issuance of all approved customer credits and debits
Additional tasks include:
•Creation and distribution of customized sales reports to internal and external customers
•Analyze customer sales performance compared to budget
•Processing of approved customer discrepancies
•Analyze Customer fill rates and delivery performance
•Forecast analysis in comparison to actual orders placed
•Sales Forecasting system updates (BPS Planning Tool)
•Communicate and correspond with customers in a clear and professional manner
•Analyze and respond to customer inquiries, requests, forecasts, etc…as appropriate
•Creation and maintenance confidential Customer Terms and Conditions
•Customer Setup and maintenance
•Reconcile and maintain sales figures for warranty credits, co-op and all other customer rebates (monthly, quarterly, and annual rebates)
•Four year college degree or equivalent experience •Minimum 3 Years related experience preferred •Strong verbal and written communication skills •Strong MS Office proficiency and an Excel expert •Ability to interface effectively with other departments in a professional manner •Ability to multi-task with accuracy and effectiveness
Schaeffler is an Equal Opportunity Employer/Minorities/Females/Disabled/Veterans
Job Function Customer Service/Support
Primary Location United States-Ohio-Valley City
Job Posting Apr 25, 2018, 12:54:02 PM
Unposting Date May 25, 2018, 11:59:00 PM
Internal Number: 11854
About Schaeffler Group
Schaeffler, a global automotive and industrial supplier, is seeking a qualified, dedicated individuals to support Schaeffler Automotive Aftermarket's location in Valley City, Ohio, 20 miles southwest of Cleveland.