IT - Master Data Specialist

Standard Motor Products, Inc.•Lewisville, TX

23d

About The Position

Established in 1919 and traded on the NYSE, Standard Motor Products, Inc. (SMP) is a leading independent manufacturer and distributor of premium automotive replacement parts utilized in the maintenance, repair, and service of vehicles in the automotive aftermarket. Additionally, SMP provides customized solutions for vehicle control and thermal management products in diversified end markets represented by its Engineered Solutions segment. Globally, SMP employs over 6,000 employees across nearly 40 manufacturing, distribution, and engineering facilities and offices located in North America, Europe and Asia. SMP sells its products primarily to automotive aftermarket retailers, program distribution groups, warehouse distributors, original equipment manufacturers, and original equipment service part operations in the United States, Canada, Europe, Asia, Mexico, and other Latin American countries. General Responsibilities: Supports, maintains, and provides oversight on all master data activities as they relate to corporate IT business systems including but not limited to ERP, MRP, WMS, EDI, BI, & Web Serves as one of the points of contact to internal customers for all master data related to business systems and applications Creates and maintains Item Master and Item Branch fields both manually and systematically, using the various upload processes. Creates and maintains Bills of Materials and corresponding Routings, both manually and systematically, using the various upload processes Creates and maintains foundational UDC master data and all supplemental master data related to IT business systems Processes required steps towards the completion of established standard operating procedures including but not limited to PTO/LTO/PTS movement, EPOs, ECNs, PCNs and SCRs Oversees purchasing, planning, and customer service data fields using integrity reports, in an effort to maintain ERP and sales order effectiveness Collaborates with marketing on any support required for the maintenance on marketing master data (ACES, PIES, Digital Assets, and other rich content) Examines and audits data for discrepancies, corrects errors, and reconciles data to ensure accuracy at various stages of data processing. Ensures completeness and conformity with established policies and procedures. Identifies master data inconsistencies across business units and facilities and recommends standardization Identifies and resolves production and/or applications development problems related to product data management Serves as the project manager and coordinates the utilization of all IT resources for all data-related application development lifecycle activities Composes and maintains project plans for all master data related projects Conducts and manages all testing activities for all master data related application development lifecycle activities Provides training and/or assistance to other Users relative to product data management Maintain all required corporate IT SOX compliance documentation for master data activities

Requirements

Strong organizational skills with attention to details
Demonstrated proficiency in analyzing business processes, understanding business needs, and providing technical solutions to specific business challenges as they relate to master data management
Thorough knowledge of how master data impacts all major business functional areas (Finance, Supply Chain, Operations, Sales, Marketing, Pricing, HR, and IT)
3 – 5 years working for a company in the manufacturing and distribution space
Experience working with a tier 1 ERP system (Oracle, SAP, or JD Edwards). JD Edwards preferred
Experience with mass data maintenance tools and strategies
Ability to conduct testing and training activities on business applications related to master data
Demonstrated ability to work on multiple projects against strict deadlines
Ability to understand business concepts and processes at both the macro and micro levels
Strong verbal and written communication skills
Ability to work independently and as part of a team
Ability to use Office products (Excel, Word, Power Point, Access, Project, Visio)
Ability to establish and maintain positive relationships with non-IT/Data Management personnel at all levels in the business

Nice To Haves

Experience with structured query language (SQL) through query writing and/or ad hoc reporting is a plus
Bachelor’s degree preferred but not required
Specific work experience considered

Responsibilities

Supports, maintains, and provides oversight on all master data activities as they relate to corporate IT business systems including but not limited to ERP, MRP, WMS, EDI, BI, & Web
Serves as one of the points of contact to internal customers for all master data related to business systems and applications
Creates and maintains Item Master and Item Branch fields both manually and systematically, using the various upload processes.
Creates and maintains Bills of Materials and corresponding Routings, both manually and systematically, using the various upload processes
Creates and maintains foundational UDC master data and all supplemental master data related to IT business systems
Processes required steps towards the completion of established standard operating procedures including but not limited to PTO/LTO/PTS movement, EPOs, ECNs, PCNs and SCRs
Oversees purchasing, planning, and customer service data fields using integrity reports, in an effort to maintain ERP and sales order effectiveness
Collaborates with marketing on any support required for the maintenance on marketing master data (ACES, PIES, Digital Assets, and other rich content)
Examines and audits data for discrepancies, corrects errors, and reconciles data to ensure accuracy at various stages of data processing. Ensures completeness and conformity with established policies and procedures.
Identifies master data inconsistencies across business units and facilities and recommends standardization
Identifies and resolves production and/or applications development problems related to product data management
Serves as the project manager and coordinates the utilization of all IT resources for all data-related application development lifecycle activities
Composes and maintains project plans for all master data related projects
Conducts and manages all testing activities for all master data related application development lifecycle activities
Provides training and/or assistance to other Users relative to product data management
Maintain all required corporate IT SOX compliance documentation for master data activities