ARTS Sr Data Specialist

Summary

ARTS Senior Data Specialist

Position Summary

The ARTS Senior Data Specialist will assist with the enforcement of department procedures and policies, the development and direction of programs to help increase ARTS Data Logistics Team productivity, and monitor the daily workload of Arts Client Team Services, or ACTS. This position is responsible for correction of retail databases by troubleshooting root causes, communicating needed corrections, evaluating, analyzing and interpreting reports and data to identify inconsistencies. The ARTS Senior Data Specialist may support the retail team with entering, validating, and maintaining databases. This position will also be responsible to support the Logistics team by performing cycle routing.

Essential Job Duties and Responsibilities

• Troubleshooting
• Work directly with the client and retail team to research, identify, and communicate the different types of data issues which include but not limited to our different retail platforms, new and existing reports, template loads, WIM error logs, and all system admin inconsistencies. It is this positions responsibility to learn all assigned retails team’s reports, be able to analyze them for accuracy, trouble shoot and escalate issues as needed to the appropriate department. This position will also provide access to users and maintain user restrictions as required for all assigned retail teams
• Logistics Analysis
• Format coverage plans received from Store Routing Maintenance for import into Roadnet Logistics software. Process coverage plans in Roadnet Logistics software; generating itinerary data and route statistics. Deliver final coverage plan details from Roadnet Logistics software to client formatted for MS Excel. Load coverage plans into ARTS Systems using MS SQL Server. Support both retail and non-retail teams within ASM regarding logistical planning. Ensure Roadnet Logistics sessions are organized and clearly defined. Attend team meetings prepared to provide updates on current projects and issues related the team.
• Database Entry
• Enter and build assigned retail teams’ data which includes, but is not limited to team loads, account notes, surveys, audits, and promotion display tracking. This will be accomplished through formatted templates and data transcribed from documents received from the client, retail management, and sales organization. Information is to be entered within the allotted time frame.
• Communication
• Work closely with ARTS Supervisor to ensure appropriate communication is delivered in an accurate, timely, and consistent fashion. Monitor and communicate daily workload in coordination with the Data Supervisor, to maintain workload levels and ensure service level agreement with Client and Retail teams are met. Will work closely with all ARTS departments to ensure coordinated communication and completion of data entry and loads. This includes but not limited to the issues regarding Retail device data, template loads, all system admin inconsistencies and all Admin System related issues as needed. Maintain procedures and policies
• Data Validation
• Verify the data entered against the sources for accuracy and completeness of data for all assigned teams. Verify the quality of data received/entered against all sources to ensure the accuracy and completeness of data.
• Training
• Coordinate efforts with Data Supervisor to educate and train the ACTS team on new processes, system enhancements, and device functionality. A scheduled ride along with a retail rep is required at least half a day biannually to keep current with the software and field staff needs.
• Retail Software
• Must understand the functionality of the retail software and how the data should appear in the different platforms. A scheduled ride along with a retail team member is required at least one day a quarter to keep current with the software and field staff needs.

Minimum Qualifications

Education Level: (Required) Bachelor's Degree or equivalent experience



Field of Study Area of Experience:

• 3-5 years of experience in data maintenance management
• 2-3 years of data analysis
• 1-2 years of CPG industry, Category Management, Retail Merchandising or Manufacturing

Skills, Knowledge and Abilities

• Strong written communication and verbal communication skills
• Ability to gather data, to compile information, and prepare reports
• Ability to make oral presentations
• Analytical and research Skills
• Well-organized, detail-oriented, and able to handle a fast-paced work environment
• Strong prioritization skills
• Excellent customer service orientation
• Team building Skills
• Flexible and adaptable, able to change and alter according to changes in projects or business environment
• Strong computer skills including proficiency with Microsoft Word, Excel, PowerPoint, Access, Outlook, and web-browsers
• Experience working with Microsoft technologies
• Roadnet Logistics Software
• Helpdesk software
• Custom CRM Database software

Advantage Sales & Marketing, LLC is proud to be an Equal Opportunity Employer

Responsibilities

Advantage Sales and Marketing, LLC (ASM) is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. ASM services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.

Position Summary

The ARTS Senior Data Specialist will assist with the enforcement of department procedures and policies, the development and direction of programs to help increase ARTS Data/Logistics Team productivity, and monitor the daily workload of Arts Client Team Services (ACTS). This position is responsible for correction of retail databases by troubleshooting root causes, communicating needed corrections, evaluating, analyzing and interpreting reports and data to identify inconsistencies. The ARTS Senior Data Specialist may support the retail team with entering, validating, and maintaining databases. This position will also be responsible to support the Logistics team by performing cycle routing.

Essential Job Duties and Responsibilities

