Sr Business Analyst, Merchandise in Raleigh, NC at Advance Auto Parts

Date Posted: 2/15/2018

Job Snapshot

Job Description

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age national origin, religion, sexual orientation, gender identity, status as a veteran and basis of disability or any other federal, state or local protected class.:


With focus around providing Strategic Guidance to the business, the Sr. Business Analyst merchandise is responsible for collecting, analyzing, interpreting and reporting data and insights to support operating plans of the business while supporting the merchandise planning and forecasting processes. Providing data and strategic analysis in quantifying financial opportunity and risk, and communicating the results plus support financial plan for strategic category plans.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

40% Financial Planning & Performance Processes

  • Provide objective and holistic view to all forecasting and budgeting discussions by challenging forecast/budget assumptions, reviewing across categories, comparing to industry, etc.
  • Identify and interpret short & long-term business trends
  • Communicate cross-functionally to ensure integrated P&L
  • Identify & quantify the financial opportunity and risk
  • Provide reporting visibility to EVA P&L; effectively communicate financial data to team
  • Enforce process timelines and gain stakeholder alignment.
  • Grade merchant team insights to actions scorecards and provide appropriate feedback to stakeholders.

50% Strategic Initiatives

  • Collect and analyze information to support the strategic and operating plans of the business.
  • Complete what-if scenarios and contingency planning analyses
  • Provide financial analysis to support vendor negotiations.  Provide risk analysis on troubled vendors and what-if analyses around potential financial options
  • Provide variance analysis and business driver analysis to support decision-making. 
    • This includes effectively communicating and translating the results into business insights. 
    • The analyses include understanding the profitability by product line, vendor, channel, geographic area, customer and other appropriate category. 
    • Also includes understanding the mix/rate and volume impact of changes
    • Provide financial information to support category management team as appropriate.
    • Create “Tool Box” queries for IOM team to support  business decisions.
    • Provide information to other areas of finance as needed.  Understand business drivers and processes of respective areas to drive business team results.

10% Testing

  • Provide support in product test design, complete analysis and share results with stakeholders.

Job Requirements

  • To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Proficiency in Microsoft Excel, PowerPoint and Word required, as is the ability to quickly learn and use job specific computer programs such as Hyperion Financial, SPSS, and EDW
  • Strong IT/systems knowledge background to navigate different data sources
  • Strong analytical and communication skills in order to identify and communicate key business trends and how they inter-relate
  • Strong leadership skills, ability to recommend action points from complex issues and analysis
  • High level of integrity and professionalism and be a skilled facilitator
  • Systems requirements include advanced knowledge in Enterprise Data Warehouse systems (EDW), Planning Systems (Arthur, Hyperion), Microsoft Excel, PowerPoint and Access
  • 4-6 years of financial analysis and/or business planning experience


  • Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
  • Ability to write reports, business correspondence, and procedure manuals. 
  • Ability to effectively present information and respond to question from groups of managers, clients, or customers.

Mathematical Skills: 

  • Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Good financial acumen/ ability to manage budgets and understand financial models for internal and external customers.
  • Ability to understand statistical and analytical concepts as well as communicate them to non-technical audiences.

Reasoning/Critical Thinking Ability:

  • Strong analytical skills required.
  • Ability to develop and communicate customer insight findings and recommendations, creating actionable strategies for physical changes to stores.
  • Strong strategic / innovative thinker.

Management Skills: 

  • Demonstrated problem solving capabilities. 
  • Ability to operate in a complex, rapidly changing environment while adhering to tight schedules and budgets.
  • Demonstrated ability to balance multiple projects in varying degrees of implementation.

 Interpersonal skills: 

  • Strong interpersonal skills, ability to interact effectively with employees at all levels. 
  • Ability to cultivate relationships with key stakeholders across functions in order to achieve business objectives and drive strategic change. 
  • Proven track record of establishing strong relationships with the field sales and operations and experience in leading complex cross-functional teams.


Bachelor’s Degree (Masters Preferred) in Management, Marketing, Finance, Communications, Statistics, or related field;

5-7 years business experience and related project management experience (4 years supervisory experience preferred, 2 years in-store retail experience strongly preferred); or equivalent combination of education and experience.





We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age national origin, religion, sexual orientation, gender identity, status as a veteran and basis of disability or any other federal, state or local protected class.