Data Analyst

Black Sheep Coffee Head Office

London Borough of Southwark

On-site

GBP 30,000 - 50,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Discretionary yearly bonus - up to 15%
Phone bills reimbursed (up to £50)
33 days holiday - including bank holds
Monthly in-store Coffee Allowance
Quarterly At-home Coffee Order
30% discount on food and drink items
Fully stocked fridge with breakfast
Recognition and rewards through our EP
Pension through NEST
Long Service Reward Scheme
Enhanced Maternity Pay
Weekly cash plan via Stream
Build Pots savings boost via Stream
Stream retailer discounts

Job summary

Black Sheep Coffee is seeking a hands-on Data Analyst to turn complex business questions into reliable reporting, clear insight and practical improvements. You will use SQL and Power BI to build reporting used by Operations, Finance and other teams across our stores, and to investigate urgent issues like unusual sales or labour figures.

The role requires independent work, strong communication with stakeholders and a focus on delivering solutions rather than just reports.

Qualifications

  • 3+ years in Data Analyst/BI Analyst roles with SQL and Power BI proficiency.
  • Strong T-SQL skills with joins, CTEs and window functions.
  • Proven ability to validate queries and own reporting accuracy.
  • Commercial mindset with numeracy and problem-solving under pressure.
  • Confident in stakeholder management and communicating findings.
  • Proactive, organized and able to drive process improvements.

Responsibilities

  • Write and troubleshoot SQL queries to investigate business questions and reconcile data.
  • Build and improve Power BI dashboards and semantic models (DAX, data modelling, performance).
  • Collaborate with Operations, Finance and other stakeholders to deliver practical reporting solutions.
  • Respond to urgent reporting issues, investigate root causes and prioritise effectively.
  • Deliver actionable analysis across store sales, labour, budgets and profitability.
  • Support automation and lasting change, including potential Fabric migration in 2027.

Skills

SQL
Power BI
Stakeholder management
Analytical thinking
Independent working

Tools

Microsoft Fabric
Azure SQL
Azure Data Factory

Job description

Data Analyst - Black Sheep Coffee

Role: Data Analyst

Contract type: Permanent

Place of work: Black Sheep Coffee Support Office, Southwark (full-time onsite)

Department: Data & Analytics

Salary: Up to £50,000, depending on experience

Position profile and role summary

Black Sheep Coffee is looking for a hands‑on Data Analyst who can turn complex business questions into reliable reporting, clear insight and practical improvements. This is a role for someone who enjoys solving problems, takes ownership and actively looks for better ways of working.

SQL and Power BI are at the heart of the role. You will build and improve reporting used by Operations, Finance and other teams across our stores, while also investigating urgent issues such as unusual sales or labour figures, failed dashboard refreshes and inconsistencies between systems.

You will work directly with stakeholders to understand what they need, challenge assumptions where appropriate and deliver solutions rather than simply produce reports. We need someone who can balance reactive support with longer‑term improvement work, communicate confidently and drive changes through to completion.

Role responsibilities
  • Write and troubleshoot SQL queries to investigate business questions, validate figures, reconcile data across systems and ensure reporting is accurate and consistent.
  • Build, own and improve Power BI dashboards and semantic models, including DAX, data modelling, performance, refresh reliability and usability.
  • Work directly with Operations, Finance, People and other stakeholders to understand needs, challenge assumptions, explain findings and deliver practical reporting solutions.
  • Respond to urgent reporting issues, unexpected results and ad hoc requests; investigate root causes, resolve problems and manage competing priorities while keeping stakeholders informed.
  • Deliver actionable analysis across store sales, like-for‑like performance, labour, budgets, bonuses, profitability, product availability and customer experience.
  • Proactively improve and automate reporting and processes, working with Data Engineering and business teams to deliver lasting change and support the potential Microsoft Fabric migration in 2027.
