Officer - MI Analyst | The Pensions Regulator Skip to main content

Your browser is out of date, and unable to use many of the features of this website

Please upgrade your browser.


This website requires cookies. Your browser currently has cookies disabled.

Officer - MI Analyst

Reporting to: MI and Analysis Manager
Team: Frontline Regulation
Contract type: Fixed- term for 12 months
Salary: From £26,218 per annum
Location: Brighton
Closing date: Thursday 12 December 2019

Ref: 1709

TPR grade: 11 - Officer

About us

TPR is responsible for protecting workplace pensions in the UK, working with employers and those running pensions to help people save safely for their retirement. We have an excellent office location in the heart of Brighton and have a diverse, lively and professional growing workforce.

We are committed to making TPR a great place to work and doing all we can to support our people to reach their full potential. Join our expanding team for the chance to be a part of the biggest change to pensions in a generation.


We’re looking for an experienced Analyst to join the Management Information (MI) and Analysis team. The role will be working with large volumes of operational data and providing actionable insight to decision makers across Frontline Regulation in the form of reports, analysis or key performance indicators. The MI Analyst will be passionate about working with data, but equally be able to package their findings into non-technical presentations and speak confidently to all levels within the organisation.

We work as an Agile team where each team member both writes the code and designs visually compelling reports and manages their relationships with internal customers.


  • Extract, manipulate, analyse and present on large data sets using SQL, visualisation tools and / or Excel to provide actionable insight to managers and decision makers in Frontline Regulation.
  • Develop and maintain standard reports and dashboards with clear visuals to support management decision-making.
  • Provide trend analysis and create forecasts or models using a range of techniques.
  • Work with a wide variety of non-technical customers to capture requirements, walk through prototypes and present findings.
  • Answer Freedom of Information requests and supply information on core regulatory activities.
  • Peer review on reporting accuracy and quality.
  • Find opportunities to use your analytical skills and techniques to add value to business problems.
  • Be a contributing and proactive member of the Frontline Regulation directorate and the TPR analyst community.

Essential and desirable criteria


  • Intermediate SQL skills using Microsoft SQL server reporting services or similar reporting tool.
  • Experienced in providing insight from data.
  • Experienced in working with large volumes of data.
  • Experienced in data visualisation.
  • Experience of Business Intelligence tools such as Power BI / SSRS/ Birst / Tableau. Our primary reporting tool is currently Microsoft Server SQL Report Builder, but prior experience is not essential.
  • Ability to manipulate and present data in Excel (vlookups, pivot tables, data visualisations and descriptive statistics).
  • Report requirement gathering and development.
  • Educated to degree level, preferably in computer science / mathematics / statistics.


  • Experience of working with Microsoft SharePoint advantageous.
  • Knowledge of forecasting and descriptive statistical techniques.
  • Other coding languages such as R, Python, VBA.

Person specification

  • Ability to prioritise and use initiative.
  • Problem solving and analytical skills.
  • Communication skills at all levels
  • Attention to detail and accuracy

Salary and benefits

As well as a starting salary of £26,218, we offer:

  • Civil Service Pension arrangements, which are recognised as some of the best in the pensions world
  • discretionary bonus arrangements
  • access to performance related pay progression
  • 25 days annual leave provision
  • flexible working arrangements
  • development opportunities
  • enhanced parental leave arrangements
  • a free employee assistance programme
  • an excellent office location in Brighton

How to apply

We provide an exciting, supportive and flexible working environment, and are committed to helping our people meet their full potential.

TPR is an inclusive employer and offers equal opportunities to all regardless of an individual's age, disability, gender identity, marriage or civil partnership status, pregnancy or maternity, race, religion or belief, sex and sexual orientation. TPR welcomes applications from the black and minority ethnic (BME) and lesbian, gay, bisexual, and transgender (LGBT) communities who are currently under-represented at TPR.

Candidates who declare that they have a disability and who meet the essential criteria for the job will be offered an interview.

Applications will be considered on a part time and job share basis.

Please send your CV and a covering letter, with details of how your experience and skills meet our essential criteria to

If you have any enquiries with regards to this role or if you have a disability and wish to request a reasonable adjustment at any stage of the recruitment process, please email