Senior Member Data Analyst
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.
Apply Now!
- Department
- Data Services
- Role
- Member Data Analyst
- Location
- Chesterfield
- Employment Type
- Permanent
About Brightwell
Brightwell is the primary service provider providing fiduciary management services, member services, operational and secretariat services to the £37bn BT Pension Scheme (BTPS), one of the largest private sector pension schemes in the UK with c.260,000 members.
Brightwell also provides fiduciary management services to the defined benefit section of the EE Pension Scheme (EEPS) which has c.£1bn AUM and 8,000 members and is the administrator for the Mineworkers’ Pension Scheme (MPS) which has c.6,000 deferred members and 110,000 pensioners in payment.