Essential requirements
  • At least 3 years' experience in a Data Analyst, BI Analyst or similar role, with proven ability to work independently using SQL and Power BI.
  • Strong, independent T-SQL skills, including joins, CTEs, window functions and troubleshooting; able to explain and validate queries without relying on AI.
  • Strong Power BI skills in DAX, Power Query, data modelling and report performance, with ownership of reporting accuracy and reliability.
  • A quick-thinking, commercially minded problem‑solver with strong numerical accuracy, able to investigate unfamiliar issues and recommend practical action under pressure.
  • Confident stakeholder management, with the ability to challenge requirements, communicate findings and influence colleagues across the business.
  • Proactive, organised and accountable, with the drive to improve processes, deliver change and manage priorities independently.
Desirable experience
  • Experience with Microsoft Fabric, Azure SQL, Azure Data Factory, data pipelines or APIs, ideally including a BI/data‑platform migration.
  • Experience in QSR, hospitality, retail or another multi‑site business, and using AI tools to improve analysis while independently validating results.
Our Benefits
  • Discretionary yearly bonus - up to 15%
  • Phone bills reimbursed (up to £50)
  • 33 days holiday - including bank holidays
  • Monthly in-store Coffee Allowance
  • Quarterly At-home Coffee Order
  • 30% discount on food and drink items in all our locations
  • Fully stocked fridge with breakfast items and soft drinks
  • Recognition and rewards through our employee of the month scheme
  • Pension through NEST
  • Long Service Reward Scheme
  • Enhanced Maternity Pay
  • Weekly cash plan (money when you need it through Stream)
  • Increase your monthly savings with a percentage boost on Build Pots through Stream
  • Access to hundreds of high street retailer discounts through Stream
  • Access to a Financial Coach via Stream
  • Employee Assistance Programme for when you need advice through Hospitality Action
  • Access to a fully comprehensive wellness app offered as part of our employee assistance programme, including fitness, nutrition, wellbeing and mental health resources
  • Training and opportunity to progress your career
  • End of month drinks
  • Summer & Winter Socials
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Analyst
BI Analyst

Blue Light Card • Camden Town

Hybrid
GBP 45,000 - 65,000
25 days annual leave
Moments that Matter day
Annual company bonus
+5
Data Analyst: SQL & Power BI Expert, Onsite in Southwark
Data Analyst: SQL & Power BI Expert, Onsite in Southwark

Black Sheep Coffee Head Office • London Borough of Southwark

On-site
GBP 30,000 - 50,000
Discretionary yearly bonus - up to 15%
Phone bills reimbursed (up to £50)
33 days holiday - including bank holds
+11
BI Analyst
BI Analyst

Blue Light Card • Greater London

Hybrid
GBP 48,000 - 60,000
Bonus scheme
Private medical
Pension scheme
+4
Senior Data Analyst
Senior Data Analyst

Maria Mallaband Care Group • United Kingdom

On-site
GBP 45,000 - 65,000
Private medical cover (Bupa) – company funded
25 days holiday + bank holidays
Discounts across top retailers, leisure, and hospitality
+4
Senior Analytics Engineer
Senior Analytics Engineer

Soho House Group • Greater London

Hybrid
GBP 70,000 - 110,000
Annual Every House Membership
50% off Food & Drink
Staff Room Rates
+8
Senior BI Analytics Engineer
Senior BI Analytics Engineer

Carwow • Greater London

Hybrid
GBP 75,000 - 110,000
Hybrid working
Competitive salary
Share options
+6
Senior Analytics Engineer Digital & IT London, UK Support Office View Role
Senior Analytics Engineer Digital & IT London, UK Support Office View Role

Soho House & Co. • Greater London

Hybrid
GBP 70,000 - 110,000
Every House Membership
Food & Drink discount 50%
Staff Room Rates
+4
Finance Data Analyst
Finance Data Analyst

GB Global • Brentwood

On-site
GBP 45,000 - 65,000
Competitive salary
Discretionary bonus
Pension
+6
Head of Data
Head of Data

Club L London Limited • Manchester

On-site
GBP 120,000 - 160,000
Annual bonus
Dress allowance
25 days annual leave
+11
Data Analytics Manager
Data Analytics Manager

Wave • North East

Hybrid
GBP 60,000 - 90,000
Excellent pension scheme
Bonus potential
Perkbox membership
+6