Job summary
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 Tableau and Microsoft Power BI.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
o You must have experience of developing a range of reports and dashboards, from creating data models in Power BI to writing complex DAX.o 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 requiremento To design and develop Datawarehouse and Business Intelligence code across database engine, SSIS ,SSAS ,SSRS. Should be proficient in SQL Programming Languages.o 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
Arden & GEM is one of the largest Commissioning Support Units in the country. Our customers include more than 60 Clinical Commissioning Groups (CCG), NHS England, local authorities, and a range of care providers.With offices throughout the Midlands, North West and South East we cover a core geographic patch that extends to Greater Manchester in the north and Essex in the south. Our services are built on a strong foundation of experienced people who build great relationships, a commitment to NHS values and a thorough understanding of our clients and the challenges they face.We provide real value to our customers by working at scale, creating the synergies and innovation that ultimately drives improved patient outcomes and makes commissioning resources work harder.Our cornerstones are quality, value, innovation, and complete customer focus.Why join us:o We will provide you with the opportunity to work on a continuous stream of new and exciting developments using new and varied technologieso We will provide a unique opportunity to develop your skillso A chance to contribute to the way we develop software such as implementing industry standard practices using test driven development
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
- 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 Tableau, Power BI or industry standard reporting software
- Experience of data manipulation and database storage to support reporting technologies
- Trained in the development and use of Microsoft SQL Server databases and reporting tools (SSRS, SSIS, SSAS).
Desirable
- Must have 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 Tableau Power BI Power Automate
- Comprehensive knowledge of project principles, techniques and tools, such as Prince 2 Foundation Or Agile PM
- Skilled in the use of Tableau Skilled in the use of Power BI
- Demonstrated experience in a Healthcare environment
Person Specification
Essential
Essential
- 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 Tableau, Power BI or industry standard reporting software
- Experience of data manipulation and database storage to support reporting technologies
- Trained in the development and use of Microsoft SQL Server databases and reporting tools (SSRS, SSIS, SSAS).
Desirable
- Must have 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 Tableau Power BI Power Automate
- Comprehensive knowledge of project principles, techniques and tools, such as Prince 2 Foundation Or Agile PM
- Skilled in the use of Tableau Skilled in the use of Power BI
- 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.
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.
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).
