Skip to content Skip to navigation menu

Planning and Replenishment Reporting Analyst

Corporate, UT


ID: 17915
Posted: 08/11/2022
Expires: 09/10/2022
Department: Replenishment

Shift Info

Type: Full-time
Shift(s): Monday - Friday
Hours: 8:00am - 5:00pm

Wage Info

Wage/Hourly: N/A


At Sportsman's Warehouse, we provide outstanding gear and exceptional service to inspire outdoor memories. Our story began in 1986 when we opened our first store in Midvale, UT. We now have locations in 28 states and growing. With our company and industry growth, we have plenty of opportunities and upward mobility for individuals wanting to begin their employment journey with us.

Benefits / Perks:

  • Health, Dental & Vision Insurance
  • Paid Time Off
  • Employee Discounts
  • Life Insurance
  • 401K w/ Employer Match
  • Employee Stock Purchase Plan
  • Supplemental Insurance - STD, Critical Illness, Hospital Indemnification & Volunteer Life Insurance
  • Employee Assistance Program
  • On-site Gym Facility
  • Employee Appreciation Activities

Purpose of Position:

The Planning and Replenishment Analyst supports the Sportsman’s Warehouse Planning/Replenishment team in the execution of various Planning/Replenishment initiatives. They will design and create reports and dashboards as required to support the Planning/Replenishment and cross functional teams.  The position builds and updates highly interactive, customizable reporting systems used for data analytics. 


Essential Duties and Responsibilities:

  • Develop and maintain Planning/Replenishment, reports, dashboards, and KPI scorecards in Power BI and Excel
  • Connect to multiple internal data sources importing data and transforming it in Power BI and Excel
  • Collaborate with teammates and management to gain and understanding of business needs and objectives.
  • Effectively communicate and interact with Planning/Replenishment, Supply Chain, Merchants, Marketing, IT, and Field to understand current best practices and standards.
  • Address and resolve complex problems; identify innovative solutions
  • Display eagerness to learn new technologies and actively engage in personal development
  • Ensure timely, accurate, streamlined and consistent reporting/analytics for all internal customers.
  • Take ownership and responsibility of job assignments and keep management/team well informed of any unexpected obstacles or challenges.
  • Run and publish weekly, monthly, quarterly, yearly reporting in addition to ad hoc requests.
  • Act as subject matter expert for Planning/Replenishment teams regarding all reporting systems
  • All other duties as assigned



  • Advanced knowledge of Microsoft programs (Excel, PowerPoint, Access)
  • Experience utilizing SQL and BI environment or other reporting tools/languages
  • Experience in developing BI reports and dashboards
  • Advanced organizational and project management skills
  • Experience with SQL, Power BI, Power Query Macros, Pivot Analysis and Data Modeling.    
  • Strong communication skills; ability to convey highly technical information and instructions to all levels of users in a clear and concise manner.
  • Ability to apply advanced problem – resolution skills to highly complex issues, quickly diagnose problems, and develop, test, and implement appropriate solutions.
  • Knowledge of Retail and/or sales environment
  • Ability to create flow-charts and visualization of complex data



  • Bachelor’s degree – preferably in computer science, business or mathematics or relevant work experience

Sportsman’s Warehouse is an Equal Opportunity Employer


Sportsman's Warehouse is proud to be an Equal Employment Opportunity Employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.