IT Data Analyst - Supply Chain

This individual will perform a lot of independent work but interact with many groups to identify the items that need addressing. The substitution chains I mention below are often driven by our suppliers when they determine that one part should replace another (i.e. an updated oil filter). There are occasions where we disagree with the proposed links and research needs to be done, and also times when we agree but the links have to be implemented at different times based the need to sell through the older part.

Qualifications: technically minded individual with a strong capacity for dissecting problems within parts substitution chains and executing root cause recovery models to improve the customers' ability to get the right part for servicing their car
o Requirements: 2+ years of experience with parts from a technical perspective, automotive retail, and/or process development
o Computer skills: strong experience in MS Office especially excel, capable of navigating proprietary and main-frame based applications
o Education requirements: minimum of an associate's degree, ideally with a focus on logistics, transportation, and/or automotive

Primary Purpose of Job:
Coordinate spare parts information for all vehicles supported by MBUSA. Provide internal customers (DPS, SCM, Engineering, Warranty, Marketing, etc.) and dealers with parts expertise, information and analysis not available through other channels or tools. Coordinate interdepartmental parts processes. Ensure the accuracy of Electronic Parts Catalog (EPC) data.
Responsibilities:
• Frequency Daily / Monthly % of Time Assist PAC and other MBUSA departments by determining the correct spare part for a specific application when that information is not available in regular tools (e.g., EPC). Research and analyze the data from the production sequencing systems, factory purchasing records, engineering drawings, consult with the vendor, and utilize other conventional and non-conventional tools. Ensure accuracy of MBUSA Parts supersession chains.
• Check new part numbers for technical accuracy and applicability to USA models. Review new model and major face-lift parts lists from Germany for technical accuracy and applicability to USA models. Extract minor face lift and model year change parts lists from relevant systems and review for technical accuracy and applicability to USA models.
• Support development of and deliver educational materials for dealers concerning the best practices for utilizing existing tools to obtain accurate and timely parts information. Report current inquiry trends and work with team to develop new tools as necessary to resolve current and anticipated issues. Support various MBUSA departments by creating special parts information, listings and kits.
• Serve as the technical authority on spare parts. Provide advice and recommendations to other MBUSA departments, MBUSI, and DAG as a consultant on market-specific tactical and strategic parts issues.
• Assist in the processing of parts orders requiring special handling, such as orders for new engines or transmissions, to ensure the usage of these high-value or low availability parts meet policy guidelines.
• Maintain the accuracy and effectiveness of the Electronic Parts Catalog (EPC) and serve as customer advocate by assisting in the development and shaping of the direction of the EPC application for the market, and ensuring new features are implemented in a timely fashion. Review error reports and other information, confirming issues, issuing correction notes to dealers and other customers, and advising responsible areas of the need for corrections. Serve as customer advocate by supporting the strategic direction of the EPC application for the market and ensuring new features are implemented in a timely fashion. Liaison with IT as the business unit to ensure system availability and performance meet market needs. Analyze the results of dealer surveys to develop corrective action plans and new feature requirements.
• Assist in the development and delivery of educational materials for dealers concerning the best practices for utilizing existing tools to obtain accurate and timely parts information. Review current inquiry trends and develop new tools as necessary to resolve current and anticipated issues. Support Parts & Service Marketing and other departments by creating special parts information, listings and kits. Assist in the regular training of new Parts Technical Analysts and Dealer Parts Services agents.
Requirements & Conditions:
• Must be able to work flexible hours/work schedule
• Travel domestically
• Work Holidays when required
• Work weekends when required
Education Requirements:
• Associate's Degree (accredited school) or equivalent work experience with emphasis in: Technical Management-Logistics Transportation Management
Knowledge/Skills Required: (necessary to perform proficiently in this position)
Must have 2+ years (total) of experience in the following:
• Administration Proficient Knowledge of administrative procedures, process/project development, and system procedures.
• Automotive-Retail Proficient Knowledge of retail processes and procedures, with emphasis in New and Pre-owned sales, accessories, service and parts.
• Automotive - Technical Knowledge of automotive technical information systems and repair/diagnostic procedures.
• Parts and Accessories Comprehensive Knowledge of parts and accessories businesses, marketing strategies and other business practices.
• Processing General Knowledge of processes, quality control, costs, and other techniques in order to achieve maximum efficiency.
• Vendor Management General Knowledge of Agency/Vendor management and budget management.
Core Behaviors:
• Sees the "big picture" and thus understands relevant interrelationships. Participates actively in the development of a realistic strategy which ensures the long-term sustainability of the organization. Acts responsibly towards community, environment and key stakeholders.
• Anticipates and addresses needs of customers and business partners. Focuses on customer benefit. Understands the global industry and competitive landscape and recognizes the implications for the organization. Builds and maintains strong relationships with key contacts outside the organization
• Encourages innovation, creativity and "out-of-the-box" thinking. Perceives and capitalizes on trends relevant to own area of business. Uses effective strategies and methods to achieve the necessary change. Engages other relevant partners and wins their commitment. Cuts through ambiguity and paradoxes to speed up implementation.
• Sets high standards and achievable goals for oneself. Contributes to a bond of excitement, pride and inspiration. Demonstrates a high level of performance and inspires others to similar achievement through own dedication. Gives constructive feedback. Recognizes the abilities of colleagues and supports them.
• Cooperates closely and shares best practices across regions, divisions and functions. Demonstrates and supports an environment of "lessons learned" and continuous performance improvement. Places company interests above departmental interests. Contributes to an atmosphere of team spirit and common responsibility for results. Actively promotes an inclusive environment and capitalizes on diversity.
• Ability to collect data and establish facts and identify trends and variances
• Ability to integrate information from a variety of sources with varied levels of complexity
• Ability to review and interpret and evaluate statistical information
• Ability to incorporate new technology into current and future business applications
• Ability to develop plans/projects from conceptualization to implementation
• Ability to organize workflow and direct tasks as well as document milestones and ROI's and resolve problems
• Strong proficiency with a computer, using Windows, proprietary, and mainframe-based applications
• Highly organized work habits and computer literate
• The ability to understand complex queries and instructions
• The ability to work independently and set priorities on complex and highly technical tasks, using expertise gained through education and experience, while producing results with very high accuracy A proficient understanding of Dealer service operations and repair methods.
The fully trained individual must develop and maintain comprehensive knowledge of:
• Departmental practices/procedures and how they apply to customers
• Interdepartmental relationships and their effect on company, departmental and individual goals
• Software that is applicable to the job Comprehensive working knowledge and expertise with Mercedes-Benz parts catalogs and EPC, and the DAG part numbering system
• Knowledge of basic aspects of finance, leading to understanding the application to all aspects of MBUSA's spare parts and accessories business
• An understanding of basic automotive technology is required, as the trained individual must develop a complete understanding of automotive technology used in Mercedes-Benz vehicles from at least the past 25 years, and the ability to identify specific technologies and their proper operation
• An understanding of the MBUSA vehicle model line offered in the USA for at least the past 25 years, including available equipment, model naming, sales designation, and Baumuster systems

Required Skills : Supply Chain,ETL

Basic Qualification :

Additional Skills : Analyst,Database Developer

Background Check : No


Drug Screen : No