Data Management Specialist (Customer Information Analysis) - Avendra
The Data Management Specialist for Customer Information Analysis (CIA) is responsible for completing Customer and Supplier matching client provided data. The Specialist ensures accuracy, categorization, and data integrity are maintained. The Specialist will ensure the matching requests are completed timely and accurately. The specialist will also utilize CIA data to identify missing supplier sales opportunities and work to resolve with suppliers and internal departments. This position requires strong attention to transaction detail.
Position Reports to Manager, Data Management GPO Finance
Primary Responsibilities
- Responsible for accurate CIA customer matching
- Complete supplier/data maintenance functions, including eliminating duplicate suppliers, re-assigning suppliers, and re-categorizing suppliers as needed for CIA matching
- Partner with cross-functional groups to prioritize matching requests in an accurate and timely manner
- Identify and generate ad-hoc analysis to help identify matching opportunities to increase supplier match percentages for CIA customers
- Ability to reconcile between multiple systems to ensure accuracy of matching
- Analyze CIA data and perform research to identity missing spend issues
Secondary Responsibilities
- Partner with data management and AP&A teams to support routine matching goals and/or ad-hoc projects
- Interact with distributors and manufacturers to accurately analyze and match data
- Research distributors and manufacturers to establish accurate brands and item identification
- Partner with other data management teams to validate the data accuracy of distributors reporting to the spend tracking system
- Identify supplier missing sales opportunities by utilizing CIA match data
- Participate in missing sales recovery processes
- Create monthly CIA recap reporting to communicate results
- Invoice posting backup
- Projects as assigned
Primary Competencies
- Functional/Technical Skills
- Problem Solving & Analytical Skills
- Planning and Organization
- Results Orientation
- Taking Initiative
- Effective Written and Oral Communications
Other Duties. Please note this role description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Work Environment. This job operates in an office setting. This role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets.
Physical Demands. This is largely a sedentary role with some light lifting of files possibly needed.
Role Requirements
- Excellent communication and organizational skills
- Strong PC skills in the areas of database and spreadsheet-based applications (MS Excel with an emphasis in Formulas, LOOKUP’s, and Pivot Tables) and MS Access
- Knowledge of SQL basics
- Familiarity of PowerBI, Reporting Platforms, and Python a plus
- Analytical skills - turning data into knowledge and knowledge into action
- Proficient in utilizing the internet to perform research
- Prior experience with the Avendra business and PURS system a plus
- Ability to read and speak Spanish a plus, but not required
Years of Relevant Experience. 1-3 years of experience in a professional business setting
Education Requirements. BS/BA in relevant field or equivalent years' experience