Category Insights Sr Analyst

Advantage-Solutions; Chicago (IL); On-site; USD 70,000 - 90,000; Full time

Job summary

Advantage-Solutions is seeking a Category Insights Senior Analyst to serve as analytical partner for national clients with $20M+ in retail sales in a regional market. You will synthesize data into actionable insights and support sales teams with reports and strategic guidance.

Collaborate with internal teams to deliver ad hoc analyses using NIQ, Circana and BI tools. You will mentor junior analysts and help maintain data quality while shaping recommendations that drive growth.

Qualifications

• Bachelor’s degree required; certification in Category Management a plus.
• 3 to 5 years of CPG or retail data analytics experience
• Travel: No regular travel required and no supervisory responsibilities at this time
• Indirect Reports: May provide project direction and mentoring to other teammates

Responsibilities

• Strategic Business Insights: keep a pulse on the business and deliver insights and market data to inform plans.
• Trade & Pricing: develop retail trade & promotional pricing analyses to support the Sales Team.
• Business Reviews & Market Assessments: provide data-driven insights for line reviews and customer selling stories.
• Project Management: prioritize and manage project schedules, coordinate activities, and resolve issues.
• Client/Customer Partnership: build strong relationships and translate insights into actionable recommendations.

Skills

Insights generation

Syndicated data experience

Data visualization

Excel advanced

Database tools

Education

Bachelor's degree

Category Management certification

Tools

Power BI

Tableau

Looker

NIQ

Circana

Excel

Alteryx

MS Access

Job description

Summary

Category Insights Senior Analyst

As a Category Insights Senior Analyst, you will serve in a critical analytical and insights resource for our national clients with $20M+ in retail sales in a specific regional sales market. You will play a strategic role in delivering consumer and marketplace insights. In this position you will serve as a key business partner to the Category Analytics & Insights and sales teams in helping diagnose business problems and driving business growth.

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. You may provide direction to one or more Business Intelligence Analysts to assist in his/her development of analyzing and reporting information using a variety of tools, data sets (i.e. NIQ, Circana, customer, shipment, etc.), and techniques.

As the Category Insights Senior 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

• Strategic Business Insights: Keep a pulse on the business, bringing the right insights and market data to measure DSMP tactical execution. Leverage key learnings to inform plan adjustments and partner with sales and Category Analytics & Insights team for in-market execution.
• 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 Clients.
• Business Reviews & Market Assessments: Provide insights and data from a variety of sources in the development of line reviews, business reviews, and impactful customer specific selling stories to help support ADV client selling opportunities.
• Project Management: Prioritize and manage project schedule by monitoring progress, coordinating activities, and resolving issues.
• Client/Customer Partnership: Build strong, value-added relationships with clients/customers and internal stakeholders. Transform insights and implications into actionable recommendations that inform strategic direction.

Qualifications

Education Requirements: Bachelor’s degree required; certification in Category Management a plus

Experience Requirements: 3 to 5 years of CPG or retail data analytics experience

Travel requirement: No regular travel expected

Supervisor Responsibility

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

Indirect Reports: May provide project direction and mentoring to other teammates

Required Knowledge and Skills

• Expert in turning multiple data sources into compelling, business-driving insights
• Strong syndicated data and reporting application experience (e.g., NIQ, Circana)
• Proficiency with data visualization tools like Power BI, Tableau, or Looker
• Advanced Excel skills (pivot tables, v-lookups); familiarity with database tools like Alteryx or MS Access a plus
• Strong communication and storytelling skills; able to simplify complex analysis for diverse audiences

Environmental & Physical RequirementsOffice / 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 for 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.