306 North London NHS Foundation Trust

PBI Developer

Information:

This job is now closed

Job summary

The Power BI developer is a new role for North London NHS Foundation Trust and the postholder will support the expansion of the Trust's business intelligence platform and advanced analytical capability to deliver the aims of the Digital Strategic Plan.

Lead on the development of information systems and data resources across our technical environment. The role will involve the detailed analysis and understanding of complex technical and business requirements across multiple services within the Trust to deliver high quality products and facilitate their delivery into business-as-usual operation.

Working in partnership with the wider Digital Team to create strategies and plans for data capacity planning, data security, life cycle data management, scalability, backup, disaster recovery, business continuity and archiving. Responsible to carry out regular reviews of the new Microsoft Azure platform and both Trusts legacy SQL Server data warehouse setup to develop and maintain a common data architecture asset including framework, principle, guideline and template to ensure the data architecture is kept up to date in line with the business requirements. Maintaining and evolving the Trust's data warehouse and business intelligence platform to support the provision of central information, performance and intelligence.

Main duties of the job

The post holder is responsible for the development and delivery of a comprehensive dataset framework incorporating all Trust systems within the data warehouse, for relational database modelling, master data management, application design with associated business rules.

To take responsibility for the planning, creation, implementation, maintenance and ongoing evolution of big data / data models / data marts / data cubes within the Trust's data warehouse, sourced from a wide variety of information systems including patient, staffing, financial and other disparate internal and external data sources

To develop automated data loading (ETL) and validation processes, at the same time maintaining efficient data warehouse metadata structures.

To ensure high quality data warehouse security, putting in place robust security measures to allow adequate access for the required users whilst protecting sensitive patient-identifiable data.

Analyse, interpret and resolve highly complex statistical and contractual problems where there is no precedent and where other leading opinions may conflict.

To lead on designing data solutions based on requirements from the Data Architects and Product Owners with a focus on availability, quality and scalability

Responsible for ensuring that all systems designed, developed, and managed by the Management Information team fulfil the highest standards of information security and privacy.

About us

North London NHS Foundation Trust (NLFT) is committed to improving mental health care across North London to deliver excellent services to our local people.Our Five-Year Strategy:

1. We will provide consistently high-quality care closer to home.

2. With our partners in North London and each borough we will ensure equity of outcome for all

3. We will offer great places to work, providing staff with supportive environment to deliver outstanding care.

4. We will be more effective as an organisation by pioneering research, quality improvement and technology.

In order to meet the needs of the Trust you may be required from time to time to work at different locations to your normal place of work. This may mean that you are required to work at any location that fall under Barnet, Camden, Enfield, Haringey, or Islington. The Trust reserves the right to require staff to work at such other places or locations as it considers reasonable and necessary on a temporary or permanent basis.

Details

Date posted

21 January 2025

Pay scheme

Agenda for change

Band

Band 8a

Salary

£59,490 to £66,239 a year per annum including Outer London Allowance

Contract

Permanent

Working pattern

Full-time

Reference number

306-BEH-2560

Job locations

St Anns Hospital

St Anns Road

Haringey

N15 3TH


Job description

Job responsibilities

Please refer to the attached job description and person specification for main responsibilities of the role.

Job description

Job responsibilities

Please refer to the attached job description and person specification for main responsibilities of the role.

Person Specification

Education & Qualifications

Essential

  • Master's Degree or equivalent in Information Systems or in related subject (data analytics, health economics, statistics or management information etc) or proven equivalent experience.
  • Microsoft Certified Azure and data fundamentals

Experience & Knowledge

Essential

  • Experience working with Microsoft Azure Technologies, knowledge and experience in azure databricks, azure data factory, devops and Git
  • Experience of performing complex information analysis to support decision making
  • Experience of cloud data warehouse design and build

Skills & Ability

Essential

  • Experience of Azure and PBI development and developing in a cloud based environment
  • Skilled in writing code in python and/or R, advanced programming skills including SQL
  • Skilled in developing across the breadth of the modern data stack, specifically data ingestion, transformation and data layer delivery

Personal Qualities

Essential

  • Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels.
  • Service orientated, customer-focused with can do solutions attitude
Person Specification

Education & Qualifications

Essential

  • Master's Degree or equivalent in Information Systems or in related subject (data analytics, health economics, statistics or management information etc) or proven equivalent experience.
  • Microsoft Certified Azure and data fundamentals

Experience & Knowledge

Essential

  • Experience working with Microsoft Azure Technologies, knowledge and experience in azure databricks, azure data factory, devops and Git
  • Experience of performing complex information analysis to support decision making
  • Experience of cloud data warehouse design and build

Skills & Ability

Essential

  • Experience of Azure and PBI development and developing in a cloud based environment
  • Skilled in writing code in python and/or R, advanced programming skills including SQL
  • Skilled in developing across the breadth of the modern data stack, specifically data ingestion, transformation and data layer delivery

Personal Qualities

Essential

  • Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels.
  • Service orientated, customer-focused with can do solutions attitude

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.

Certificate of Sponsorship

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.

Certificate of Sponsorship

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).

Employer details

Employer name

306 North London NHS Foundation Trust

Address

St Anns Hospital

St Anns Road

Haringey

N15 3TH


Employer's website

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


Employer details

Employer name

306 North London NHS Foundation Trust

Address

St Anns Hospital

St Anns Road

Haringey

N15 3TH


Employer's website

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


Employer contact details

For questions about the job, contact:

Head of Data & Management Information Systems

Jayshree Pindoriya

j.pindoriya@nhs.net

02087024140

Details

Date posted

21 January 2025

Pay scheme

Agenda for change

Band

Band 8a

Salary

£59,490 to £66,239 a year per annum including Outer London Allowance

Contract

Permanent

Working pattern

Full-time

Reference number

306-BEH-2560

Job locations

St Anns Hospital

St Anns Road

Haringey

N15 3TH


Supporting documents

Privacy notice

306 North London NHS Foundation Trust 's privacy notice (opens in a new tab)