Senior Member Data Analyst

Brightwell; Chesterfield; On-site; GBP 60,000 - 80,000; Full time

Benefits offered by this job

Annual performance bonus

25 days holiday + bank holidays

Pension contributions

Life insurance

Health checks and wellbeing benefits

Job summary

Brightwell in Chesterfield is seeking a Senior Member Data Analyst to lead data quality and value improvements for member data in UK defined benefit pensions. You will work with pensions administration, actuarial and client teams to tackle data challenges, deliver high-quality extracts, and drive data governance.

The role emphasizes analytical problem-solving, advanced SQL skills, and automated reporting to support regulatory and client reporting needs while enabling accurate member outcomes.

Qualifications

• Strong experience with UK Defined Benefit pension scheme data.
• Knowledge of pension administration platforms and member data structures (IntelliPen desirable).
• Experience in pension administration, pensions consulting or in-house pensions environment.
• Advanced SQL/T-SQL and large, complex datasets.
• Proven experience developing data extracts, reconciliations and automated reporting solutions.
• Experience investigating and resolving data quality issues.
• Strong analytical and problem-solving skills with attention to detail.
• Advanced Excel skills.
• Ability to communicate complex technical information clearly.

Responsibilities

• Develop, analyse and validate member data extracts to support business and client requirements.
• Automate, repeatable data solutions using SQL and other analytical tools.
• Deliver actuarial valuation data and client reporting requirements.
• Investigate and resolve data quality issues, identifying root causes and improvements.
• Produce meaningful data quality metrics and dashboards.
• Collaborate with stakeholders to understand requirements and translate them into data solutions.
• Support data governance, controls and working practices; assist on data quality initiatives.

Skills

Analytical skills

SQL/T-SQL

Communication skills

Excel (Advanced)

Data quality

Problem solving

Tools

IntelliPen

Power BI

Databricks

Microsoft Fabric

Job description

Senior Member Data Analyst

Join Our Team as Senior Member Data Analyst

Location: Chesterfield

An exciting opportunity has arisen for an experienced pensions data professional to join Brightwell as a Senior Member Data Analyst, taking on a key role in improving the quality and value of member data.

You’ll use your pensions knowledge and analytical expertise to solve complex data challenges, identify opportunities for improvement and ensure member data is accurate, reliable and fit for purpose. Working closely with pension administration, actuarial and client teams, you’ll contribute to a varied range of data improvement initiatives, valuations, regulatory requirements and strategic projects.

If you’re looking for a role where you can take ownership, influence improvements and make a genuine impact on member outcomes, this could be a great next step.

What you’ll do:

• Development, analysis and validation of member data extracts to support a range of business and client requirements.
• Automated, repeatable data solutions using SQL and other analytical tools.
• Delivery of actuarial valuation data and other client reporting requirements.
• Investigation and resolution of data quality issues, including root cause identification and improvements.
• Production of meaningful data quality metrics.
• Close collaboration with stakeholders to understand requirements and translate them into effective data solutions.
• Continuous improvement of data governance, controls and working practices.
• Support for projects that enhance data quality, efficiency and member outcomes.

This role would suit someone with:

Essential

• Strong experience working with UK Defined Benefit pension scheme data.
• Knowledge of pension administration platforms and underlying member data structures. (IntelliPen experience is highly desirable)
• Experience within pension administration, pensions consulting or an in-house pensions environment.
• Advanced SQL/T-SQL skills and experience working with large and complex datasets.
• Proven experience developing data extracts, reconciliations and automated reporting solutions.
• Experience investigating and resolving data quality issues.
• Strong analytical and problem-solving skills with excellent attention to detail.
• Advanced Excel skills.
• The ability to communicate complex technical information clearly and effectively.

Desirable

• Experience with modern data platforms such as Microsoft Fabric or Databricks.
• Knowledge of The Pensions Regulator's data quality requirements and reporting standards.
• Experience of pensions data cleanse, remediation or rectification projects.
• Exposure to insurer or bulk annuity data requirements.
• Experience supporting actuarial valuation data exercises.
• Experience of onboarding new client data
• Power BI reporting and dashboard development.

Why Brightwell?

As a Brightwell colleague, you will enjoy a competitive salary, hybrid work practices, professional development, career development, and a great benefits package including:

• Annual performance bonus
• 25 days holiday (increasing to 30 with service) plus bank holidays.
• A pension with 15-17% employer contributions (depending on age).
• 8 x salary Life Insurance.
• Generous family friendly policies, including up to 26 weeks full pay (maternity, adoption and paternity leave)
• Free health assessments.
• Health cash plan.
• Professional study support.
• Employee Assistance Programme and free Wellhub wellness network platform access.

Building an inclusive work environment:

Brightwell is committed to developing and maintaining an inclusive culture, ensuring that behaviours, working practices, and policies promote fair treatment and access to development opportunities for every colleague. We value the benefits a diverse workforce can bring and want Brightwell to be a place where all colleagues can thrive, feel that they belong, are valued, and contribute to our success. This is underpinned by Brightwell’s RISE corporate values: Responsible, Impactful, Supportive & Expert.