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