• Troubleshooting – Work directly with the client and retail team to research, identify, and communicate the different types of data issues which include but not limited to our different retail platforms, new and existing reports, template loads, WIM error logs, and all system admin inconsistencies. It is this positions responsibility to learn all assigned retails team’s reports, be able to analyze them for accuracy, trouble shoot and escalate issues as needed to the appropriate department. This position will also provide access to users and maintain user restrictions as required for all assigned retail teams
• Logistics Analysis - Format coverage plans received from Store Routing Maintenance for import into Roadnet Logistics software. Process coverage plans in Roadnet Logistics software; generating itinerary data and route statistics. Deliver final coverage plan details from Roadnet Logistics software to client formatted for MS Excel. Load coverage plans into ARTS Systems using MS SQL Server. Support both retail and non-retail teams within ASM regarding logistical planning. Ensure Roadnet Logistics sessions are organized and clearly defined. Attend team meetings prepared to provide updates on current projects and issues related the team.
• Database Entry –Enter and build assigned retail teams’ data which includes, but is not limited to team loads, account notes, surveys, audits, and promotion display tracking. This will be accomplished through formatted templates and data transcribed from documents received from the client, retail management, and sales organization. Information is to be entered within the allotted time frame.
• Communication – Work closely with ARTS Supervisor to ensure appropriate communication is delivered in an accurate, timely, and consistent fashion. Monitor and communicate daily workload in coordination with the Data Supervisor, to maintain workload levels and ensure service level agreement with Client and Retail teams are met. Will work closely with all ARTS departments to ensure coordinated communication and completion of data entry and loads. This includes but not limited to the issues regarding Retail device data, template loads, all system admin inconsistencies and all Admin System related issues as needed. Maintain procedures and policies
• Data Validation – Verify the data entered against the sources for accuracy and completeness of data for all assigned teams. Verify the quality of data received/entered against all sources to ensure the accuracy and completeness of data.
• Training – Coordinate efforts with Data Supervisor to educate and train the ACTS team on new processes, system enhancements, and device functionality. A scheduled ride along with a retail rep is required at least 1/2 day a biannually to keep current with the software and field staff needs.
• Retail Software – Must understand the functionality of the retail software and how the data should appear in the different platforms. A scheduled ride along with a retail team member is required at least one day a quarter to keep current with the software and field staff needs.

Supervisory Responsibilities

Direct Reports

This position does not have supervisory responsibilities for direct reports

Indirect Reports

This position does not have guidance or mentoring responsibilities for indirect reports

Travel and/or Driving Requirements

• Travel is an essential duty and function of this job. Driving is not an essential duty or function of this job.
• Travel up to 35%

Minimum Qualifications The following are the minimum job-related qualifications which an individual needs in order to successfully perform the essential duties and responsibilities of the job

Education Level: (Required) Bachelor's Degree or equivalent experience



Field of Study/Area of Experience:

• 3-5 years of experience in data maintenance/management
• 2-3 years of data analysis
• 1-2 years of CPG industry, Category Management, Retail Merchandising or Manufacturing

Skills, Knowledge and Abilities

• Strong written communication and verbal communication skills
• Ability to gather data, to compile information, and prepare reports
• Ability to make oral presentations
• Analytical and research Skills
• Well-organized, detail-oriented, and able to handle a fast-paced work environment
• Strong prioritization skills
• Excellent customer service orientation
• Team building Skills
• Flexible and adaptable, able to change and alter according to changes in projects or business environment
• Strong computer skills including proficiency with Microsoft Word, Excel, PowerPoint, Access, Outlook, and web-browsers
• Experience working with Microsoft technologies (SQL Server 2008 (or newer)
• Roadnet Logistics Software
• Helpdesk software
• Custom CRM Database software

Environmental & Physical Requirements

Office / Sedentary Requirements

Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds. A detailed Environmental and Physical Requirements document is available in the Total Rewards department.

Additional Information Regarding ASM Job Duties and Job Descriptions



Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. ASM reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. ASM shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

Any estimate, schedule, or guideline provided to associates in this job description or elsewhere in connection with their jobs is only intended to help describe job duties and for planning purposes. Regardless of any such estimate, schedule, or guideline, associates must always record all time worked for our company (which includes but is not limited to on-site work time in an assigned store, office, or other work location; required waiting time; administrative time; and work-related travel time).

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.

Are you passionate about Service Excellence, Results, Integrity, Entrepreneurial Focus and Leadership: These are our values at Advantage Sales & Marketing LLC. Come learn why “Winning Together” is more than just words on a piece of paper. It is the vision by which we live our mission as an organization: "To create outstanding value for clients and customers through superior sales execution, operational excellence and innovative marketing services."

Advantage Sales & Marketing LLC is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, ASM shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.