Job summary
This is a vital role within the busy Data Management team of the Trust. The post holder will be responsible for supporting the BI team with the design, development and delivery of high-quality Power BI datasets, working closely with other members of the Data Management team and Data Visualisation leads to ensure the datasets meet the Trust reporting requirements
The post holder will also support other members of the Data Management team with analysis, design and development of the Trust data warehouse. The post holder will also support the Data Visualisation Leads across the BI team in the use of the datasets by providing expert advice and guidance and by completion of comprehensive documentationRole subject to job matching
Main duties of the job
- To be responsible for the creation, management, monitoring and continued development of the Trust Power BI datasets and associated systems on a day-to-day basis.
- Provide support with the ongoing management and development of the trust data warehouse and associated systems, including identification, management, and implementation of projects to further develop and enhance the systems.
- Support the development of intuitive, web-based reporting, analysis, and dashboarding for all levels of the Trust including clinicians, service managers, and directors.
- To support the ongoing maintenance and effective validation of the system to ensure it is fit for purpose, including adherence to National and local information standards and reporting requirements.
- To explore advances in data warehousing and reporting technologies appropriate to the organisation.
- To commit to continual education through formal training, informal skills transfer and self-tuition. This post requires continual upgrading of skills to reflect rapid changes in technology.
- Based on own learning and research to introduce, develop, and improve Trust data warehousing and reporting processes in order to support and improve clinical and operational decision making and therefore support the delivery of the Trust's strategic objectives
About us
Greater Manchester Mental Health (GMMH) Foundation Trust employs over6,400members of staff, who deliver services from more than160locations.
We provide inpatient and community-based mental health care for people living in Bolton, the city of Manchester, Salford,Trafford and the borough of Wigan, and a wide range of specialist mental health and substance misuse services across Greater Manchester, the north west of England and beyond.
Greater Manchester is one of the world's most innovative, original and exciting places to live and work. From the beauty of the surrounding countryside to the heart of the vibrant inner city with great shopping, entertainment and dining options.
Wherever you go you will experience a great northern welcome with people famed for their warmth, humour and generosity.
Our people enjoy their work, have opportunities to learn and develop their skills and are encouraged to generate new ideas that improve care for our service users.
Job description
Job responsibilities
- To support developing and maintaining the data warehousing environment architecture, data source identification and assessment, data modelling, data imports, data quality, data storage, and data security
- To support the development of data warehouse data sources and information processing, working closely with the team, IT, and operational colleagues.
- To support the management of data and information flows from operational/departmental systems into the data warehouse, ensuring that all key data items are stored efficiently and in a way that is conducive to effective and efficient information reporting.
- To support the improvement and streamlining of existing processes and data feeds from systems to promote greater efficiency and effectiveness. To promote the automation of standard, regular reports.
- To design, code, test, and implement efficient and robust database schemas, SQL queries, views, stored procedures as part of the data warehouse development and maintenance.
- To ensure the proactive management of the integrity of data within the warehouse, investigating, raising, and resolving issues with appropriate colleagues, internally and externally.
- To assist team members with database analysis and data interpretation, including problem solving using SQL programming, use of advanced functions and complex methodology.
- Evaluation of system data to ensure data quality and correct system functionality
- Investigation of new technologies and providing advice to senior management on benefits and application within the business
- Responsibility for adhering to data security of patient and any other sensitive information.
Staff benefits
- Pay Enhancements 30% additional for Evenings (8pm onwards) and Saturdays and 60% additional for Sundays and Bank holidays.
- 27 days annual leave plus bank holidays rising to 29 after 5 years and 33 days after 10 years
- Excellent pension
- Cycle to work scheme
- Salary sacrifice car scheme
- Wellbeing programme
- Blue Light Card Discounts
Job description
Job responsibilities
- To support developing and maintaining the data warehousing environment architecture, data source identification and assessment, data modelling, data imports, data quality, data storage, and data security
- To support the development of data warehouse data sources and information processing, working closely with the team, IT, and operational colleagues.
- To support the management of data and information flows from operational/departmental systems into the data warehouse, ensuring that all key data items are stored efficiently and in a way that is conducive to effective and efficient information reporting.
- To support the improvement and streamlining of existing processes and data feeds from systems to promote greater efficiency and effectiveness. To promote the automation of standard, regular reports.
- To design, code, test, and implement efficient and robust database schemas, SQL queries, views, stored procedures as part of the data warehouse development and maintenance.
- To ensure the proactive management of the integrity of data within the warehouse, investigating, raising, and resolving issues with appropriate colleagues, internally and externally.
- To assist team members with database analysis and data interpretation, including problem solving using SQL programming, use of advanced functions and complex methodology.
- Evaluation of system data to ensure data quality and correct system functionality
- Investigation of new technologies and providing advice to senior management on benefits and application within the business
- Responsibility for adhering to data security of patient and any other sensitive information.
Staff benefits
- Pay Enhancements 30% additional for Evenings (8pm onwards) and Saturdays and 60% additional for Sundays and Bank holidays.
- 27 days annual leave plus bank holidays rising to 29 after 5 years and 33 days after 10 years
- Excellent pension
- Cycle to work scheme
- Salary sacrifice car scheme
- Wellbeing programme
- Blue Light Card Discounts
Person Specification
Qualifications
Essential
- Degree or equivalent and / or relevant technical experience
- Evidence of continuous professional development
Desirable
- Project management qualification
Experience
Essential
- Experience of implementing reporting datasets (Power BI/ Tableau) across a range of service areas
- Experience in the development and management of Data warehouse systems
- Significant experience of working within an informatics function/role
Knowledge
Essential
- Skilled in the use of SQL Server
- Understanding of the Azure data platform for SQL
- Understanding of Data Architecture / Data Modelling principles and practices
- Experience of working within an agile environment
Skills
Essential
- Ability to prepare and produce concise yet insightful communications for dissemination to senior stakeholders and a broad range of stakeholders as required
- Works logically, with great attention to detail and will be tenacious in resolving problems
- Demonstrated capabilities to manage own workload and make informed decisions in the absence of required information, working to tight and often changing timescales
Desirable
- Line Management to include the personal development and appraisal process
Person Specification
Qualifications
Essential
- Degree or equivalent and / or relevant technical experience
- Evidence of continuous professional development
Desirable
- Project management qualification
Experience
Essential
- Experience of implementing reporting datasets (Power BI/ Tableau) across a range of service areas
- Experience in the development and management of Data warehouse systems
- Significant experience of working within an informatics function/role
Knowledge
Essential
- Skilled in the use of SQL Server
- Understanding of the Azure data platform for SQL
- Understanding of Data Architecture / Data Modelling principles and practices
- Experience of working within an agile environment
Skills
Essential
- Ability to prepare and produce concise yet insightful communications for dissemination to senior stakeholders and a broad range of stakeholders as required
- Works logically, with great attention to detail and will be tenacious in resolving problems
- Demonstrated capabilities to manage own workload and make informed decisions in the absence of required information, working to tight and often changing timescales
Desirable
- Line Management to include the personal development and appraisal process
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).
