Excel Model Building (VBA) Business Analyst

We are currently looking for an Excel Model Building (VBA) Business Analyst for a REMOTE PROJECT.

Position: Excel Model Building (VBA) Business Analyst

Start Date: ASAP

Project Duration: End of the Year

Work Load: 2-3 Days per Week

Location: Remote (Candidates must be based in Europe)

Project: Excel Model Building

Industry: E-Commerce

Unit: Supply Business Unit. This unit oversees the sourcing, procurement, and in-season trading of all products.

Your responsibilities will involve driving insights planning and forecasting our purchasing needs, building business cases for investment decisions, providing data-driven recommendations and bringing transparency to the business drivers, and maintaining and evolving our Planning models.

Experience:

- You have gained 5+ years of experience in an e-commerce, planning or analytical role

- Commercial mindset combined with a deep analytical skillset

- You have experience in setting up business cases and driving strategic business conclusions

- You have experience with projects in the E-Commerce, Fashion or Retail sector

- You have great communication skills and a proven track record of navigating a complex stakeholder landscape

- You have advanced skills in Excel (including the ability to write and implement VBA macros)

- You’re fluent in SQL, Python

- Google Analytics experience

Tasks:

- You will execute the weekly/monthly/seasonal performance analysis and forecasts and develop action plans to maximize growth, optimize profit and manage stock levels

- You will develop forecasting supply planning models by implementing statistical methods to perform predictive analysis for sales and inventory trends.

- You will monitor the OTB (Open-To-Buy) FC and derive recommendations for the top and bottom line to meet the financial targets.

- You generate ad-hoc data-driven insights and support solving complex commercial, financial, and operational challenges in the Supply Business unit.

- You are responsible for creating and maintaining existing planning tools and processes and support evolving them where you see an opportunity to improve and streamline.

- You proactively cultivate strong relationships with key stakeholders across critical business functions through effective and proactive communication.

- You act as a functional expert for Junior Strategic Planners and mentor less experienced members of the wider team.

Does this project sound interesting? Awesome! Please get in touch by sending your CV, your hourly remote rate and availability.