People Insights Data Analyst — Power BI & Advanced Analytics

Costa Coffee; St Albans; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Share Investment Plan (SIP)

Annual discretionary bonus

Pension with 10% match

Costa Financial Support Fund

50% discount in Costa stores

Private medical cover

Job summary

Costa Coffee is seeking a Data Analyst (People Insights) to transform complex people data into trusted insights that guide decisions across the business. You will own end-to-end Power BI analytics, design semantic models, and translate workforce data into clear executive reports.

We value advanced analytics, SQL, and DAX skills, with opportunity to explore predictive analytics and machine learning. The role blends home working with in-person collaboration at our St Albans support centre.

Qualifications

• Advanced Power BI, SQL, DAX and Power Query capability.
• Strong relational and dimensional modelling knowledge.
• Experience owning analytics or reporting initiatives end to end within an enterprise Data & Analytics environment.

Responsibilities

• Owning complex Power BI reporting end-to-end, from business questions to adopted outcomes.
• Designing and governing reusable semantic models and enterprise standards.
• Translating workforce data into executive-level reporting and clear narratives.
• Delivering compliant, audit-ready outputs including Gender Pay Gap reporting and headcount reporting.
• Developing insights using predictive methods and ML techniques to inform actions.
• Driving data quality, automation and standardisation while mentoring analysts.

Skills

Power BI

SQL

DAX

Power Query

Stakeholder management

Tools

Power BI

SQL

DAX

Power Query

Python (basic)

Job description

Costa Coffee is seeking a Data Analyst (People Insights) to transform complex people data into trusted insights that guide decisions across the business. You will own end-to-end Power BI analytics, design semantic models, and translate workforce data into clear executive reports.

We value advanced analytics, SQL, and DAX skills, with opportunity to explore predictive analytics and machine learning. The role blends home working with in-person collaboration at our St Albans support centre.