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

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

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
Data Analyst: Power BI & SQL Insights for Growth
Data Analyst: Power BI & SQL Insights for Growth

Third Space • Greater London

Remote
GBP 45,000 - 65,000
Competitive bonus
Complimentary group membership
Membership after year for a friend or
+2
Senior BI & Insight Analyst (Power BI, SQL, DAX)
Senior BI & Insight Analyst (Power BI, SQL, DAX)

Harnham • Greater London

Hybrid
GBP 60,000 - 90,000
Data Analyst: SAP & Power BI Insights (Southampton)
Data Analyst: SAP & Power BI Insights (Southampton)

Manpower UK • Southampton

On-site
GBP 48,000 - 85,000
Data Analyst
Data Analyst

Vivo Talent Solutions • Birmingham

Hybrid
GBP 37,000 - 39,000
BI Analyst | Power BI & SQL for Impact
BI Analyst | Power BI & SQL for Impact

WFS Patron • Greater London

On-site
GBP 48,000 - 52,000
26 days’ holiday + bank holidays
Hybrid working available
Gym access
+2
Senior Data Analyst: Drive Strategy with SQL & Power BI
Senior Data Analyst: Drive Strategy with SQL & Power BI

Liquidline • Ipswich

On-site
GBP 54,000 - 66,000
25 Days Annual Leave
Bank Holidays
Company Bonus Scheme
+9
BI Analyst: Power BI Dashboards & SQL Analytics On-site
BI Analyst: Power BI Dashboards & SQL Analytics On-site

Viqu Limited • Cambourne

On-site
GBP 34,000 - 42,000
Referral bonus
People Insights Data Analyst — Power BI & Advanced Analytics
People Insights Data Analyst — Power BI & Advanced Analytics

Costa Coffee • St Albans

Hybrid
GBP 45,000 - 65,000
Share Investment Plan (SIP)
Annual discretionary bonus
Pension with 10% match
+3
Power BI & Finance Analytics Engineer
Power BI & Finance Analytics Engineer

Sainsbury’s Group • City of Westminster

On-site
GBP 45,000 - 65,000
Colleague discount: 10% off shopping
Pensions scheme and life cover
Performance bonus up to 20% of salary
+1