Analyst, Merchandise Planning
Gap Inc.
full-time
Posted on:
Location Type: Office
Location: San Francisco • California • 🇺🇸 United States
Visit company websiteJob Level
Junior
Tech Stack
PythonSQLTableauVBA
About the role
- Support preseason analytics and system readiness activities; help identify trends and opportunities within analyses.
- Partner with Advanced Analytics and Product Operations to pull, organize, and summarize data that supports business decisions.
- Build strong working relationships across Inventory Management, Gap Tech, and Product Management teams to support timely and relevant analytical deliverables.
- Assist with delivering formal trainings for cross-functional partners (e.g., tool walk-throughs, reporting usage).
- Contribute to the development and maintenance of training documentation and reporting instructions.
- Participate in project map work across area of ownership, inclusive of process, system, tool, and product pipeline deliverables.
- Execute assigned portions of projects or initiatives, including data pulls, analysis, documentation, and supporting change management efforts.
- Attend key business and project meetings as needed and summarize takeaways or action items.
- Support day-to-day usage of the reporting suite through troubleshooting and “shoulder-to-shoulder” support for end users.
- Build and enhance tools and reports in Excel using advanced formulas to support business needs.
- Help conceptualize practical Excel-based solutions to new business questions.
- Combine data from multiple sources into usable formats for seamless user access.
- Partner cross-functionally on tool and report design; gather and organize user feedback for future enhancements.
- Translate business questions into clear data and reporting requirements.
- Maintain technical elements of existing tools and reports (e.g., formulas, links, layouts, basic automation).
- Identify and surface opportunities for continuous improvement in tools, processes, and reporting.
Requirements
- 1–3 years of relevant work experience demonstrating problem solving, analytical, and technical capabilities.
- Proven ability to manage multiple tasks or deliverables at once and communicate risks to timelines when needed.
- Advanced user of Microsoft Excel, including experience with advanced formulas; experience building Excel-based reports or tools preferred.
- Exposure to project work, including identifying opportunities, helping define requirements, and supporting implementation and ongoing support.
- Retail or Inventory Management experience preferred, but not required.
- Experience with data visualization tools (e.g., Tableau, Power BI, Looker) a plus.
- Experience with databases and/or coding languages (e.g., SQL, Python, R) a plus.
- Experience with macros, VBA, and specialized formatting in Excel a plus.
Benefits
- Health insurance
- 401(k) matching
- Paid time off
- Flexible work arrangements
- Professional development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data analysisadvanced ExcelSQLPythonRdata visualizationmacrosVBAreportingchange management
Soft skills
problem solvinganalytical capabilitiescommunicationtime managementcollaborationtraining deliverydocumentationcontinuous improvementrelationship buildingproject management