As a member of the Insights and Analytics Team, the Business Analyst supports our Procurement Division with data driven analysis and strategic guidance. This role will have a primary responsibility around strategic funding and assortment optimization.

Core Functions

The core functions of this position include, but are not limited to, the following:

· Creation of monthly Vendor scorecards tracking costs, sales, dead net profit, funding, and creating materials for divisional checkpoint meetings.

· Generate vendor strategy playbooks, evaluate negotiated vendor offers, create funding forecasts, track vendor funding and performance requirements to ensure actuals meet forecasts.

· Present insights and recommendations to Category Managers, Procurement Managers and Division VP’s

· Utilize internal as well as syndicated data sources to conduct assortment reviews and provide assortment recommendations based on insights gathered

· Build relationships with key members of Procurement teams as well as vendor community

· Work hand in hand with Procurement and Accounting to ensure follow through of strategic budget

Knowledge and Skill Requirements:

· Bachelor’s degree in Business, Economics, Mathematics, Statistics or equivalent.

· Demonstrated analytical, quantitative, and qualitative analysis skills required.

· Strong statistical and mathematical aptitude, including an understanding of the components of financial analysis and the ability to work accurately with numbers.

· Experience querying large data sets and the ability to translate the data into business insights

· Exceptional collaboration, communication, interpersonal and negotiation skills.

· Solid organizational skills with an above average attention to detail and accuracy.

· Prior experience in Procurement, Merchandising, and/or utilization of syndicated data desirable.

· Highly analytical thinker with ability to derive insights beyond the “obvious”.

· Ability to produce and present succinct analyses to provide decision support as well as communicate findings to all levels of the organization.

· Excellent technical skills in Excel, Word, Outlook and PowerPoint with ability to rapidly learn new software system required.

· Demonstrated ability to independently develop new Excel models, charts and graphs as necessary, experience with predictive analytics desired.

· Proficiency with Alteryx, SQL, and visualization tools desired but not necessary.

· Ability to multi-task while being flexible and reacting quickly to change.

· Strong written and oral communication skills.