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.
16 days ago