Senior Data Warehouse Developer

3 weeks ago


Aylesford, United Kingdom Maidstone and Tunbridge Wells NHS Trust Full time

Job summary

A fantastic opportunity has arisen for a highly motivated Senior Data Warehouse Developer looking to further their career by joining the expanding KMDW Data Warehousing department on 2 year fixed-term contract. Using Microsoft development tools, you will lead on the development and maintenance of a unique county-wide data warehouse that is relied on by NHS organisations across Kent & Medway for the benefit of both patients and staff.

The NHS is becoming a data driven organisation and the KMDW department is leading the way across local Health and Social Care organisations who depend on a well-managed data warehouse for the operational running of their services.

The department is highly regarded both locally and nationally - particularly for its work in the area of linking datasets from a wide variety of organisations for population health management purposes. Team members are also widely respected for the innovative solutions developed for stakeholders and the agile working methodologies employed.

Main duties of the job

The role offers the opportunity to lead in designing, monitoring, maintaining and improving current data flows and warehousing processes along with developing Extract, Transform, Load processes for new flows. The key focus of the role will be to develop and implement data quality solutions within the data warehouse.

The post holder will also be responsible for investigating and deploying innovative ways of system and process improvement.

A wide range of in-person and online training opportunities will be offered based on your requirements, including the option of certified Microsoft training.

It is essential that you have a good working experience of data warehousing techniques, preferably using SQL Server and SQL Server Integration Services. You will be expected to work on your own initiative to achieve strict deadlines, liaising and managing relationships with data owners and system users.

The KMDWdata warehouse has been in operation for over 20 years with a dedicated team having significant experience working in data management. Employee wellbeing is a core part of the department's ethos with the role being home-based offering flexible hours as well as benefitting from excellent NHS terms and conditions. These include various benefits such as excellent annual leave entitlement, a highly regarded pension scheme, car lease and cycle to work schemes, high street and online discounts as well as being a family friendly employer.

About us

Maidstone and Tunbridge Wells NHS Trust is a large acute hospital Trust in the county of Kent.

The Trust provides a full range of general hospital services and some areas of specialist complex care to around 760,000 people living in the south part of West Kent and the north part of East Sussex.

The Trust's core catchment areas are Maidstone and Tunbridge Wells and their surrounding boroughs. We work from two main clinical sites: Maidstone Hospital and Tunbridge Wells Hospital at Pembury. Tunbridge Wells Hospital opened in 2011 and provides single rooms with en-suites for all in-patients - the first of its kind in the country.

We employ more than 7,000 full and part-time staff in a huge range of clinical and non-clinical roles across both of our hospital sites.

Would you like to work flexibly?In the NHS, we are reminded every day of how important life is. As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us, for our patients and for you. Speak to us about how we might be able to accommodate a flexible working arrangement.

Job description

Job responsibilities

Once your pre-employment checks have been completed you will be contacted by Recruitment to arrange your start date which will be in line with one of our Corporate Inductions.

At MTW, we seek to develop a culture where everyone can reach their full potential with opportunities to grow and develop their career. We recognise and value the unique contributions that each of our staff bring, delivering the best quality care and service to our patients. We are committed to being a diverse employer and strive to reflect everyone in our local communities. We welcome applications from people of diverse backgrounds, perspectives and experiences and celebrate the diversity of thought, viewpoints and ideas that will make our Trust the best place to work.

Interview Date: Wednesday 5th June 2024

Person Specification

Qualifications

Essential

Educated to degree level or equivalent proven practical experience

Desirable

Microsoft SQL Server certification IT or Computing Degree Coding Qualification

Experience/Knowledge

Essential

Experience of professional data management Highly specialised knowledge of professional data management techniques and theory Knowledge of data warehousing techniques and methodologies Expert working knowledge of SQL server 2019 and/or upwards Expert working knowledge of SQL Server Data Tools Knowledge of version control software and techniques Able to analyse and judge situations containing complex facts or situations and to examine a range of options related to them Experience of delivering an information related support service Experience of planning, developing and maintaining a customer and quality focussed service especially in complex and major data warehousing projects Understanding of information governance, GDPR, freedom of information and related issues in a clinical information environment Expert knowledge of data modelling techniques Good understanding of SQL coding language

