Sr Cat Profit Imprv Analyst

BJ's Wholesale Club; Marlborough (MA); Hybrid; USD 78,000 - 101,000; Full time

Job summary

BJ’s Wholesale Club is seeking a Category Analytics/Merchandising professional to drive performance insights and strategic recommendations for assigned categories. You’ll collaborate with Merchants and Leadership to shape assortment, pricing, and promotional strategies using internal and syndicated data.

The role emphasizes analytical storytelling, cross‑functional partnership, and the use of generative AI tools to enhance analysis, reporting, and presentations.

Qualifications

• Bachelor’s degree in finance, business, economics, statistics, or related field.
• 2+ years merchandising analytics or category management experience.
• Strong Excel modeling and SQL; experience with visualization tools.
• Excellent communication and PowerPoint skills.
• Experience using generative AI tools.

Responsibilities

• Collaborate with Lead Analyst and Manager to review performance and develop strategies for Executive Leadership, shaping the analytical storyline across categories.
• Build and test hypotheses using internal/third‑party data; evaluate SKU, brand, vendor performance, profitability and loyalty.
• Develop recommendations on assortment, space productivity, brand and vendor mix, and Own Brands opportunities.
• Create Consumer Behavior Trees and benchmark segment share to inform assortment strategies.
• Model proposed assortment, pricing, and promotional changes; prioritize recommendations with cross‑functional partners; present to Merchandising leaders.
• Prepare executive‑ready presentations that connect findings to recommendations and present to leadership.
• Serve as analytical contact for Merchants, handling ad‑hoc questions on assortment, sales, and costs.

Skills

Excel modeling

SQL

Analytical thinking

Presentation skills

AI familiarity

Education

Bachelor’s degree in Finance/Business/Economics/Statistics

Tools

SQL

Tableau

Power BI

Databricks

Job description

A World-Class Team

BJ’s Wholesale Club is powered by more than 30,000 team members who make a real impact every day. Whether you're stocking shelves, solving problems or shaping strategy, your work helps families save on what matters most.

A World-Class Team

BJ’s Wholesale Club is powered by more than 30,000 team members who make a real impact every day. Whether you're stocking shelves, solving problems or shaping strategy, your work helps families save on what matters most.

We’re a team built on purpose and opportunity. Join us and be part of something meaningful.

Why You’ll Love Working at BJ’s

At BJ’s Wholesale Club, our team members are at the heart of everything we do. That’s why we offer a comprehensive benefits package designed to support your health, well‑being and future – both on and off the job. When you grow, we grow.

Here’s just some of what you can look forward to:

• Weekly Pay: Get paid every week so that you can manage your money on your terms.
• Daily Pay: Access your earned pay before payday, giving you more flexibility when you need it. (fee may apply.)
• Free BJ’s Memberships: Enjoy a complimentary The Club Card Membership, plus a free Supplemental Membership for someone in your household.*
• Generous Paid Time Off: Take the time you need with vacation, personal, sick days, holidays, bereavement, and jury duty leave.*
• Flexible and Affordable Health Benefits: Choose from three medical plans, and access optional dental, vision, Health Savings Account (HSA), and flexible spending account options to fit your lifestyle.*
• 401(k) Retirement Savings Plan: Build your financial future with a company match (available to team members 18 and older).*
• Employee Stock Purchase Plan: Accumulate funds through after‑tax payroll deductions that can be used to purchase shares of BJ’s common stock at a 15% discount.*
• Eligibility requirements vary by position.

Key Responsibilities

Category insights and recommendations

• Work with the Lead Analyst and Manager in the Category Management Process to review performance and develop strategies for Executive Leadership. Shape the analytical storyline for assigned categories across performance drivers, member behavior, competitive position, and the 4 Ps (product, placement, price, and promotion).
• Build and test hypotheses using internal and third‑party data. Evaluate SKU, brand, and vendor performance, including productivity, profitability, loyalty, cross‑shopping, and substitution.
• Develop recommendations on assortment, space productivity, brand and vendor mix, Own Brands opportunities, pricing, and promotional effectiveness.
• Develop Consumer Behavior Trees and benchmark segment share and growth against the rest of the market to inform assortment strategies.
• Model proposed assortment, pricing, and promotional changes; validate assumptions with cross‑functional partners; and prioritize recommendations based on estimated sales and profit impact. Merchants retain final decision authority.
• Build executive‑ready presentations that connect findings to clear recommendations and present them to Merchandising leaders and the Executive team.
• Serve as a primary analytical contact for assigned Merchants, including ad‑hoc assortment, sales, and cost questions.

Market perspective and team effectiveness

• Use syndicated data and competitive comparisons to identify assortment gaps, assess brand strength, and track emerging brands and category trends.
• Apply and improve team methodologies, templates, and reusable workflows to increase analytical consistency and reduce cycle time.
• Use generative AI to support analysis, research, automation, and presentation development. Validate outputs, protect confidential data, and share effective practices with the team.
• Collaborate across functions and provide analytical backup and thought partnership to the Manager and team members.

Required Qualifications

• Bachelor’s degree in finance, Business, Economics, Statistics, or a related quantitative field, or equivalent experience.
• 2+ years of relevant experience in merchandising analytics, category management, pricing, or consulting, with an understanding of merchandise profitability, including margin, cost structures, vendor funding, and trade terms.
• Developing business acumen, with curiosity about how a category makes money; strong analytical and critical‑thinking skills to explain sales and profit drivers, question assumptions, and validate results.
• Hands‑on proficiency in Excel for modeling and large datasets, and working fluency with SQL and visualization tools such as Tableau or Power BI.
• Strong communication skills, including the ability to build Microsoft PowerPoint presentations that lead with the insight and recommendation, and develop effective working relationships with all levels of Merchandising leadership.
• Ability to manage competing priorities, meet deadlines, work independently on defined assignments, ask for guidance when needed, and adapt to changing work priorities.
• Practical experience using generative AI tools such as Claude, Copilot, or ChatGPT, with the ability to review analytical logic, identify errors, and verify business relevance.

Preferred Qualifications

• Experience in club, grocery, mass, or other high‑volume retail.
• Familiarity with syndicated market data such as Circana or NielsenIQ and competitive benchmarking.
• Exposure to category reviews, vendor negotiations, or member/customer analytics, including loyalty, survey, or basket analysis.
• Familiarity with cloud data platforms such as Databricks.

This is a hybrid role. Tuesday through Thursday are in‑office days at BJ's Club Support Center in Marlborough, MA and Monday and Friday are remote days.

In accordance with the Pay Transparency requirements, the following represents a good faith estimate of the compensation range for this position. At BJ’s Wholesale Club, we carefully consider a wide range of non‑discriminatory factors when determining salary. Actual salaries will vary depending on factors including but not limited to location, education, experience, and qualifications. The pay range for this position is $78,000.00 - $101,000.00

We recognize the growing role of AI tools, including ChatGPT, and value familiarity with them. That said, we want to hear from your authentic self. Your application should reflect your own skills, experiences, and insights rather than AI‑generated responses.