BI Analyst

BI Analyst - 12 month contract

Final date to receive applications: 29 May 2026

Department: Social Surveys

Employment Type: Contract / Temp

Location: London (Hybrid)

Compensation: £43,000 - £52,000 / year

Role: BI Analyst
Location: London or Romford (Hybrid – 2 days office)
Salary: Competitive
Department: IT & Systems
Contract: 12m FTC

• Deliver enterprise‑grade Power BI solutions, including advanced DAX, Power Query (M) transformations, semantic modelling, and performance optimisation
• Build interactive dashboards and reports aligned to user needs and Nat Cen UI/UX standards
• Ensure visualisations meet accessibility, clarity, and interpretability principles for research and operational users

• Communicate technical concepts clearly to non‑technical colleagues
• Present analytical findings in ways that are easy to understand and act on
• Work collaboratively with Data Architect, researchers, and organisational leads to deliver shared outcomes
• Partner with colleagues across Research, Operations, Finance, HR, and Data Services to define, document, and validate reporting requirements
• Facilitate workshops, walkthroughs, and feedback sessions to ensure outputs meet organisational and research needs
• Translate business questions into analytical designs, KPIs, and executive‑ready reporting outputs

• Use Databricks to transform curated datasets into analytics‑ready semantic tables/datasets
• Write high‑quality SQL; familiarity with PySpark and Databricks is desirable
• Work closely with the Data Architect, who owns core Databricks platform design, to ensure analytical datasets align with enterprise models and standards

Essential

• Significant hands‑on experience delivering enterprise Power BI solutions with a proven background
• Strong DAX, Power Query, and semantic model design skills
• Strong grounding in dimensional modelling and analytics best practice
• Experience turning ambiguous requirements into well‑defined specifications
• Ability to document requirements, manage changes, and maintain traceability throughout delivery
• Strong communication skills and the ability to influence and collaborate effectively

Desirable

• Experience using Databricks in research, public sector, social statistics, or financial analytics contexts
• Excellent SQL capabilities and practical experience with large‑scale data pipelines
• Exposure to PySpark or Python in a data engineering or analytics environment
• Familiarity with research data structures, survey data, or longitudinal datasets
• Experience contributing to organisational data governance frameworks
• Experience working in Agile delivery environments

As well as a competitive salary, attractive bonus structure and excellent working environment (including a home/office hybrid working environment), you will be working for the largest independent social research organisation in the UK.

• 25 days holiday (plus 8 bank holidays) and flexible working
• Generous company pension scheme
• Life insurance and health cash plan
• Cycle to Work scheme and season ticket loan
• Career development, professional subscriptions support and mentoring support from industry‑leading experts

We are proud to say we are a Disability Confident Committed Employer; if you require any reasonable adjustments during the interview process please make us aware and we will endeavour to support you to help you showcase your best self during our hiring process.