Senior Member Data Analyst

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.

• 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.

• Strong experience working with UK Defined Benefit pension scheme data.
• Knowledge of pension administration platforms and underlying member data structures. (Intelli Pen experience is highly desirable)
• Experience with in 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.

• 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.

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.

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.