Senior Business Intelligence and Data Warehousing DBA

Job summary

We are developing a growing range of integrated and digital care services and offer private healthcare in dedicated facilities on all our sites, including at the Lindo Wing at St Mary's Hospital.

An exciting opportunity has come up in the Data Warehouse team. We are looking for a talented, experienced and enthusiastic person to bolster our Data Warehouse team. This pivotal role will be instrumental in upholding and enhancing our information systems, ensuring that data integrity, security, and performance meet or surpass organisational standards. The role will involve close engagement with system suppliers, ICT staff and senior service (clinical) staff.

The successful candidate will have at least three years of experience working in a Data Warehouse team. Will have strong technical skills and be proficient in SQL database administration, development, and data extraction tools, i.e. SSIS, and methodologies. Experience working with Python, Pyspark, R, Databricks, Apache Spark, and cloud based computing systems is desirable. Excellent communication skills, both written and verbal are required and the post holder will be developing working relationships with a wide range of operational, financial, and clinical managers.

The role is a hybrid one - based at Imperial at the St Mary's site in Paddington and working from home, with occasional meetings at other sites across North West London.

Main duties of the job

• Working with clinical and nursing teams to elicit and specify information system requirements and tailoring the requirements into a project timeline with clearly specified deliverables in a clear timeline
• Using appropriate data ingestion and data transformation software and software engineering techniques to build optimised information systems on cloud or in-house systems
• Monitoring routine jobs and pipelines, identifying, investigating and resolving any failures/developments required for existing and new pipelines
• Design and execute procedures for data backup and restoration
• Provide support for SQL server upgrades and hardware enhancement strategies.
• Address and resolve issues or incidents as they arise.
• Diagnose and rectify any issues encountered during ETL and data ingestion phases. Assist in drafting or updating procedures for database data entry as needed.
• Assist in overseeing database performance, tracking disk space consumption, and conducting routine server maintenance tasks.
• Participate in managing database users and overseeing identity and user access controls.
• The individual in this position must adhere to all relevant Standard Operating Procedures (SOPs) and is responsible for updating their SOP training as part of their annual professional growth and development plan.

About us

At Imperial College Healthcare you can achieve extraordinary things with extraordinary people, working with leading clinicians pushing boundaries in patient care. Become part of a vibrant team living our values - expert, kind, collaborative and aspirational. You'll get an experience like no other and will fast forward your career.

Benefits include career development, flexible working and wellbeing, staff recognition scheme. Make use of optional benefits including Cycle to work, car lease schemes, season ticket loan or membership options for onsite leisure facilities. We encourage staff to have the Covid vaccination to protect themselves, patients, other colleagues as well as the wider community.

Please note it is an operational requirement to comply with infection prevention and control procedures within the Trust such as lateral flow testing, handwashing and the wearing of masks, according to the procedures in place at any time or location.

As part of our continued response to Covid19 we are still conducting the majority of our interviews virtually.

We welcome discussions about flexible working and encourage a range of flexible working opportunities wherever we can.

Employer details

Employer name

Imperial College Healthcare NHS Trust

Address

St Mary's Hospital

London

W2 1NY

Employer's website

https://www.imperial.nhs.uk/ (Opens in a new tab)

---

Employer details

Employer name

Imperial College Healthcare NHS Trust

Address

St Mary's Hospital

London

W2 1NY

Employer's website

https://www.imperial.nhs.uk/ (Opens in a new tab)

---