Associate Business Analyst

Idea Nuova, Inc.; Bentonville (AR); On-site; USD 60,000 - 80,000; Full time

Job summary

Idea Nuova, Inc. seeks an Associate Business Analyst to support the Walmart account with strong Excel skills and data-driven insights. You will analyze sales, inventory, and performance trends and develop reporting tools for internal teams and Walmart meetings.

The role emphasizes organized, detail-oriented work, data management across large SKU assortments, and collaboration with Sales, Planning, and Replenishment to optimize inventory and forecasting.

Qualifications

• Strong proficiency in Microsoft Excel and large dataset handling.
• Analytical mindset with problem-solving abilities.
• Highly organized with attention to detail and multi-project management.
• Excellent written and verbal communication with senior leaders and partners.
• Willingness to learn new systems, tools, and technologies.

Responsibilities

• Analyze daily/weekly Walmart sales, inventory, in-stock, and trends.
• Prepare recurring sales reports and business recaps for leadership.
• Identify trends, opportunities, risks in SKU-level data.
• Support item/category/store/program performance analysis.
• Develop and maintain Excel-based reporting tools and dashboards.
• Assist Walmart meetings, line reviews, and internal presentations.

Skills

Excel

Data analysis

Analytical skills

Organization

Communication

Willingness to learn

Walmart experience

Walmart systems familiarity

AI tools

Retail trends

Tools

Power Query

PivotTables

XLOOKUP

SUMIFS

Data visualization

Job description

Position Overview

We are seeking a highly organized, analytical, and motivated

Position Overview

We are seeking a highly organized, analytical, and motivated Associate Business Analyst to support our Walmart business. This role will work closely with our Sales, Planning, and Replenishment teams to analyze performance, track key business initiatives, and help manage the day-to-day needs of a fast-moving Walmart account.

This is an excellent opportunity for someone early in their career who wants to develop a strong understanding of Walmart, retail analytics, demand planning, and supplier operations. The ideal candidate is highly proficient in Excel, comfortable working with large amounts of data, eager to learn new systems and technologies, and able to communicate and present themselves professionally with both internal teams and Walmart.

Our business operates within fashion-driven categories with large SKU assortments, frequent trend changes, promotions, and seasonal programs. The ability to stay organized, identify trends within the data, and manage multiple priorities will be important to success in this role.

Key Responsibilities

Sales Analytics & Reporting

• Analyze daily and weekly Walmart sales, inventory, in-stock, and performance trends.
• Prepare recurring sales reports and business recaps for Sales and Planning leadership.
• Identify meaningful trends, opportunities, risks, and changes within large SKU-level datasets.
• Support analysis of item, category, store, and program performance.
• Assist with preparation for Walmart meetings, line reviews, business reviews, and internal presentations.
• Develop and maintain Excel-based reporting tools and dashboards.
• Help improve existing reporting processes through better use of Excel, automation, and AI tools.

Walmart Business Support

• Support the day-to-day management of the Walmart account.
• Work with sales leadership to research questions and provide data-driven answers related to the business.
• Track Walmart promotions, modular changes, new item launches, seasonal programs, and other key business initiatives.
• Monitor performance before, during, and after promotional periods.
• Maintain organized records of key programs, commitments, timelines, and follow-up items.
• Develop a strong working knowledge of Walmart systems, reporting tools, terminology, and processes.

Purchase Order & Inventory Tracking

• Track inbound purchase orders and expected inventory flow.
• Monitor purchase order timing and identify potential inventory or supply risks.
• Help communicate inbound inventory status to Sales, Planning, Replenishment, and Operations teams.
• Assist in identifying situations where inventory timing could impact sales, promotions, or in-stock performance.

Demand Planning

• Assist with basic demand planning and forecasting activities.
• Review historical sales, current trends, inventory levels, promotions, and seasonality when evaluating future demand.
• Help identify items that may be over-forecasted, under-forecasted, over-inventoried, or at risk of going out of stock.
• Support planning teams with SKU-level analysis across large assortments.

AI & Process Improvement

• Utilize AI tools to improve productivity, reporting, analysis, and problem-solving.
• Look for opportunities to automate repetitive analytical tasks.
• Develop an understanding of how AI can be used alongside Excel and traditional retail analytics.
• Continuously look for better ways to analyze, organize, and communicate information.

Qualifications

Required

• Strong proficiency in Microsoft Excel.
• Comfortable working with large datasets and detailed SKU-level information.
• Strong analytical and problem-solving skills.
• Highly organized with strong attention to detail.
• Ability to manage multiple projects, deadlines, and priorities simultaneously.
• Strong written and verbal communication skills.
• Professional demeanor and the ability to communicate effectively with senior leadership and retail partners.
• Willingness to learn new systems, analytical tools, and technologies.

Preferred

• Previous experience working with Walmart, a Walmart supplier, or another major retailer.
• Familiarity with Walmart systems, Retail Link, Luminate, or similar retail reporting platforms.
• Experience with sales analysis, replenishment, forecasting, demand planning, or inventory management.
• Advanced Excel capabilities, including PivotTables, XLOOKUP, SUMIFS, Power Query, and data visualization.
• Interest in becoming a subject matter expert in Excel and retail analytics.
• Experience using AI tools such as ChatGPT, Microsoft Copilot, or similar platforms.
• Experience working in fashion, home, apparel, seasonal, or other trend-driven retail categories is a plus.

What We Are Looking For

We are looking for someone who is more than just comfortable with numbers. The right candidate will be curious about why the numbers are changing and what we should do about it.

The Ideal Candidate Will Be

• Analytical and naturally curious.
• Extremely organized and dependable.
• Comfortable digging into details without losing sight of the bigger picture.
• Eager to become an expert in Excel, Walmart analytics, and retail planning.
• Interested in learning how AI can improve the way work gets done.l
• Able to take complex information and present it clearly and professionally.
• Comfortable interacting with senior leaders and presenting themselves in a polished, executive manner.
• Willing to take ownership of projects and continue learning as their responsibilities grow.

Growth Opportunity

The Associate Business Analyst will gain broad exposure to sales strategy, demand planning, replenishment, forecasting, inventory management, retail analytics, and customer-facing account management.

This role is well suited for someone who wants to build a career within retail and Walmart account management. As the individual develops their analytical skills and knowledge of the business, there will be opportunities to take on greater ownership and responsibility across Sales, Planning, and Analytics.