At a Glance
- Tasks: Transform customer data into actionable insights for the MyFenwick Loyalty programme.
- Company: Fenwick, a historic and innovative family-owned department store.
- Benefits: Up to 25% discount, 33 days annual leave, hybrid working, and wellbeing support.
- Other info: Join a collaborative team driving innovation in a rich heritage setting.
- Why this job: Make a real impact on customer engagement and retention in a dynamic retail environment.
- Qualifications: 3+ years in customer insights, strong SQL and Python skills, and dashboard development experience.
The predicted salary is between 50000 - 50000 £ per year.
Are you a data-driven analyst with a passion for customer behaviour and CRM insight, looking for a new challenge within a fast-paced retail environment? If so, we have an exciting opportunity for you to join us as a Loyalty & CRM Insight Analyst (Customer Analyst) on a 6-month fixed-term contract, where you’ll play a key role in shaping and developing the MyFenwick Loyalty programme through actionable insight and analysis.
We offer hybrid working between your home and our offices on Wigmore Street, Central London, offering a collaborative and innovative working space. When you join Fenwick, you’ll receive:
- Up to 25% discount in all Fenwick stores and fenwick.co.uk.
- 33 days annual leave (inclusive of 8 bank holidays) - pro rata to the length of your contract.
- WeCare - 24/7 GP, wellbeing advice & support service.
- Hybrid Working (typically Thursday & Friday working from home).
About the role
We’re looking for a Loyalty & CRM Insight Analyst to help transform the MyFenwick Loyalty programme into a high-performing, data-driven growth engine. You’ll play a key role in turning rich customer data into clear, actionable insight that shapes how we target, engage, reward, and retain our members. From identifying high-value customer segments to uncovering opportunities to improve retention and lifetime value, your work will directly influence decision-making across the business.
In this role, you’ll work closely with CRM, BI & IT, Marketing, Digital, Buying & Merchandising, and Finance teams to deliver insight that drives meaningful commercial impact. You’ll analyse customer behaviour across both in-store and online channels, build segmentation models, and identify opportunities to improve the customer lifecycle, reduce churn, and optimise campaign performance. You’ll also design and maintain dashboards and reporting tools using platforms such as Power BI, Qlik, or Tableau to provide clear visibility of loyalty programme performance.
We’re looking for someone with at least 3 years’ experience in a customer insights or analytics role, with strong proficiency in SQL and Python for data extraction and analysis. You’ll bring advanced Excel skills, experience in dashboard development, and the ability to translate complex data into simple, compelling insight. Strong analytical thinking, attention to detail, and commercial awareness are essential, along with the ability to communicate findings effectively and influence stakeholders with a customer-first mindset.
What we are looking for in a candidate:
- 3+ years in a customer insights role.
- Strong proficiency in SQL and Python for data extraction, manipulation, and analysis.
- Experience building dashboards using tools such as Qlik, Power BI or Tableau.
- Advanced Excel skills (modelling, pivot tables, data analysis).
- Confident communicator who can tailor messages for both technical and non-technical audiences.
- Skilled in data-driven storytelling.
- Commercially minded with a strong understanding of how insight drives customer retention.
About Fenwick
Fenwick is rich with heritage and history and have been style pioneers since 1882 when our first store opened. We know luxury and are proud to remain the largest independent, family-owned group of department stores within the UK. We are on an exciting journey to exceed our customers' expectations and we are always on the lookout for new talent to join us.
Our collaborative spirit unites a workforce of over 2,000 individuals across our stores, as well as in our support functions, encompassing Digital, Buying & Merchandising, IT, Finance, People, Customer Service teams, and our cherished restaurants and distribution centres. In 2023 we launched our ‘Quiet No More’ campaign, enhancing our presence on the UK high street as well as our eCommerce website going from strength to strength. Together, we form the beating heart of Fenwick, driving forward our vision for excellence and innovation. Join us as we pave the way toward an even brighter tomorrow, where tradition meets transformation!
Analyst - Python, SQL in City of London employer: Fenwick
Fenwick is an excellent employer, offering a dynamic work culture that fosters collaboration and innovation within the ecommerce sector. With hybrid working options in the heart of Central London, employees enjoy extensive annual leave, staff discounts, and ample opportunities for professional growth, making it a rewarding place to advance your career while maintaining a healthy work-life balance.
StudySmarter Expert Advice🤫
We think this is how you could land Analyst - Python, SQL in City of London
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Fenwick before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Fenwick.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Fenwick.
We think you need these skills to ace Analyst - Python, SQL in City of London
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Fenwick, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Fenwick, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Fenwick’s attention and show the tangible impact of your work.
How to prepare for a job interview at Fenwick
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Fenwick.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Fenwick.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Fenwick.
