The Vacancy

You will be part of the Data Journey team within our Third-Party Administration area where you will be able to display your abilities as a data enthusiast as we tackle our ambition of building a modern data platform, while serving our current customer needs.

The role will focus on the modernisation and continuous improvement of data analysis, transformation, and visualisation within this business area.

You will identify, investigate, and resolve data issues, discrepancies, and risks within new or existing datasets to ensure the datasets are complete and consistent for downstream usage. You will identify requirements and develop reports and extracts for key stakeholders both in on premise and cloud-hosted data stores. You will work as part of the Data Engineering team to analyse and develop robust data models and pipelines to support analytics, reporting and visualisations from our Data Lakehouse. You will work alongside technical and non-technical teams, understanding the user requirements and will bridge the gap between the different stakeholders. You will keep abreast of the latest developments in data tooling, promoting best practice and guidance to the wider business.

About You

You will be comfortable working as part of a team, as well as having the initiative to explore solutions on your own. In our growing data team, you will have the opportunity to build robust data and reporting solutions that can be accessed using technologies suited for the specified audience.

To succeed and enjoy this role, you will either be working with working with SQL databases such as Microsoft SQL Server, either on premise or cloud hosted, and excited about building your expertise with Azure-hosted data platforms.

To be successful in this role, you will be:

Comfortable working with large volumes of data, both time series and numeric data Experienced in the following data technologies: SQL database technologies utilising both on-premise, and cloud data platforms. Scripting, extracting, creating, and modifying data. Knowledge and understanding of SQL Objects using Stored Procedures, Views, and Functions Meticulous in your approach and can pinpoint and remedy data and reporting discrepancies from source data through to reporting. Confident in engaging constructively in a multi-disciplined team environment. Self-motivated with a drive to learn and share knowledge. An effective communicator and an effective team player. Able to forge strong and professional relationships.

Desirable:

Domain knowledge of the pensions industry would be beneficial but most important is a passion to learn. Experience or familiarity with some of the following: Coding in R, Python, or other data modelling/analysis technologies PowerBI for reporting and visualisations Data modelling for downstream extraction or consumption Data Lakes for data storage, including formats such as parquet/delta or similar technologies. Data cleansing, manipulation, and analysis of large datasets Familiarity with continuous integration, continuous delivery, agile methodologies, and Azure DevOps.