The BI Analyst will develop Power BI solutions, collaborate with stakeholders, and utilize Databricks for dataset transformation while ensuring effective communication of analytical findings.
Role: BI Analyst
Location: London or Romford - (Hybrid - 2 days office)
Salary: Competitive
Department: IT & Systems
Contract: 12m FTC
Power BI Development
Location: London or Romford - (Hybrid - 2 days office)
Salary: Competitive
Department: IT & Systems
Contract: 12m FTC
Power BI Development
- 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
Key Responsibilities
Communication & Collaboration with Stakeholders
- 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
Databricks & Analytical Engineering
- 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
Skills Knowledge and Expertise
Essential
- 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
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
Benefits
Benefits
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. We are proud of the benefits we offer our employees which include:
- 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
About the National Centre for Social Research
At The National Centre for Social Research, we believe that social research has the power to make life better. By really understanding the complexity of people’s lives and what they think about the issues that affect them, we give the public a powerful and influential role in shaping services that can make a difference to everyone. And as an independent, not-for-profit organisation we’re able to focus our time and energy on meeting our clients’ needs and delivering social research that works for society.
Our Values & Behaviors
We Are Curious
- Uses data to improve field performance and delivery
- Explores new approaches to workforce management
We Move with Purpose
- Drives delivery against operational targets
- Aligns workforce planning to demand
We Act with Integrity
- Ensures fair and compliant field practices
- Maintains quality and ethical standards
We are proud to say we are a Disability Confident Committed Employer, so if you require any reasonable adjustments during the interview process please make us aware and we will endeavor to support you to help you showcase your best self during our hiring process.
About
At The National Centre for Social Research we believe that social research has the power to make life better. By really understanding the complexity of people’s lives and what they think about the issues that affect them, we give the public a powerful and influential role in shaping services that can make a difference to everyone. And as an independent, not-for-profit organisation we’re able to focus our time and energy on meeting our clients’ needs and delivering social research that works for society.
Similar Jobs
Fintech • Mobile • Payments • Software • Financial Services
The Senior Software Engineer will lead the Business Pricing team to develop and enhance account plans, emphasizing customer needs and collaboration with cross-functional teams.
Top Skills:
JavaKafkaKotlinRelational DatabasesSpring
Fintech • Mobile • Payments • Software • Financial Services
The Head of Specialised Support leads a global team overseeing Account Servicing, Enterprise Support, and Technical Integration to enhance client experience and drive commercial growth through proactive strategies and operational excellence.
Top Skills:
APIsCRMService DeskZendesk
Fintech • Information Technology • Financial Services
The role involves managing counterparty and trading risk, identifying risks, analyzing metrics, and collaborating with risk teams and stakeholders.
Top Skills:
ExcelPython
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
