Job summary
If you are highly accurate and enjoy working with complex 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 highly skilled in database and data warehouse technologies with a thorough knowledge of ETL processing and database design? You have what this role needs! You will join the Data Warehouse team, handling the design, 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 lead sourcing, extracting, transforming, loading, and providing access for data within the NHSBSA's data warehouse(s). The post holder will use thier 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. He or she 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:
- Provide expertise in making available, integrating, and optimising structured and/or unstructured data using database products, technologies, and methods.
- Provide expertise in refining and transforming data.
- Provide and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing and working with these data sets are understood by users before permitting access to the data in the warehouse.
- Negotiate with Senior Managers and strategic partners to gain access to data and provide assurance that data is appropriately controlled within the NHSBSA data warehouse.
- Review policies and procedures for data access, identifying and implementing improvements.
- Agree priorities for bringing in data and develop plans with project managers to ensure that when data are changed as a result of business system changes, the changes can also be implemented in the data warehouse.
- Responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, have been tested by approving test plans and reviewing results of testing. Coordinate work with testers.
- Prepare and update technical documentation for the data entering the data warehouse. Ensure that physical data are reviewed for updates to data dictionaries and gaps in metadata are rectified.
- Analyse, investigate and resolve complex queries to identify data trends and quality issues. Share information with IT managers, information governance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes of data issues. Recommend improvements to data management.
- Develop and train other members of the data acquisition and management team, and the wider business intelligence network.
- Coordinate work with the team that manages access to the information reports and reporting tools available from the data warehouse for external users.
- Responsible for reviewing and planning updates to the ETL technical products, making recommendations for replacement of data warehouse technology.
Job description
Job responsibilities
In this role, you are accountable for:
- Provide expertise in making available, integrating, and optimising structured and/or unstructured data using database products, technologies, and methods.
- Provide expertise in refining and transforming data.
- Provide and receive highly confidential data (personal information and commercially sensitive) ensuring that the implications for sharing and working with these data sets are understood by users before permitting access to the data in the warehouse.
- Negotiate with Senior Managers and strategic partners to gain access to data and provide assurance that data is appropriately controlled within the NHSBSA data warehouse.
- Review policies and procedures for data access, identifying and implementing improvements.
- Agree priorities for bringing in data and develop plans with project managers to ensure that when data are changed as a result of business system changes, the changes can also be implemented in the data warehouse.
- Responsible for ensuring changes to the ETL technology, and changes to ETL procedures as a result of business system changes, have been tested by approving test plans and reviewing results of testing. Coordinate work with testers.
- Prepare and update technical documentation for the data entering the data warehouse. Ensure that physical data are reviewed for updates to data dictionaries and gaps in metadata are rectified.
- Analyse, investigate and resolve complex queries to identify data trends and quality issues. Share information with IT managers, information governance and data governance to identify system errors, breaches of information security or confidentiality, and determine other causes of data issues. Recommend improvements to data management.
- Develop and train other members of the data acquisition and management team, and the wider business intelligence network.
- Coordinate work with the team that manages access to the information reports and reporting tools available from the data warehouse for external users.
- Responsible for reviewing and planning updates to the ETL technical products, making recommendations for replacement of data warehouse technology.
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- oStrong knowledge of Oracle data types and Data Definition Language (DDL)
- oStrong SQL skills
- oScripting
- oData governance and data quality
- oExtract, Transform and Loading of large datasets
- oAble to deliver outcomes in non-line management relationships
- oAble to formulate plans which cover a range of activities including prioritisation of activities
- oAble to concentrate using discretion in decision making activities.
- oConfident at presenting information
- oAble to communicate complicated issues in a clear manner to individuals at all levels of the organisation
- oExcellent problem solving skills
- oSound analytical ability
- oAttention to detail
- oAn attitude to get things done with speed and effectiveness
- oA self-starter who enjoys finding solutions that combine multiple tools and skills sets
- oProactive and personally motivated
- oSelf-aware, flexible and adaptable
- oCommitment to continuing professional development
- oEnjoys working as part of a team
Desirable
- oOracle RDBMS objects
- oOracle Developer
- oSQLServer, DB2, UDB
- oEncryption and pseudonymisation techniques
- oManaging data in Oracle Endeca
- oCreation and Maintenance of a Data Dictionary
- oAble to learn new technologies and quickly grasp complex problems
- oCurious nature and effectively dives deep into material
- oUNIX - Linux/Solaris
- oOracle Datapump and SQLLoader
- oOracle database privileges
Experience
Essential
- oExperience of an ETL technology
- oWorking with large and complex datasets
- oManipulating and loading large datasets
- oProgramming skills related to data manipulations within a database environment
- oPreparing and reviewing policies e.g. for data access
- oIdentifying, planning and prioritising changes
- oManaging staff workload in non-line management relationships
- oReviewing and maintaining technical documentation
Desirable
- oWorking with Oracle Exadata or Exalytics
- oExperience of using machine learning
- oDelivering training
- oData analysis to provide business intelligence
Qualifications
Essential
- oIT 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
- oStrong knowledge of Oracle data types and Data Definition Language (DDL)
- oStrong SQL skills
- oScripting
- oData governance and data quality
- oExtract, Transform and Loading of large datasets
- oAble to deliver outcomes in non-line management relationships
- oAble to formulate plans which cover a range of activities including prioritisation of activities
- oAble to concentrate using discretion in decision making activities.
- oConfident at presenting information
- oAble to communicate complicated issues in a clear manner to individuals at all levels of the organisation
- oExcellent problem solving skills
- oSound analytical ability
- oAttention to detail
- oAn attitude to get things done with speed and effectiveness
- oA self-starter who enjoys finding solutions that combine multiple tools and skills sets
- oProactive and personally motivated
- oSelf-aware, flexible and adaptable
- oCommitment to continuing professional development
- oEnjoys working as part of a team
Desirable
- oOracle RDBMS objects
- oOracle Developer
- oSQLServer, DB2, UDB
- oEncryption and pseudonymisation techniques
- oManaging data in Oracle Endeca
- oCreation and Maintenance of a Data Dictionary
- oAble to learn new technologies and quickly grasp complex problems
- oCurious nature and effectively dives deep into material
- oUNIX - Linux/Solaris
- oOracle Datapump and SQLLoader
- oOracle database privileges
Experience
Essential
- oExperience of an ETL technology
- oWorking with large and complex datasets
- oManipulating and loading large datasets
- oProgramming skills related to data manipulations within a database environment
- oPreparing and reviewing policies e.g. for data access
- oIdentifying, planning and prioritising changes
- oManaging staff workload in non-line management relationships
- oReviewing and maintaining technical documentation
Desirable
- oWorking with Oracle Exadata or Exalytics
- oExperience of using machine learning
- oDelivering training
- oData analysis to provide business intelligence
Qualifications
Essential
- oIT related Degree or a subject requiring high levels of numeracy plus significant demonstrable experience developing and/or supporting IT systems
Desirable
Additional information
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).