Category Insights Analyst

Advantage-Solutions; Cincinnati (OH); On-site; USD 60,000 - 80,000; Full time

Job summary

Advantage Solutions is seeking a Category Insights Analyst to serve as a key analytics resource for clients with <$20M+ in regional retail sales. You will accelerate information delivery, streamline reporting, and provide pricing recommendations to drive client development and Advantage growth.

The role involves collecting and analyzing data from NIQ, Circana, retailers and shipments, creating ad hoc and standardized reports, and collaborating with a regional sales office to deliver

Qualifications

• Bachelor’s degree required; professional certification in category management is a plus.
• Less than 1 year experience in relevant field; consumer packaged goods experience preferred.
• Travel no travel required.
• Strong analytics, interpretive, and problem-solving skills with ability to turn data into actionable insights.
• Experience using data visualization tools and reporting applications.

Responsibilities

• Reporting: use various data sources to provide business insights and support regional objectives.
• Trade & Pricing: develop retail trade and promotional pricing analyses to aid campaigns.
• Marketplace Expertise: analyze trends and retailer activities to become SME for regional marketplace.
• Business Reviews: assist in the development of line reviews, business overviews, and selling stories.
• Collaborate on Merchandising: work with Space Management to create planograms that meet client objectives.

Skills

Analytics

Syndicated data

Data visualization

Clear communication

Excel skills

Education

Bachelor’s degree

Category management cert (plus)

Job description

Summary

Category Insights Analyst

As a Category Insights Analyst, you will be a crucial analytical and insights resource for our clients with <$20M+ in retail sales in a specific regional sales market. Your primary responsibilities will include accelerating information delivery, streamlining processes, and providing key insights, reporting, forecasting, and sales planning support. Additionally, you will be tasked with post-promotional analytics and providing pricing recommendations to drive client development and Advantage growth.

A significant aspect of your role will involve collecting, analyzing, and reporting information using a variety of tools, data sets (i.e. NIQ, Circana, retailer, shipment, etc.), and techniques. Working closely with a regional sales office, you will collaborate with internal and external clients to identify data reporting needs, conduct business data analysis, and create both ad hoc and standardized reports to facilitate actionable insights.

As the Category Insights Analyst, you will be regarded as the subject matter expert in consumption data for your assigned clients. You may also be involved in developing or implementing tools to enhance processes for capturing business data and maintaining data quality.

Job Will Remain Open Until Filled

Responsibilities

The Company 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. The Company 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.

Responsibilities

• Reporting: Utilize various data sources, including consumption sales data and shopper insights to provide business insights that supports sales in delivering against ADV and client business objectives / core KPI’s for specified region.
• Trade & Pricing: Contribute to the development of retail trade & promotional pricing recommendations, supporting the Sales Team with in-depth pre- and post-promotional analysis. Insights and learnings to enhance trade effectiveness and efficiency for ADV Clients.
• Marketplace Expertise: Analyze market trends, competitive activities and channel shifts to act as SME for regional marketplace. Develop expertise on each retailer in assigned geography.
• Business Reviews: Assist the Category Analytics & Insights Manager in the development of line reviews, business overviews and selling stories to help support ADV client selling opportunities
• Collaborate on Merchandising: Collaborate with Space Management team to develop best in class planograms to advocate for shelving standards to achieve our client’s objectives.

Qualifications

Education Requirements: Bachelor’s degree (Professional certification in category management a plus)

Experience Requirements: Less than 1 year experience in relevant field (Consumer Packaged Goods experience preferred)

Travel requirement: No travel requirements

Supervisor Responsibility

Direct Reports: This position does not have supervisory responsibilities for direct reports

Indirect Reports: Does not have direct reports, but may delegate work of others and provide guidance, direction and mentoring to indirect reports

Required Knowledge and Skills

• Strong analytics, interpretive, and problem-solving skills with ability to turn data into actionable insights
• Working knowledge of syndicated scan data and business reporting applications
• Experience using data visualization tools
• Ability to communicate complex quantitative analysis in a clear, precise, and actionable manner
• Strong Excel skills including pivot tables and v-lookups; aptitude for learning relational databases and multi-dimensional data tools

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 telephone, ability to enter data on a computer and may require the ability to lift up to 10lbs.

Additional Information Regarding Job Duties and Job DescriptionsJob 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. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job positions, or assign additional job responsibilities, subject to applicable law. The Company 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.

Important Information

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.

The Company 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, the Company 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 law.