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 NatCen 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

Significant hands-on experience delivering enterprise PowerBI 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
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

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

BI Analyst, 12 Month Contract

Key skills