Data Analyst

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