Analytics Engineer

Closing Date

03-06-2024

About UK Infrastructure Bank

We are the new, government-owned policy bank - launched in June 2021 - providing £22bn of infrastructure finance and partnering with the private sector and local government to finance a green industrial revolution and drive growth across the United Kingdom.

We are looking for skilled and results oriented individuals who are motivated to help us build the UKIB into an industry-leading institution.

Job Purpose

The Analytics Engineer is responsible for contributing to all phases of the development lifecycle of UKIB’s Golden Source Analytics Platform (Microsoft Fabric). Aligned to the UKIB Data Strategy, this role will ensure the seamless provision of data for consumption within reporting & analytical data products via curated layers and reusable semantic models.

Core role accountabilities:

Design, Build, Support and Develop UKIB’s Golden Source data platform (Microsoft Fabric).

Ingest data with shortcuts, pipelines or dataflows to support Power BI and AI analytical use cases.

Establish both curated and semantic layers within UKIB’s Golden Source data platform, aligned to UKIB Data Architecture and using Microsoft Fabric capabilities.

Actively contribute to all stages of the data platform lifecycle as required (including design, development, testing & delivery phases) in line with our agreed architecture and design standards.

Optimise table design, data models and semantic models for onward data consumption by content creators across the organisation.

Ingest third party data using Microsoft Fabric capabilities and prepare third party data for both standalone and combined analysis with other UKIB data sets.

Ensure data platform delivers to non-functional requirements.

Performance optimisation and troubleshooting of data technologies

Curate an unstructured data (documents, reports, lists etc.) ecosystem within Microsoft Fabric tools

Champion Cloud Operations & DevOps principles, approaches and best practices

Document knowledge of environments and individual systems as they are acquired over time, creating runbooks and ensuring critical system information is readily available to colleagues across UKIB.

Knowledge, skills and experience:

Essential

Experience working in a team, building & supporting data platforms with Microsoft technologies.

Technical skills with some of the following technologies - Data Factory, Data Activator, Synapse Data Engineering, Synapse Data Warehouse, Python, One Lake

Working knowledge of Microsoft Azure Cloud

Good knowledge of data management principles, including data modelling, data integration, ETL (Extract, Transform, Load) processes, data governance, and data security

Experience building data platform components to support a business need

Strong attention to detail and analytical skills

Strong written and verbal communication skills, able to communicate technical solutions to non-technical stakeholders in a straightforward and understandable way.

Strong planning and organisational skills, including the ability to manage several workstreams simultaneously, balancing business priorities and quality.

Experience of working within an Agile working environment.

An eagerness to learn and the ability to instil this in others.

Ability to work in a small team, within an evolving organisational environment including newly set processes and methods that may well change over time.

Desirable

Technical qualifications with some of the following technologies - Data Factory, Data Activator, Synapse Data Engineering, Synapse Data Warehouse, Python, One Lake

Knowledge and understanding of the business processes associated with financial services organisations.

Experience providing technical support services

Experience producing technical design and support documentation

A career with us offers a unique opportunity to make a lasting impact and work on cutting-edge technologies that will drive the UK’s future. We value diversity in our people and inclusion is at the heart of what we do.

We offer competitive benefits and unique learning opportunities from combining both private and public sector skills and experience.