Data & BI Analyst

Data & BI Analyst

Entry level 30000 - 40000 £ / year (est.) Home office (partial)
Fenwick

At a Glance

  • Tasks: Analyse data, improve quality, and develop business intelligence solutions.
  • Company: Join Fenwick, the UK's largest family-owned department store group.
  • Benefits: Enjoy 25% discount, 33 days leave, and hybrid working options.
  • Why this job: Kickstart your data career with hands-on experience in modern platforms.
  • Qualifications: Strong analytical skills; basic SQL knowledge is a plus.
  • Other info: Great development pathway into a BI Developer role.

The predicted salary is between 30000 - 40000 £ per year.

We have an exciting opportunity for a Data & BI Analyst to join our IT Data team at Fenwick, based in our Newcastle office.

What’s in it for you?

  • Up to 25% discount in all Fenwick stores and fenwick.co.uk
  • 33 days annual leave (inclusive of bank holidays)
  • Your birthday is an additional day of annual leave
  • WeCare – 24/7 GP, wellbeing advice & support
  • Hybrid working (3 days office / 2 days remote)

About the Role

This role sits within the Data & BI team and plays a key part in improving the quality, reliability, and usability of data across Fenwick. You will combine data analysis, data quality monitoring, and business intelligence development to both identify issues and help design scalable solutions that prevent them. This is an excellent opportunity for someone early in their data career looking to develop into a BI Developer or Data Engineer, working with modern platforms including Snowflake and cloud-based data tools.

Key Responsibilities

  • Data Quality & Governance
    • Monitor and assess data quality across key business systems (e.g. D365, eCommerce, Finance)
    • Investigate data issues, identify root causes, and support resolution with business and IT teams
    • Work with stakeholders to improve data processes and prevent recurring issues
    • Support the development and maintenance of data quality dashboards and reporting
  • Data Analysis & BI Development
    • Build and maintain dashboards and reports using BI tools (e.g. Qlik, Power BI)
    • Write SQL queries to analyse and transform data
    • Support development of curated datasets within Snowflake
    • Assist with data modelling and reporting layer design
  • Automation & Continuous Improvement
    • Identify opportunities to automate manual data checks and processes
    • Support development of monitoring, alerting, and validation frameworks
    • Contribute to improving data pipelines and data flows across systems
    • Create clear documentation for processes, datasets, and reporting

What We’re Looking For

Essential

  • Strong analytical and problem-solving skills
  • Ability to work with data and draw meaningful insights
  • Confident communicating with both technical and non-technical stakeholders
  • Organised with attention to detail

Desirable (but not essential)

  • Basic SQL knowledge or experience working with databases
  • Experience with BI tools (Qlik, Power BI, Tableau, etc.)
  • Understanding of data modelling concepts
  • Awareness of cloud data platforms (e.g. Snowflake, Azure)
  • Experience with Excel for data analysis

Development Opportunity

This role is designed as a development pathway into a BI Developer position, providing hands-on experience across:

  • Modern cloud data platforms (Snowflake)
  • Data pipelines and transformation
  • Business intelligence and dashboarding
  • Data quality and governance frameworks

About Fenwick

Fenwick is the UK’s largest family-owned department store group with a rich heritage and an exciting future. We are investing in our data and digital capabilities to better serve our customers and support our business teams.

Data & BI Analyst employer: Fenwick

Fenwick is an exceptional employer that prioritises employee well-being and growth, offering a generous benefits package including up to 25% discount in stores, 33 days of annual leave, and a unique additional day off for your birthday. With a supportive work culture that embraces hybrid working and a clear pathway for career development into roles such as BI Developer or Data Engineer, Fenwick fosters an environment where data professionals can thrive and make a meaningful impact within the organisation.
Fenwick

Contact Detail:

Fenwick Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data & BI Analyst

✨Tip Number 1

Network like a pro! Reach out to current employees at Fenwick on LinkedIn or attend industry events. A friendly chat can give you insider info and maybe even a referral!

✨Tip Number 2

Prepare for the interview by brushing up on your SQL skills and BI tools. Practice common data analysis scenarios and be ready to showcase your problem-solving abilities with real examples.

✨Tip Number 3

Show your passion for data! During interviews, share your enthusiasm for data quality and governance. Talk about any personal projects or experiences that highlight your analytical skills.

✨Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re genuinely interested in joining the Fenwick team.

We think you need these skills to ace Data & BI Analyst

Data Analysis
Data Quality Monitoring
Business Intelligence Development
SQL
Dashboard Development
Data Modelling
Automation
Problem-Solving Skills
Communication Skills
Attention to Detail
Experience with BI Tools (Qlik, Power BI, Tableau)
Understanding of Cloud Data Platforms (Snowflake, Azure)
Organisational Skills

Some tips for your application 🫡

Tailor Your CV: Make sure your CV speaks directly to the Data & BI Analyst role. Highlight any relevant experience with data analysis, BI tools, and SQL. We want to see how your skills match what we're looking for!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're excited about this role at Fenwick and how you can contribute to our Data & BI team. Keep it personal and engaging – we love a good story!

Show Off Your Analytical Skills: In your application, don’t shy away from showcasing your analytical and problem-solving skills. Give examples of how you've tackled data issues in the past or improved processes. We’re keen to see your thought process!

Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and keep track of it. Plus, it shows you’re serious about joining our team!

How to prepare for a job interview at Fenwick

✨Know Your Data Tools

Familiarise yourself with the BI tools mentioned in the job description, like Qlik and Power BI. Be ready to discuss any experience you have with these tools or similar ones, and think of examples where you've used data analysis to solve problems.

✨Brush Up on SQL

Even if your SQL skills are basic, it’s essential to show that you understand how to write queries. Prepare a few simple SQL queries that demonstrate your ability to manipulate and analyse data. This will show your potential employer that you're eager to learn and grow in this area.

✨Communicate Clearly

Since you'll be working with both technical and non-technical stakeholders, practice explaining complex data concepts in simple terms. Think about how you would describe a data issue or solution to someone without a technical background, as this will be crucial in your role.

✨Show Your Problem-Solving Skills

Prepare to discuss specific examples where you've identified data issues and how you approached resolving them. Highlight your analytical skills and attention to detail, as these are key traits for a Data & BI Analyst at Fenwick.

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>