NHS Arden and Greater East Midlands Commissioning Support Unit

Principal Reporting Solutions Developer

Information:

This job is now closed

Job summary

We are looking for a Reporting Developer expert in Power BI & Power Automate to contribute to the production and development of the Power BI environment within Arden & GEM.Working as part of our Systems, Application and Reporting Team, you will be required to design and develop reporting solutions using a wide range of reporting tools including but not limited to Microsoft Power BI and Tableau.The successful candidate will be responsible for building end-to-end processes. It will include the final solution's design, development, testing, documentation, and maintenance.You will be using your in-depth knowledge of Power BI and apply your strong data visualisation skills and creative flare to turn user stories into stunning solutions to address a wide range of clinical, operational, strategic questions.You will be required to utilise various software tools including the use of Microsoft SQL Server databases and its associated tools (SSRS, SSIS, SSAS).The post is home or remote working; therefore, suitable environment at home required to facilitate home working.

Main duties of the job

  • You must have experience in Power BI Reports production, Power Automate and a working knowledge of Power Apps.
  • You will possess the ability to strategically plan within Power BI and solve problems.
  • Additionally, experience Tableau or other reporting software is preferable.
  • You must have experience of developing a range of reports and dashboards, from creating data models in Power BI to writing complex DAX.
  • The Reporting Developer must be passionate about report design, proactive, results-driven, and detail-oriented; the candidate must thrive in a team environment and be able to work independently.
  • The post holder will work within the Systems and Reporting Team, as a Principal Reporting Solutions Developer interacting with the Lead; Business Analysts; the wider development team and AGEM customers to ensure effective service delivery and to ensure core service outputs are delivered on time and as per requirement.
  • To design and develop Datawarehouse and Business Intelligence code across database engine, SSIS ,SSAS ,SSRS. Should be proficient in SQL Programming Languages.
  • Should be familiar with SharePoint Technology for BI reports Integration. Any knowledge on Microsoft .Net technology and Programming(C#/VB.Net) is nice to have.

About us

Why join us:

  • We will provide you with the opportunity to work on a continuous stream of new and exciting developments using new and varied technologies
  • We will provide a unique opportunity to develop your skills
  • A chance to contribute to the way we develop software such as implementing industry standard practices using test driven development

Details

Date posted

08 November 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year pa

Contract

Permanent

Working pattern

Full-time

Reference number

880-5767766

Job locations

St Johns House

Leicester

LE1 6NB


Job description

Job responsibilities

The post holder will act as the Principal Reporting Solutions Developer for the Business Intelligence development function

This role will work within a strategic framework set by AGEM CSU, however contributions to design, implementation and work stream execution will be made by this role. This role is critical to support key decision makers to monitor performance, enhance service planning and lead to better delivery of services across a wide spectrum of needs and settings.

This role will have to develop and support systems throughout AGEM CSU / NHS England user base and engage users at all levels to understand their needs.

Job description

Job responsibilities

The post holder will act as the Principal Reporting Solutions Developer for the Business Intelligence development function

This role will work within a strategic framework set by AGEM CSU, however contributions to design, implementation and work stream execution will be made by this role. This role is critical to support key decision makers to monitor performance, enhance service planning and lead to better delivery of services across a wide spectrum of needs and settings.

This role will have to develop and support systems throughout AGEM CSU / NHS England user base and engage users at all levels to understand their needs.

Person Specification

Essential

Essential

  • Significant senior reporting experience, including research and development.
  • Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area.
  • Experience of reports creation using Power BI reporting software
  • Experience of data manipulation and database Using Power Automate

Desirable

  • Excellent knowledge of most of the following technologies :- SQL Server TSQL Programming SSIS Programming SSAS Cube Design DAX Language MDX Language R language SharePoint Technologies Performance Point Dashboards
  • Comprehensive knowledge of project principles, techniques, and tools, such as Agile PM
  • Skilled in the use of Tableau
  • Demonstrated experience in a Healthcare environment.
Person Specification

Essential

Essential

  • Significant senior reporting experience, including research and development.
  • Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area.
  • Experience of reports creation using Power BI reporting software
  • Experience of data manipulation and database Using Power Automate

Desirable

  • Excellent knowledge of most of the following technologies :- SQL Server TSQL Programming SSIS Programming SSAS Cube Design DAX Language MDX Language R language SharePoint Technologies Performance Point Dashboards
  • Comprehensive knowledge of project principles, techniques, and tools, such as Agile PM
  • Skilled in the use of Tableau
  • Demonstrated experience in a Healthcare environment.

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

NHS Arden and Greater East Midlands Commissioning Support Unit

Address

St Johns House

Leicester

LE1 6NB


Employer's website

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

Employer details

Employer name

NHS Arden and Greater East Midlands Commissioning Support Unit

Address

St Johns House

Leicester

LE1 6NB


Employer's website

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

Employer contact details

For questions about the job, contact:

Principal BI Developer

Mark Atkins

mark.atkins1@nhs.net

Details

Date posted

08 November 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year pa

Contract

Permanent

Working pattern

Full-time

Reference number

880-5767766

Job locations

St Johns House

Leicester

LE1 6NB


Supporting documents

Privacy notice

NHS Arden and Greater East Midlands Commissioning Support Unit's privacy notice (opens in a new tab)