Share this Job

Business Analyst, Advanced Analytics Job

DATE: Mar 11, 2019

CITY: Columbus, OH, US, 43219

Company: DSW

Req #: 86607 
Location Name: Home Office, Columbus 
Department: Merch Planning and Allocation 


At DSW, we believe in the power of shoes. We understand shoes bring out something great from within, and since 1991 we've been helping everyone feel the rush of finding that perfect pair. So when you work for DSW, you become a part of all that. A family whose core values are comprised of passion, accountability, collaboration, and humility. You become one of us, You become a Shoe Lover!


Job title:  Analyst, Advanced Analytics

General Summary:  The Analyst, Advanced Analytics works within a team environment to actively assist in providing business analysis across MP&A and Merchandising, receiving direction and guidance from leadership. Analyst is involved in all stages of analysis and assessment from conducting correlation and regression analysis to identifying potential drivers of future business results.  Analyst provides data insights by analyzing product data and collaborating cross-functionally to ensure awareness of insights.

Reports to:  Senior Principal or Manager, Advanced Analytics


Essential Duties and Responsibilities:


  • Work on assigned business initiatives/opportunities, collect data, establish facts, and draw valid conclusions
  • Data generation using various tools (SAS Size Profiling, etc..) to support business applications
  • Support testing of data changes in Assortment Planning
  • Ability to respond to and answer executive questions
  • Possess the ability to review a plan
  • Analyze, organize, and collate high volumes of data from various sources
  • Identify required data sets based on the given requirements within the business question to be solved
  • Work in a team environment to actively assist in the analysis of focus areas while receiving direction and guidance from Senior Principal/Principal/Senior Analysts within Advanced Analytics Team


Required Skills and Competencies:


  • Complete varied tasks and utilize independent judgment
  • Technical aptitude, seeks to learn new skills
  • Display solid oral and written communications skills
  • Utilize creative forward thinking to evaluate business opportunities and risks with assistance
  • Exhibit strong analytical and complex problem-solving skills
  • Demonstrate organizational skills including the ability to meet deadlines with a focus to details
  • Possess strong time management skills



Physical Demands:

  • n/a


Minimum Qualifications


  • 3-5 years’ retail or relevant experience
  • Comprehensive knowledge of Inventory Management, P & L, and retail math concepts to aid in analysis


Preferred Qualifications:

  • Proficient in Microsoft Office:  MS Excel PowerPivot and MS Access preferred
  • Experience in SQL, R, Python, RapidMiner, and SAS beneficial



  • Bachelor’s degree in Math, Information Technology, or Business Analytics preferred

DSW believes that all persons are entitled to equal employment opportunities. We do not discriminate against any protected class including race, color, religion, religious creed, gender, sex, national origin, age, physical disability, mental disability, medical condition (defined as genetic information or impairments related to cancer), ancestry, marital status, family care leave, military and veteran status, citizenship status, sexual orientation, gender identity, gender expression, genetic information, or based on any protected category under federal, state, or local laws. DSW also makes reasonable accommodations for qualified applicants and associates with disabilities unless doing so creates an undue hardship, in accordance with all legal requirements. Any applicant requiring a reasonable accommodation during the application process or applicant who requires an accommodation to perform the essential functions of the job should request for accommodations by asking to speak with a Store Manager, District Manager, and Regional Manager, or by contacting Human Resources at DSW will work with the individual to attempt to identify a reasonable accommodation that will not impose an undue hardship on DSW.


Nearest Major Market: Columbus

Job Segment: Analytics, Data Analyst, Developer, Merchandising, Database, Management, Data, Technology, Retail