Desirable

Experience of using the Azure DevOps platform Experience of using the Git version control software Good understanding of national data storage and access methods Good knowledge of computer hardware, network systems and network methodologies Highly specialised knowledge of NHS datasets Experience of staff management Good understanding of information issues within the NHS

Skills

Essential

Structured and methodical working using a range of technical skills to develop complex coding of data warehouse processes. Ability to understand and critique complex information at a detailed level and to convey this to non-technical staff either individually or in groups. Ability to juggle multiple tasks and conflicting priorities and work under pressure to tight deadlines with occasional prolonged concentration Able to plan and organise major specialist projects and to work effectively and adapt the plans to cope with changing circumstances

  • Aylesford, United Kingdom Fowler Welch Full time

    Job DescriptionThe role holder will coordinate the operational shift from end to end to ensure that all KPI’s and customer service levels are achieved.To deliver this the role holder will need to monitor staff safety & welfare, operational process compliance and daily operational targets & KPIs ensuring this considers company standards and agreed customer...


  • Aylesford, United Kingdom Culina Group Full time

    Job Description The role holder will coordinate the operational shift from end to end to ensure that all KPI’s and customer service levels are achieved. To deliver this the role holder will need to monitor staff safety & welfare, operational process compliance and daily operational targets & KPIs ensuring this considers company standards and agreed...

  • Senior Planner

    4 days ago


    Aylesford, United Kingdom TRS Staffing Solutions Full time

    Senior Planner - Data Center Construction (UK)About the RoleA leading infrastructure provider is seeking a highly motivated and experienced Planner to join their growing team. You'll play a vital role in supporting project delivery, with a strong focus on their expanding Data Center portfolio.What you'll be doing:Collaborate with senior planners to provide...


  • Aylesford, United Kingdom Kent & Medway NHS & Social Care Partnership Trust Full time

    Job summary You will be an integral part of the procurement team supporting the organisation in its purchasing activity. You will contribute towards the implementation of the objectives set out in the Trust Procurement Strategy, delivering operational efficiencies and process improvements. We are looking for an enthusiastic person to join a...

  • logistics admin

    2 days ago


    Aylesford, United Kingdom Avtav Full time

    Job description OPERATIONS AGENT (PARCEL ADMINISTRATIONS) DHL MAIDSTONE AVTAV are proud to be working in cooperation with DHL a global logistics company proving courier, package delivery and express mail services Role - Operations Agent Location - MAIDSTONE Shifts - Mon - Fri Hours -16.00-20.00 Pay between 08.00am -19.00pm: £12.25 per hour Pay between...


  • Aylesford, United Kingdom Polypipe Building Services Full time

    Specialists in providing engineered above ground drainage and water supply systems, **Polypipe Building Services **leverages offsite fabrication to design and deliver solutions to mechanical and public health engineers, M&E contractors as well as local authorities. Polypipe Building Services houses well-known industry brand Terrain and has been delivering...

  • Warehouse Operative

    1 month ago


    Aylesford, United Kingdom Culina Group Full time

    Job Description Ensure all operational activity is carried out safely and in line with the company’s Health & Safety policy, SSOWs, and HACCP regulations. To carry out any operational activity as instructed which you are properly trained to undertake including but not limited to; Goods-in, Put away, Replenishment, Picking, Marshalling, Loading,...

  • Senior Planner

    2 days ago


    Aylesford, Kent, United Kingdom TRS Staffing Solutions Full time

    Senior Planner - Data Center Construction (UK) About the Role A leading infrastructure provider is seeking a highly motivated and experienced Planner to join their growing team. You'll play a vital role in supporting project delivery, with a strong focus on their expanding Data Center portfolio. What you'll be doing: Collaborate with senior planners...

  • Senior Planner

    4 days ago


    Aylesford, Kent, United Kingdom TRS Staffing Solutions Full time

    Senior Planner - Data Center Construction (UK) About the Role A leading infrastructure provider is seeking a highly motivated and experienced Planner to join their growing team. You'll play a vital role in supporting project delivery, with a strong focus on their expanding Data Center portfolio. What you'll be doing: Collaborate with senior planners...

  • logistics admin

    19 hours ago


    Aylesford, United Kingdom Avtav Full time

    Job description OPERATIONS AGENT (PARCEL ADMINISTRATIONS) DHL MAIDSTONE AVTAV are proud to be working in cooperation with DHL a global logistics company proving courier, package delivery and express mail services Role - Operations Agent Location - MAIDSTONE Shifts - Mon - Fri Hours -16.00-20.00 Pay between 08.00am -19.00pm: £12.25 per hour Pay between...


  • Aylesford, United Kingdom Blue Arrow Full time

    **Underwriting Assistant** **Job Location**: Maidstone, ME14 **Working days**: 5 days office based **Contract**: 3 to 6 months (temp to perm) **Description-** The Underwriting Assistant supports the underwriting teams in writing business on behalf of my client, the capacity providers, and other stakeholders. The Underwriting Assistant is responsible for...

  • Senior Planner

    2 days ago


    Aylesford, Kent, United Kingdom TRS Staffing Solutions Full time

    Senior Planner - Data Center Construction (UK) About the Role A leading infrastructure provider is seeking a highly motivated and experienced Planner to join their growing team. You'll play a vital role in supporting project delivery, with a strong focus on their expanding Data Center portfolio. What you'll be doing: Collaborate with senior...

  • Stock Controller

    7 days ago


    Aylesford, United Kingdom Culina Group Full time

    Job Description Our Aylesford site have an exciting opportunity for a Stock Controller to join our team on a full time, permanent basis. Salary:  £28,900 per annum.  Working hours:  Wednesday-Saturday, 6am-6pm.  The purpose of a Stock Controller is to be responsible for the day to day functions of the Stock Control and Warehouse...

  • Stock Controller

    7 days ago


    Aylesford, United Kingdom Fowler Welch Full time

    Job DescriptionOur Aylesford site have an exciting opportunity for a Stock Controller to join our team on a full time, permanent basis.Salary: £28,900 per annum. Working hours: Wednesday-Saturday, 6am-6pm. The purpose of a Stock Controller is to be responsible for the day to day functions of the Stock Control and Warehouse Administration area,...


  • Aylesford, United Kingdom Heart of Kent Hospice Full time

    About the Role Working at an enhanced practice level with support from senior colleagues to deliver a co-ordinated and comprehensive specialist dementia service to patients and their families/carers. This will include developing knowledge, skills and experience with support from senior colleagues to undertake independent and autonomous practice:...


  • AYLESFORD, United Kingdom ALL SAINTS Full time

    THE ROLE With the ever-evolving state of retail in brick and mortar, we're expanding our sights into new ground by changing from usual till EPOS to mobile point-of-sale. We are looking for an MPOS engineer to support this project. This role is a 4 month fixed term contract. The MPOS engineer will take the lead on removing all old EPOS equipment and...


  • Aylesford, United Kingdom Pineapple Contracts Full time

    Pineapple Contracts opened their doors for the first time in 1975. A family run company, started by William Hathorn, Pineapple began making pine furniture for the retail market and traded as, ‘Pine Productions’. In 1987, Pine Productions moved their focus to the healthcare furniture market, having identified a demand for strong, safe and durable...


  • Aylesford, Kent, United Kingdom ALL SAINTS Full time

    THE ROLEWith the ever-evolving state of retail in brick and mortar, we're expanding our sights into new ground by changing from usual till EPOS to mobile point-of-sale. We are looking for an MPOS engineer to support this project. This role is a 4 month fixed term contract.The MPOS engineer will take the lead on removing all old EPOS equipment and installing...

  • R&D Engineer

    3 weeks ago


    Aylesford, United Kingdom ACS Business Performance Ltd Full time

    The successful R&D Engineer will have experience in design and development- using Autocad Inventor CAD software. The role will involve: Design and development- using Autocad Inventor CAD software. Project planning - developing and administrating of roadmap project planning process so projects are introduced on time and within budget to meet parent company...


  • Aylesford, United Kingdom SIG plc Full time

    SIG Plc. is a leading supplier of specialist building materials to trade customers across Europe as a specialist distributor of insulation and interiors products and merchant of roofing and exterior products. We are looking to recruit an Internal Sales Executive who will act as first point of contact for our customer base, delivering the ultimate in...