At a Glance
- Tasks: Analyse retail data and transform trends into engaging insights for stakeholders.
- Company: Join a dynamic team at the forefront of retail and digital commerce.
- Benefits: Up to £35,000 salary, performance bonus, and career development opportunities.
- Why this job: Make a real impact in the retail industry while developing your analytical skills.
- Qualifications: 1-2 years of analyst experience with strong Excel and SQL skills.
- Other info: Enjoy autonomy and responsibility in a fast-paced, tech-focused environment.
The predicted salary is between 28000 - 42000 £ per year.
We’re looking for a Retail Analyst to join a dynamic, entrepreneurial team working at the heart of the retail and digital commerce industry. This is a hands-on role offering real autonomy, variety, and the opportunity to make a genuine impact.
You’ll support and develop a well-established retail data analysis programme, working with large-scale market data and turning complex trends into clear, compelling insights for members, stakeholders, and live audiences.
What you’ll be doing- Data & Reporting
- Work closely with the Retail & Data Director to build and develop a major retail market Index
- Manage the weekly production of market reporting using SQL, Azure and Excel
- Carry out anomaly detection across weekly and monthly data submissions and index results
- Liaise with retail members to ensure accurate and consistent data collection
- Transform and maintain historic retailer submissions into a master dataset using Power Query and Excel
- Support retail members in setting up and improving their data submission processes
- Maintain a clean, well-organised retail membership CRM database
- Insights & Analysis
- Analyse index data to identify market trends and translate them into shareable insights
- Create monthly insight packs for the commercial/sales team
- Help plan and develop presentations for industry events and breakfast briefings
- Analyse GA4 data from retail panels and shape it into publishable insight content
- Devise and deliver new data and research studies for the wider insights programme
- Produce a weekly insight piece for webinars and LinkedIn
- Play a key role in the ongoing improvement of the digital dashboard (Power BI)
- Present insights to retail audiences via member calls and live events
- Collaborate with marketing to promote the latest insights across events and channels
- Medium to advanced Microsoft Excel skills
- Experience querying databases using MS SQL Server
- Knowledge of Power BI and Power Query (desirable)
- Strong analytical skills with the ability to turn data into meaningful, engaging insight
- Ability to manage multiple projects and deliver to deadlines
- Experience with Google Analytics or Adobe Analytics (a plus)
- Confidence turning research and analysis into clear presentations
- Absolute discretion when handling confidential information
- Ability to perform well under pressure — with a sense of humour
- The satisfaction of seeing your work directly influence an industry
- Opportunities to develop your analytical and presentation skills
- Autonomy, responsibility, and the chance to make your mark quickly
- Career development in a fast-moving digital and tech-focused environment
- A fair remuneration package with a performance-related bonus
You’ll likely have 1–2 years’ experience in an analyst role, ideally with exposure to online retail. Experience simplifying complex data trends into sharp, concise conclusions is highly valued, along with an understanding of how retailers analyse, collate, and report performance.
Retail Analyst in City of London employer: House Recruiting
Contact Detail:
House Recruiting Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Retail Analyst in City of London
✨Tip Number 1
Network like a pro! Reach out to people in the retail industry on LinkedIn or at events. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio of your data analysis projects, especially if you’ve worked with SQL, Excel, or Power BI. This will give potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by practising common questions related to data analysis and retail trends. We recommend using real-world examples from your experience to showcase your analytical skills.
✨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!
We think you need these skills to ace Retail Analyst in City of London
Some tips for your application 🫡
Show Off Your Skills: Make sure to highlight your medium to advanced Microsoft Excel skills and any experience you have with SQL or Power BI. We want to see how you can turn complex data into clear insights, so don’t hold back!
Tailor Your Application: Take a moment to customise your CV and cover letter for the Retail Analyst role. Mention specific experiences that relate to the job description, especially those involving data analysis and reporting. It helps us see why you're a great fit!
Be Clear and Concise: When writing your application, keep it straightforward and to the point. We appreciate clarity, so make sure your key achievements and skills shine through without unnecessary fluff.
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’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at House Recruiting
✨Know Your Data Tools
Make sure you brush up on your Microsoft Excel, SQL, and Power BI skills before the interview. Be ready to discuss how you've used these tools in past roles, especially in analysing data and generating insights.
✨Showcase Your Analytical Skills
Prepare examples of how you've turned complex data into clear insights. Think about specific projects where your analysis made a difference, and be ready to explain your thought process during the interview.
✨Understand the Retail Landscape
Familiarise yourself with current trends in the retail and digital commerce industry. Being able to discuss recent developments or challenges will show that you're engaged and knowledgeable about the field.
✨Practice Your Presentation Skills
Since you'll need to present insights to various audiences, practice explaining your findings clearly and concisely. Consider doing mock presentations to friends or family to build your confidence.