Data Analyst, People Insights – Power BI & People Analytics

Costa Coffee; Park Street; Hybrid; GBP 55,000 - 85,000; Full time

Benefits offered by this job

Share SIP

Annual discretionary bonus

Smart pension

Costa Financial Support Fund

50% discount in Costa stores

Private medical cover

Job summary

Costa Coffee is seeking a Data Analyst (People Insights) to own complex Power BI reporting and analytics across the workforce. You’ll design reusable semantic models, govern DAX/Power Query solutions, and translate data into executive-level narratives for informed people decisions.

You’ll also deliver auditable outputs (Gender Pay Gap, pensions, headcount) and develop advanced insights, including predictive analytics, while coaching peers within the Analytics Centre of Excellence.

Qualifications

• An experienced analyst with advanced Power BI, SQL, DAX and Power Query capability, together with strong relational and dimensional modelling knowledge.
• Confident working with senior stakeholders, challenging assumptions and turning complex or ambiguous questions into high-value analytical outcomes.
• Experienced in owning complex analytics or reporting initiatives end to end within an enterprise Data & Analytics environment.
• A structured problem-solver who can combine multiple data sources, identify trade-offs and present evidence-based recommendations.
• Curious about advanced analytics, with experience or a strong interest in applying statistical and machine learning techniques (e.g. Python, R or Databricks) to turn insight into practical, ethical and explainable actions.

Responsibilities

• Owning complex Power BI reporting and analytics solutions end to end, from ambiguous business questions through to adopted outcomes.
• Designing and governing reusable semantic models, advanced DAX and Power Query solutions aligned to enterprise standards.
• Translating workforce data into clear narratives, recommendations and executive-level reporting that explain the “so what”.
• Delivering accurate, compliant and audit-ready outputs, including Gender Pay Gap reporting, pensions audits, headcount reporting and regulatory submissions.
• Developing advanced insights, including predictive and machine learning models (such as attrition risk, absence and workforce forecasting), that move beyond describing what happened to recommending targeted actions.
• Driving automation, performance, data quality and standardisation while coaching analysts and contributing to the Analytics Centre of Excellence.

Skills

Power BI

SQL

DAX

Power Query

Stakeholder management

Data modelling

Python

R

Databricks

Job description

Costa Coffee is seeking a Data Analyst (People Insights) to own complex Power BI reporting and analytics across the workforce. You’ll design reusable semantic models, govern DAX/Power Query solutions, and translate data into executive-level narratives for informed people decisions.

You’ll also deliver auditable outputs (Gender Pay Gap, pensions, headcount) and develop advanced insights, including predictive analytics, while coaching peers within the Analytics Centre of Excellence.