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: Regulatory Transactions
Contract type: Permanent
Salary: Between £26,873 and £35,673 per annum dependent on skills and experience, with access to performance related pay, bonus and civil service pension scheme
Location: Brighton
Closing date: Sunday 26 September 2021

Job ref: 108931

TPR grade: 11

About us

The Pensions Regulator (TPR) is responsible for protecting workplace pensions in the UK. We work with employers and those running pensions to help people save safely for their retirement.

We have a fantastic office located in the heart of Brighton that is a short distance from the train station, shops and the sea.

We put our 700+ employees first by supporting flexible working and offering a diverse, lively and inclusive environment. This includes LGBT+ Network (PROUD), Women’s Network, BAME Network (ME), and a Disability Network, which offer supportive spaces to connect.

We are committed to making TPR a great place to work. We do all we can to support our people reach their full potential with training, secondment and development opportunities.


We’re looking for an experienced Analyst to join the 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.


You will:

  • extract, manipulate, analyse and present on large data sets using SQL, visualisation tools such as Power BI 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
  • 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 MS 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 salary between £26,873 and £35,673, 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, pro rata
  • flexible working arrangements
  • development opportunities
  • enhanced parental leave arrangements
  • a free employee assistance programme
  • an excellent office location in Brighton

How to apply

Please send your CV to along with covering letter, notice period and expected salary quoting ref 108931 with details of how your experience and skills meet our essential criteria.

We are an inclusive employer and offer 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.

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 be aware we are currently holding interviews through MS Teams due to COVID-19.

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