Inventory & Business Intelligence Analyst
Summary
Inventory & Business Intelligence Analyst at Soft Surroundings, an omnichannel catalog and e-commerce retailer. The analyst is the inventory team's reporting and data partner, producing daily/weekly/monthly and ad hoc reporting on demand, inventory, and product performance using advanced Excel, VBA automation, and Power BI.
Be your best self – join the team at Soft Surroundings!
We believe that every woman – at every stage – should look and feel her very best.
At Soft Surroundings, we have many exciting and rewarding career opportunities at all levels. We’re an omnichannel retailer serving customers online and through our catalogs. Together with our talented team, we continue building on our rich history of unique style and outstanding customer service.
Benefits and perks:
- Medical, dental, and vision insurance on the first of the month following start date
- Competitive salaries
- Hybrid- remote/in-office work model
- 401(k) Retirement Plan Match
- Employee discounts
- Generous PTO, paid holidays, and sick time off
Position Summary
The Inventory & Business Intelligence Analyst serves as the Inventory team’s primary reporting and data partner, developing, maintaining, and improving the reporting and analytical tools that support the company’s catalog and e-commerce businesses. This role provides daily, weekly, monthly, and ad hoc reporting across key business metrics, with a primary focus on demand, inventory, and product performance.
The analyst will work with Inventory, Merchandising, Finance, and other business partners to turn data into clear, actionable information. The ideal candidate combines strong retail business acumen with advanced technical skills in Excel, Power BI, VBA, and reporting automation.
Key Responsibilities
Reporting & Analysis
- Produce and maintain daily, weekly, monthly, seasonal, and ad hoc reporting across key business metrics.
- Prepare reporting and data to support the planning calendar, including plan development, hindsight, and other milestones as needed.
- Maintain catalog recap and demand curve reporting that planners use to read early catalog response and project total demand.
- Analyze demand, inventory, sell-through, weeks of supply, backorders, returns, and product performance.
- Provide reporting and analysis by catalog, department, category, product/style, and other relevant business dimensions.
- Monitor actual performance against plans, forecasts, budgets, and prior-year results.
- Identify trends, exceptions, risks, and opportunities within demand and inventory performance.
- Perform ad hoc analyses to answer business questions and support merchandising, inventory, marketing, and leadership decision-making.
- Ensure reporting is accurate, consistent, timely, and clearly understood by business users.
Business Intelligence & Reporting Automation
- Translate business questions into meaningful reporting, visualizations, and analytical views.
- Develop and maintain sophisticated Excel-based analytical and reporting tools.
- Use advanced Excel functionality including PivotTables, Power Query, complex formulas, lookup functions, dynamic arrays, and data validation.
- Write, maintain, and troubleshoot VBA code and Excel macros to automate recurring reporting and data-processing activities.
- Identify repetitive manual processes and develop automated solutions that improve speed, accuracy, and efficiency.
Data Quality & Process Improvement
- Validate reporting outputs and investigate discrepancies across source systems and reports.
- Maintain documentation for key reports, calculations, business rules, and automated processes.
- Continuously look for ways to simplify reporting, eliminate unnecessary manual work, and improve access to information.
- Partner with business and technical teams to improve data quality and reporting capabilities.
- Maintain clean, reliable data sets that serve as the team’s single source of truth for demand, inventory, and receipts.
- Serve as the planning team’s primary point of contact for reporting and data requests.
- Other duties as assigned.
Qualifications
- Bachelor’s degree in Business, Finance, Analytics, Information Systems, Mathematics, Statistics or a related field.
- Experience in business analysis, inventory analysis, merchandise planning, reporting, or business intelligence is preferred.
- Experience in retail, direct-to-consumer, catalog, or e-commerce strongly preferred.
- Advanced proficiency in Microsoft Excel.
- Demonstrated ability to develop and maintain Excel macros and VBA code.
- Experience in developing reports and dashboards using Microsoft Power BI.
- Understanding of retail concepts such as demand, inventory turn, receipts, returns, backorders, and product lifecycle performance.
- Strong analytical and problem-solving skills with the ability to work independently with large and complex data sets.
- Strong attention to detail and demonstrated commitment to data accuracy.
- Ability to manage recurring reporting deadlines while responding to changing priorities and ad hoc requests, including during peak selling periods
- Ability to communicate analytical findings clearly to both technical and non-technical audiences.
- Strong sense of ownership, with the curiosity to investigate unusual results and the judgment to balance accuracy with speed
- Must be able to read, write, and speak English fluently
Preferred Skills
- Experience with Power Query and DAX.
- Working knowledge of SQL and relational databases.
- Experience working with merchandise planning, inventory management, ERP, order management, or data warehouse systems.
- Experience automating recurring reports and consolidating information from multiple data sources.
What Success Looks Like
A successful analyst in this role does more than distribute reports. They understand what the numbers mean, recognize when something looks wrong, identify emerging demand or inventory issues, and make information easier for the organization to use.
Over time, the analyst should reduce manual reporting through Excel/VBA and Power BI automation while improving the speed, consistency, and usefulness of information available to decision-makers.
Skills
Sign in to read and join the discussion.