ETL Datawarehouse Developer
Job Posted: 11 August 2022
Job Updated: 21 November 2022
Job Title – ETL / Datawarehouse Developer/ Data Engineer
Function – Business Intelligence (Finance)
Location – Alfreton or Nottingham, with hybrid working options
Type – Permanent (full time, 37.5 hours per week)
Salary – £37,000 – £50,000 per annum
Closing Date: Friday 9th December 2022
We have a rare opportunity to join our Business Intelligence team as an ETL / Datawarehouse Developer/ Data Engineer.
Reporting to the Senior Business Intelligence Developer, you will play a key role in the continued development and support of Business Intelligence solutions within SCCL and the wider NHS Supply Chain, driving the business towards a culture of data driven decision making and helping users gain valuable insights into the performance of the business.
What does an ETL Developer do at NHS Supply Chain?
- Provide subject matter expertise in Datawarehouse design and ETL processes.
Develop and maintain SSIS packages using Visual Studio .
- Champion a consistent application of analysis, design and implementation using established processes and techniques.
Develop and enhance stored procedures. Write ad-hoc SQL queries to support report requests.
Create test plans, test cases, test scripts and perform data testing and validation.
- Develop and deliver Business Intelligence solutions in accordance with business reporting requirements.
- Create test plans, test cases, test scripts and perform data testing and validation.
- Proactively engage with internal stakeholders and collaborate with them to provide insightful data and analysis in a business analysis capacity.
- Document reporting requirement and report specification documents.
- Document and assist with the creation of solution design documents.
- Conduct testing of newly developed solutions and assist users in performing UAT.
- Assist with the management and resolution of user support tickets.
- Investigate and troubleshoot reported issues.
- Manage key relationships with internal and external stakeholders and issue resolution.
What skills, qualifications and qualities do I need to be successful?
- Significant experience with SQL Server Integration Services (SSIS).
- Demonstrable experience of SQL (ORACLE/SQL server)
- Demonstrable experience of BI/Data Warehouse concepts and standards.
- Significant experience in Data warehousing, Data mart development (Kimble design methodology).
- Experience in tuning T-SQL queries to improve the database performance and availability.
- Experience of object creation such as Tables and Views, Data Dictionaries, Data Integrity, Performance Tuning and indexes.
- Experience in writing complex queries including Stored Procedures using T -SQL.
- Experience supporting a production database warehouse environment.
- Excellent communications skills both verbal and written.
- Experience of gathering and translating data requirements from stakeholders into detailed reporting and technical solutions.
- To manage own time efficiently to ensure that deadlines on multiple tasks/initiatives are met.
- Must understand the Software Development Life Cycle (SDLC) and be able to follow the process.
- Experience in data validation and data cleansing.
In return for your passion, enthusiasm, and hard work you will be rewarded with an attractive salary and benefits package, consisting of:
Performance led annual bonus scheme
27 days holiday plus bank holidays, with the option to purchase up to an additional 5 days
Generous contributory pension scheme (up to 12% of your salary)
Flexible benefits scheme – you will be able to choose from a variety of benefits such Life Insurance, Critical Illness Cover, Income Protection, Health Cash Plan, Dental Insurance and additional pension contributions that suit you
3 days paid Volunteering Leave
Access to the Blue Light Card and NHS Discounts
Flexible working options
National Annual season ticket purchase scheme
Eye Care vouchers
Employee Assistance Programme
NHS Supply Chain, who are we?
We are part of the NHS family, managing more than 8 million orders per year across 94,000 order points and 17,465 locations. We deliver over 28 million lines of picked goods to the NHS annually and our systems consolidate orders from over 930 suppliers. We proudly deliver supply chain excellence and best value to NHS customers and patients through innovation, service and clinical expertise.
Our customers are at the centre of everything we do, we will ensure we continue to deliver the products and services needed by the NHS, both now and in the future. Our priorities for 2022/2023 focuses on the following areas:
Customer: we will anchor our business on the needs of the NHS by supporting NHS trusts to deliver safe and excellent patient care and through continuing to build the services the NHS needs.
Resilient: we will further strengthen the resilience of our supply chain by continuing to invest in key tools and capacity that build resilience and performance, across the end to end supply chain.
Safe: we will deliver clinically assured, safe products that support improved outcomes for patients and users.
Sustainable: we are committed to supporting the NHS objective of becoming the world’s first net carbon zero national health system through reducing single use plastics, supporting the circular economy, reducing our greenhouse gas emissions and improving human rights and labour standards.
Efficient: we will ensure we have a high performing workforce and highly efficient organisation.
Supply Chain Coordination Limited acts as the management function for the NHS Supply Chain. By 2023/2024, we aim to save the NHS £2.4bn by leveraging the scale of the NHS to drive savings and provide a standardised range of quality assured clinical products.
SCCL is a not an NHS organisation, you will join on SCCL terms and conditions.
For more information on SCCL and the NHS Supply chain please visit: www.supplychain.nhs.uk
NHS Supply Chain is an equal opportunities employer
SCCL is a company Registered in England and Wales, with company number 10881715, to act as the management function of the NHS Supply Chain.
SCCL values and respects the diversity of its employees and aims to recruit a workforce which reflects our diverse communities. We welcome applications irrespective of people’s age, disability, gender, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances.
Our policies and procedures reflect our commitment to ensure that all applicants are treated fairly and consistently at every stage of the recruitment process.
SCCL reserve the right to close any vacancies from further submissions when we have received sufficient applications from which to make a shortlist. Please apply without delay if you wish to be considered for this role.
If you are shortlisted for interview you will be required to provide proof of ID and the right to work in the UK.