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.