Category Insights Sr Analyst

Advantage Solutions; Chicago (IL); On-site; USD 67,000 - 84,000; Full time

Job summary

Advantage Solutions is seeking a Category Insights Senior Analyst to deliver consumer and marketplace insights for national clients with $20M+ retail sales in a regional market. You’ll partner with Category Analytics & Insights and sales teams to diagnose business problems and drive growth.

In this role, you will collaborate with a regional office to identify data reporting needs, conduct analysis, and create ad hoc and standardized reports using NIQ, Circana, and other datasets, ensuring data

Qualifications

• Bachelor's degree required; Category Management certification a plus.
• 3–5 years of CPG or retail data analytics experience.
• Travel: No regular travel expected.

Responsibilities

• Strategic Business Insights: provide insights and market data to measure tactical execution and inform plan adjustments.
• Trade & Pricing: support retail trade and promotional analysis to improve effectiveness.
• Business Reviews & Market Assessments: supply data for line reviews and client selling opportunities.
• Project Management: prioritize and manage schedules and coordinate activities.
• Client/Customer Partnership: build relationships and translate insights into actionable recommendations.

Skills

Data storytelling

Syndicated data

Power BI

Tableau

Looker

Advanced Excel

Education

Bachelor's degree

Category Management cert

Tools

Power BI

Tableau

Looker

Alteryx

MS Access

Job description

Category Insights Sr Analyst

US-IL-Chicago
Chicago, IL 60601
Full Time
USD $67,200.00/Yr. - USD $84,000.00/Yr.

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.

• 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 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 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. 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.