Job summary
The IM&T Business Intelligence Team are looking to recruit a permanent BI Development Consultant. You will work in the BI Development Team in a leading and guiding capacity building new and innovating data and reporting capabilities. Of primary focus is exposing data from the Hospital's many clinical and operational systems to support production of information and reporting needs.
This is an exciting role supporting the Trust's adoption of Microsoft Cloud technologies. The post holder will have a key role in the design, development and on-going support of the Trust's business critical corporate Data Warehouse and BI Systems. These systems are critical within the organisation to support and maintain continuity of the Trust's business reporting, dashboards and other data processes. This role is crucial in developing new azure based data warehousing services and enabling the provision of accurate reporting through management of raw data from many source systems into the corporate Data Warehouse.
Familiar with latest versions of Microsoft SQL Server and Azure Cloud services, Office 365, SharePoint, PowerBi, you will support the Trust's adoption of Hybrid on-premise and Azure hosted Data Warehousing. You will develop and manage the development of ETL processes and enablement of real-time HL7/FIHR data integration.
Main duties of the job
The post holder will have a key role in the design, development and on-going support of the Trust's business critical corporate Data Warehouse and BI Systems. These systems are critical within the organisation to support and maintain continuity of the Trust's business reporting, dashboards and other data processes. The post holder has line management responsibilities for BI Team developer staff. The role is key in developing data warehouse services and enabling the provision of accurate reporting through management of raw data from multiple source systems into the corporate Data Warehouse. Based on Kimball dimensional modelling star schema design, you will work with various system owners, analytical staff and BI developers in understanding and translation of raw data into reportable and conformed data model solutions essential to the Trust's widely varying reporting needs, national and regional returns, monitoring for key performance indicators and targets.
Familiar with latest versions of Microsoft SQL Server and Azure Cloud services, Office 365, SharePoint, PowerBi, you will support the Trust's adoption of Hybrid on-premise and Azure hosted Data Warehousing.
About us
The UHNM NHS Trust covers Royal Stoke Hospital in Stoke on Trent and County Hospital in Stafford. Royal Stoke a large acute teaching hospital, with a Turnover of £360 million. Located in Stoke on Trent and Stafford, UHNM is close to the M6, within commuting distance of culturally diverse major conurbations, such as Manchester and Birmingham and surrounded by rural pleasures, including the Peak District National Park.
Each year Royal Stoke cares for over 600,000 people providing emergency treatment, planned operations and medical care. It is a leading teaching hospital in partnership with Keele University and has a patient-centred clinical research facility providing state-of-the-art facilities.
Investing in the health and wellbeing of our staff is really important to us. We offer a range of options for our staff to help maintain a good work-life balance including full time, part time hours and bank hours. We are also committed to offering flexible working wherever we can and where relevant to the role and the service. You can select your preferences upon application.
Job description
Job responsibilities
For further information on this vacancy, please see the attached Job Description and Person Specification or contact the Hiring Manager.
Job description
Job responsibilities
For further information on this vacancy, please see the attached Job Description and Person Specification or contact the Hiring Manager.
Person Specification
Essential Qualifications
Essential
- oEducated to degree level or equivalent experience.
- oEvidence of higher level study at Masters Level; Alternatively working IM&T knowledge and experience at an equivalent level
- oProficient in the use of Microsoft office suite / o365: Word, Excel, Powerpoint
- oExperience and / or qualifications specific in Database, Business Intelligence, Reporting or Analytics field
Knowledge, Skills, Training and Experience
Essential
- oSound understanding of Data Warehouse concepts and approachies to data modelling and techniques
- oPrevious expereince working with an effective data warehouse solutions as a developer or consumer.
- oFamiliarity in management of SQL-Server databases on-premise and Azure cloud
- oAbility to understand, interpret and critically analyse data and information
- oExperience in development of ETL processes from source through staging to final presented Data Warehouse reporting layer
- oUnderstanding and experience in specification and development of Kimball Star dimensional models from very complex NHS data.
- oSignificant technical skills in latest versions of SQL Server, Azure and components / Azure services.
- oHigh standard of coding skills in TSQL and supplementary data languages.
- oExperisnce with various data types such as XML, JSON, CSV, HL7/FHIR
- oKnowledge and familiarity with PowerBi, SSRS and other reporting tools.
- oExperience of using and creating project plans for medium to large system implementations
- oExperience working within a broad and complex corporate IT operational environment
- oExperience in leading or managing a diverse team
- oExperience of working across boundaries to develop networks with key stakeholders
- oAbility to accurately estimate task development durations
- oAbility to motivate and support others to achieve goals
- oAble to utilise initiative to solve problems and develop the service
- oBroad experience of project work and managing projects in a complex multi system environment
Desirable
- oAbility to contribute directly to the production of strategy and policy documentation
- oNHS or private healthcare experience
- oKnowledge of hospital information systems, particularly patient administration and clinical management systems.
- oSoftware Development skills.
Personal qualifications
Essential
- oA desire and drive to provide the best in data solutions
- oExcellent written and verbal communication skills, capable of communicating with staff at all levels within the organisation
- oAbility to work within a team, in a high pressure environment whilst maintaining operational and project targets.
- oSelf motivated and able to work autonomously, with a proactive outlook in the resolution of customer issues.
- oAbility to multi-task prioritising own workloads in response to service need
- oWork autonomously being accountable for own actions
- oA conscientious complete/ finisher with attention to detail and a willingness to share information.
- oGood influencing and networking skills
- oA desire to continue personal professional development, learn new technologies,
- oPositive mindset in respect of - Supporting organisational change; learning, and continuous improvement.
- oTakes responsibility and is accountable for delivering to their agreed objectives
- oConsistently professional, collaborative and compassionate in their approach
- oActs to support and enable effective teamwork
- oDelivers work of consistent and predictable high quality
Person Specification
Essential Qualifications
Essential
- oEducated to degree level or equivalent experience.
- oEvidence of higher level study at Masters Level; Alternatively working IM&T knowledge and experience at an equivalent level
- oProficient in the use of Microsoft office suite / o365: Word, Excel, Powerpoint
- oExperience and / or qualifications specific in Database, Business Intelligence, Reporting or Analytics field
Knowledge, Skills, Training and Experience
Essential
- oSound understanding of Data Warehouse concepts and approachies to data modelling and techniques
- oPrevious expereince working with an effective data warehouse solutions as a developer or consumer.
- oFamiliarity in management of SQL-Server databases on-premise and Azure cloud
- oAbility to understand, interpret and critically analyse data and information
- oExperience in development of ETL processes from source through staging to final presented Data Warehouse reporting layer
- oUnderstanding and experience in specification and development of Kimball Star dimensional models from very complex NHS data.
- oSignificant technical skills in latest versions of SQL Server, Azure and components / Azure services.
- oHigh standard of coding skills in TSQL and supplementary data languages.
- oExperisnce with various data types such as XML, JSON, CSV, HL7/FHIR
- oKnowledge and familiarity with PowerBi, SSRS and other reporting tools.
- oExperience of using and creating project plans for medium to large system implementations
- oExperience working within a broad and complex corporate IT operational environment
- oExperience in leading or managing a diverse team
- oExperience of working across boundaries to develop networks with key stakeholders
- oAbility to accurately estimate task development durations
- oAbility to motivate and support others to achieve goals
- oAble to utilise initiative to solve problems and develop the service
- oBroad experience of project work and managing projects in a complex multi system environment
Desirable
- oAbility to contribute directly to the production of strategy and policy documentation
- oNHS or private healthcare experience
- oKnowledge of hospital information systems, particularly patient administration and clinical management systems.
- oSoftware Development skills.
Personal qualifications
Essential
- oA desire and drive to provide the best in data solutions
- oExcellent written and verbal communication skills, capable of communicating with staff at all levels within the organisation
- oAbility to work within a team, in a high pressure environment whilst maintaining operational and project targets.
- oSelf motivated and able to work autonomously, with a proactive outlook in the resolution of customer issues.
- oAbility to multi-task prioritising own workloads in response to service need
- oWork autonomously being accountable for own actions
- oA conscientious complete/ finisher with attention to detail and a willingness to share information.
- oGood influencing and networking skills
- oA desire to continue personal professional development, learn new technologies,
- oPositive mindset in respect of - Supporting organisational change; learning, and continuous improvement.
- oTakes responsibility and is accountable for delivering to their agreed objectives
- oConsistently professional, collaborative and compassionate in their approach
- oActs to support and enable effective teamwork
- oDelivers work of consistent and predictable high quality
Additional information
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).
