At a Glance
- Tasks: Own the Power BI environment and deliver insights across sales, inventory, and finance.
- Company: Established international sportswear and fashion business with a strong market presence.
- Benefits: Competitive salary, bonuses, and perks with opportunities for professional growth.
- Other info: Collaborate cross-functionally and influence key business decisions.
- Why this job: Make a real impact on commercial decisions and work with cutting-edge data tools.
- Qualifications: 3+ years in analytics, strong SQL skills, and experience with ERP systems.
The predicted salary is between 50000 - 60000 € per year.
About the Company
Our client, a long-standing partner of over two decades, is a well-established international sportswear and fashion business operating across wholesale (B2B), retail, and ecommerce channels. The company supplies major global retailers and manages a portfolio of recognised apparel and consumer brands. As part of its continued growth, the business is investing heavily in Power BI, data modelling, reporting, and commercial analytics to improve visibility across sales, inventory, operations, and finance.
The Role
This is a hands-on Senior Strategy Analyst – Business Intelligence role with full ownership of the Power BI environment and reporting ecosystem. You will be responsible for:
- Building and managing Power BI dashboards and data models
- Integrating data from ERP, finance (e.g. Sage), and operational systems
- Delivering insights across inventory, sales, margin, and operations
This is not just a reporting role — it requires strong capability across SQL and data transformation.
Key Responsibilities
- Power BI & Data Ownership
- Own the end-to-end Power BI environment
- Build and maintain semantic models and datasets
- Write and optimise DAX measures and calculations
- Manage ETL processes and data transformations
- Data Integration (ERP / Finance / Operations)
- Integrate data from ERP systems
- Finance systems (e.g. Sage)
- Operational data sources
- Ensure data accuracy, consistency, and performance
- Commercial & Operational Reporting
- Product and territory performance
- Margin analysis and pricing insights
- Channel performance (wholesale, retail, ecommerce)
- Inventory & Stock Analysis
- Inventory levels and stock movements
- Sell-through and stock coverage
- Inventory valuation and ageing
- Clearance and markdown analysis
- Operations & Warehouse
- Order book visibility
- OTIF performance
- Warehouse efficiency and turnaround time
- Finance Reporting
- Revenue and margin tracking
- Forecasting and performance analysis
- Customer and supplier insights
- Inventory & Order Book Management
- Maintain and monitor order book data
- Ensure accuracy of inventory data in ERP systems
- Identify and resolve data and reporting issues
- Insights & Stakeholder Engagement
- Deliver management and executive-level reporting
- Work cross-functionally with Sales, Finance and Operations teams
Required Skills & Experience
- Technical Skills
- Strong SQL and understanding of data structures
- Experience with ETL processes and large datasets
- Experience working with ERP systems
- Advanced Excel skills
- Commercial & Analytical Skills
- Strong understanding of margin and pricing
- Inventory and stock flow
- Ability to translate data into commercial insights
- Strong attention to detail and data accuracy
- Experience
- 3+ years in Commercial Analytics, FP&A, Retail / business analytics
- Experience in the following is highly desirable: Wholesale / retail / ecommerce, Apparel, fashion, or consumer goods
Ideal Profile
You may currently be working as:
- Business Intelligence Analyst
- Power BI Analyst
- Commercial Analyst
- FP&A Analyst (data-focused)
- Data Analyst (SQL / Power BI)
What This Role Offers
- Ownership of Power BI and reporting environment
- Exposure to commercial and operational decision-making
- Work across inventory, sales, finance, and operations
- Opportunity to influence pricing, stock, and performance decisions
- Excellent salary, bonus and other perks.
Strategy Analyst – Business Intelligence in London employer: Provallar Executive Search
As a leading international sportswear and fashion business, our client offers an exceptional work environment that fosters innovation and collaboration. Employees enjoy a culture of continuous learning with ample opportunities for professional growth, particularly in data analytics and commercial insights. With competitive salaries, bonuses, and a commitment to employee well-being, this company is an ideal place for those looking to make a meaningful impact in the retail and ecommerce sectors.
StudySmarter Expert Advice🤫
We think this is how you could land Strategy Analyst – Business Intelligence in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions related to Power BI, SQL, and commercial analytics. We recommend doing mock interviews with friends or using online platforms to boost your confidence.
✨Tip Number 3
Showcase your skills! Create a portfolio of your Power BI dashboards and data models. This will give potential employers a tangible look at what you can do and set you apart from other candidates.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Strategy Analyst – Business Intelligence in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Strategy Analyst role. Highlight your Power BI, SQL, and commercial analytics experience to show us you’re the perfect fit!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to tell us why you're passionate about business intelligence and how your background in data analysis can help us improve our reporting ecosystem.
Showcase Your Technical Skills:Don’t forget to mention your technical prowess! We want to see your experience with ETL processes, ERP systems, and advanced Excel skills clearly laid out in your application.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss any important updates from our team!
How to prepare for a job interview at Provallar Executive Search
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, SQL, and any ERP systems mentioned in the job description. Brush up on your DAX skills and be ready to discuss how you've used these tools in past roles. Being able to demonstrate your technical expertise will set you apart.
✨Prepare Real-World Examples
Think of specific projects where you’ve built dashboards or conducted data analysis that led to actionable insights. Be ready to explain your thought process, the challenges you faced, and how you overcame them. This shows you can apply your skills effectively in a real-world context.
✨Understand the Business Context
Familiarise yourself with the sportswear and fashion industry, especially regarding inventory management and commercial analytics. Knowing how your role as a Strategy Analyst fits into the bigger picture will impress interviewers and show your genuine interest in the company.
✨Engage with Stakeholders
Since this role involves working cross-functionally, think about how you would communicate insights to different teams. Prepare to discuss how you’ve collaborated with sales, finance, or operations in the past, and be ready to share your approach to stakeholder engagement.
