Job summary
Ifyouarehighly accurate and enjoy working with data, are experienced in using information to produce solutions,andarelooking fora role that can make a difference, the NHS Business Services Authority (NHSBSA) have the opportunity for you! We are looking foraData Warehouse ETL Developerto join our team.It's theperfect opportunitytosee 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 theData 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.
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.
Job description
Job responsibilities
In this role, you are accountable for:1. Provide expertise in making available, integrating, and optimising structured and/or unstructured data using database products,technologies, and methods.2. Provide expertise in refining and transforming data.3. Provide and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing andworking with these data sets are understood by users before permitting access to the data in the warehouse.4. Liaise with Senior Managers and strategic partners to gain access to data and provide assurance that data is appropriately controlled withinthe NHSBSA data warehouse.5. Contribute to and review policies and procedures for data access, identifying and implementing improvements ensuring data security andintegrity at all times.6. Agree priorities for bringing in data and develop plans with project managers to ensure that when data are changed as a result of businesssystem changes, the changes can also be implemented in the data warehouse.7. Responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, havebeen tested by approving test plans and reviewing results of testing. Coordinate work with testers.8. Prepare and update technical documentation for the data entering the data warehouse. Ensure that physical data are reviewed for updatesto data dictionaries and gaps in metadata are rectified.9. Analyse, investigate and resolve complex queries to identify data trends and quality issues. Share information with IT managers, informationgovernance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes ofdata issues. Recommend improvements to data management.10. Responsible for positively achieving team and personal objectives in accordance with business plan and strategic direction.11. Coordinate work with the team that manages access to the information reports and reporting tools available from the data warehouse forexternal users.12. Responsible for reviewing and assisting with updates to the ETL technical products, making recommendations for replacement of datawarehouse technology.In addition to the above accountabilities, as post holder you are expected to:Undertake additional duties and responsibilities in line with the overall purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Foster an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Comply with NHSBSA policies, procedures and protocols as they apply to your role.Working relationshipsResponsible to:Data Warehouse & BI Manager / Data Warehouse Lead Architect / Data Warehouse BI DeveloperKey relationships and connections:Data management and acquisition team, Customers, Strategic Partners, Senior Managers
Job description
Job responsibilities
In this role, you are accountable for:1. Provide expertise in making available, integrating, and optimising structured and/or unstructured data using database products,technologies, and methods.2. Provide expertise in refining and transforming data.3. Provide and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing andworking with these data sets are understood by users before permitting access to the data in the warehouse.4. Liaise with Senior Managers and strategic partners to gain access to data and provide assurance that data is appropriately controlled withinthe NHSBSA data warehouse.5. Contribute to and review policies and procedures for data access, identifying and implementing improvements ensuring data security andintegrity at all times.6. Agree priorities for bringing in data and develop plans with project managers to ensure that when data are changed as a result of businesssystem changes, the changes can also be implemented in the data warehouse.7. Responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, havebeen tested by approving test plans and reviewing results of testing. Coordinate work with testers.8. Prepare and update technical documentation for the data entering the data warehouse. Ensure that physical data are reviewed for updatesto data dictionaries and gaps in metadata are rectified.9. Analyse, investigate and resolve complex queries to identify data trends and quality issues. Share information with IT managers, informationgovernance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes ofdata issues. Recommend improvements to data management.10. Responsible for positively achieving team and personal objectives in accordance with business plan and strategic direction.11. Coordinate work with the team that manages access to the information reports and reporting tools available from the data warehouse forexternal users.12. Responsible for reviewing and assisting with updates to the ETL technical products, making recommendations for replacement of datawarehouse technology.In addition to the above accountabilities, as post holder you are expected to:Undertake additional duties and responsibilities in line with the overall purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Foster an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Comply with NHSBSA policies, procedures and protocols as they apply to your role.Working relationshipsResponsible to:Data Warehouse & BI Manager / Data Warehouse Lead Architect / Data Warehouse BI DeveloperKey relationships and connections:Data management and acquisition team, Customers, Strategic Partners, Senior Managers
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- 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
Desirable
- Oracle RDBMS objects
- Oracle Developer
- SQLServer, DB2, UDB
- Encryption and pseudonymisation techniques
- Managing data in Oracle Endeca
- Creation and Maintenance of a Data Dictionary
- Able to learn new technologies and quickly grasp complex problems
- Curious nature and effectively dives deep into material
Experience
Essential
- Understand of ETL technology
- Working with large and complex datasets
- Manipulating and loading large datasets
- Programming skills related to data manipulations within a database environment
- Preparing and reviewing policies e.g. for data access
- Identifying, planning and prioritising changes
- Reviewing and maintaining technical documentation
Desirable
- Working with Oracle Exadata or Exalytics
- Experience of using machine learning
- Data analysis to provide business intelligence
Qualifications
Essential
- IT related Degree or a subject requiring high levels of numeracy plus significant demonstrable experience developing and/or supporting IT systems
Desirable
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- 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
Desirable
- Oracle RDBMS objects
- Oracle Developer
- SQLServer, DB2, UDB
- Encryption and pseudonymisation techniques
- Managing data in Oracle Endeca
- Creation and Maintenance of a Data Dictionary
- Able to learn new technologies and quickly grasp complex problems
- Curious nature and effectively dives deep into material
Experience
Essential
- Understand of ETL technology
- Working with large and complex datasets
- Manipulating and loading large datasets
- Programming skills related to data manipulations within a database environment
- Preparing and reviewing policies e.g. for data access
- Identifying, planning and prioritising changes
- Reviewing and maintaining technical documentation
Desirable
- Working with Oracle Exadata or Exalytics
- Experience of using machine learning
- Data analysis to provide business intelligence
Qualifications
Essential
- IT related Degree or a subject requiring high levels of numeracy plus significant demonstrable experience developing and/or supporting IT systems
Desirable
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
