Data Warehouse ETL Developer

This job has now expired please search on the home page to find live IT Jobs.

Data Warehouse ETL Developer

NHS Business Services Authority

The closing date is 08 May 2023

Job summary

If you are highly accurate and enjoy working with data, are experienced in using information to produce solutions, and are looking for a role that can make a difference, the NHS Business Services Authority (NHSBSA) have the opportunity for you! We are looking for a Data Warehouse ETL Developer to join our team. It's the perfect opportunity to see how the NHS can help you take the next step in your career!

Are you skilled in database and data warehouse technologies with knowledge of ETL processing and database design? You have what this role needs! You will join the Data Warehouse team, handling the development, testing, and productionisation of ETL processes into the data warehouse. You will be working with high-volume, complex, health-related data sets in an exciting and challenging environment using the latest cloud technologies.

What do we offer?

27 days leave (increasing with length of service) plus 8 bank holidays

Flexible working (we are happy to discuss options such as compressed hours)

Flexi time

Hybrid working model (we are currently working largely remotely)

Career development

Active wellbeing and inclusion networks

Excellent pension

NHS Car lease scheme

Access to a wide range of benefits and high street discounts!

Main duties of the job

The post holder will support the sourcing, extracting, transforming, loading, and providing access for data within the NHSBSA's data warehouse(s). The post holder will use their expertise to provide highly complex data to drive the development of business intelligence and insight. The post holder will be an expert in data from within the NHSBSA and will liaise with data experts from partner organisations.

The post holder will provide expertise and specialist advice to IT and business service colleagues to ensure data are extracted from a wide range of business systems and transformed for loading in the data warehouse. They will advise, and develop plans, with project and data analytics teams to deliver data requirements to improve information, data analysis and reporting. They will investigate and resolve data issues and anomalies between data sets.

The post holder will develop and deliver plans to manage appropriate access to data within the data warehouse and data analytics environments so that data security and integrity are maintained. They will use a range of manual and automated data movement tools and techniques and will work with very large datasets containing data which contains highly sensitive information.

Person specification

Knowledge of Oracle data types and Data Definition Language (DDL)

SQL skills

Scripting

UNIX - Linux/Solaris

Data governance and data quality

Extract, Transform and Loading of large datasets

Oracle database privileges

Oracle Datapump and SQLLoader

Able to formulate plans which cover a range of activities including prioritisation of activities

Able to concentrate using discretion in decision making activities

Confident at presenting information

Able to communicate complicated issues in a clear manner to individuals at all levels of the organisation

Excellent problem solving skills

Sound analytical ability

Attention to detail

An attitude to get things done with speed and effectiveness

A self-starter who enjoys finding solutions that combine multiple tools and skills sets

Proactive and personally motivated

Self-aware, flexible and adaptable

Commitment to continuing professional development

Enjoys working as part of a team

About us

At the NHS Business Services Authority (NHSBSA) we deliver a range of essential national services to NHS organisations and contractors, patients and the public.

You may already be using some of our services. Do you have a prescription pre-payment certificate? Perhaps you found this vacancy through NHS Jobs? We're behind these, and much more.

Being one of the UK's Best Big Companies to work for, our values are to be Collaborative, Adventurous, Reliable and Energetic. We CARE about what we do and support each other in achieving our objectives.

Our people are the heart of our organisation. We strive to ensure they feel trusted, valued and empowered. We're passionate about nurturing and developing people. When you join us, we want you to grow, and we offer many opportunities for you to do that.

We welcome applications from people of all backgrounds. With wellbeing and inclusion central to our ethos, our BAME, Disability and Neurodiversity, LGBTQ+, Armed Forces and Women's networks help our colleagues to be their authentic selves at work.

At the NHSBSA we value and respect the diversity of our colleagues and are committed to being a flexible employer. We are proud to offer flexible working opportunities. Whether you're interested in hybrid working, working from home, flexible hours or job sharing, apply today and we can discuss available options with you at the interview stage.

We are the NHS delivering for the NHS.