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.

Data Platform Specialist (Azure)

Reporting to: Data Solutions Manager
Team: Corporate Services
Contract type: Permanent
Salary: From £44,774 to £59,437 per annum with access to performance related pay and civil service pension scheme
Location: Brighton
Closing date: Tuesday 19 October 2021

Job ref: 108475

TPR grade: 8 - TDD

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 with like-minded individuals.

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 are still working remotely and are transitioning to a hybrid working model by April 2022, subject to government guidelines. Please note our contractual working location is Brighton.


We’re looking for a Data Platform Specialist to:

  • provide technical management and development the TPR Azure Data Platform
  • ensure the Data platform performs for the business to agreed service levels
  • monitor and fix all integration issues between the Data Platform and Power BI and incoming data sources and datasets
  • set up new Data sources to import data into the Data Platform, test and deliver to the business Data team and end-users
  • assist in the creation of new datasets in the Data Platform and the use of this data in Power BI reporting


  • Receive the list of prioritised development items for the Data Platform from the Data Platform Product Owner (Data Team) alongside consultation with the Data Solutions Manager (IT).
  • Direction will be given from the Head of IT Solutions and the business Data Team as well as through review with related IT colleagues.
  • Liaison with the third-party Supplier Adatis who built the Data Platform will be necessary in the short term for any code changes required to provide new data feeds or for recommended upgrades etc.
  • There is no budgeting responsibility.

Essential and desirable criteria


  • SQL Databases or SQL Data Warehouse on Azure.
  • Azure Data Factory or SSIS.
  • Azure Analysis Services OR SSAS Tabular modelling.
  • Experience of Continuous Integration/Continuous Deployment of Data Warehousing on Azure would be a distinct advantage.
  • A large part of this role will be integrating new data feeds from various on-site ERP systems into our new Azure Data Warehouse.
  • Power BI skills.
  • Azure Data Lake Storage.
  • Azure SQL DW/Synapse Analytics.
  • Dynamics 365 (as a data source).
  • Customer facing/consultancy experience


  • Be an ambassador for IT within TPR, working across the business to provide effective communication on IT matters and build relationships with other teams to ensure effective dialogue between directorates.
  • Understand and identify business challenges and develop strategies and solutions to deliver added value to the business.
  • To be flexible in their approach to problem solving considering TPR governance but be creative in providing solutions to problems.
  • Seek guidance from the related development teams and personnel to enhance the service of the Data platform to the business.

Person specification

  • Proactive and flexible.
  • Can do approach.
  • Calm under pressure.
  • Problem solving and analytical skills.
  • Communication skills at all levels.
  • Attention to detail and accuracy.

Salary and benefits

As well as a salary between £44,774 and £59,437, 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

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

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 Microsoft 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