Reporting & Data Analyst - Mosaic
We have an exciting opportunity for a Reporting & Data Analyst to join us!
This is a full-time, one-year fixed term role and a salary of £36,433 - £47,035 per annum.
The Royal Borough of Windsor and Maidenhead (RBWM) is set in the wider county of Berkshire, one of the most economically productive and innovative areas of the country. The borough council – a unitary authority - takes pride in its exceptional team of dedicated professionals who are passionate about providing quality services to the community RBWM is a unique borough, with huge opportunity given its proximity to London and expanding business sectors, as well as being a major cultural and tourism area which includes international attractions such as Windsor Castle, Legoland and Ascot Racecourse.
Given our Royal connections, the eyes of the world are often on us and we continue to rise to the challenge.
The Role:We are seeking a dedicated and skilled Reporting & Data Analyst to join the Mosaic Implementation Project at RBWM. The ideal candidate will have experience working with the Mosaic system, SQL development tools, and Power BI. This role will be crucial in developing, maintaining, and improving the reporting solutions that supports our social care services.
This is a new role within the implementation of the new Adult Finance and Social Care electronic recording system. An experienced Mosaic Report Developer is required to design and implement and test the new statutory and bespoke operational reports for all Adult Finance and Social Care services across RBWM and Optalis within a limited period.
The successful candidate will be part of Project Team, supervised by the Workstream Lead and Project Manager.
Pre-requisites for applying:All applicants require experience of reporting from Mosaic, Liquid Logic or similar case management systems within Adult Social Care.
All applicants have knowledge of or can demonstrate an understanding of adult social care processes and requirements for performance management and statutory reporting.
The successful candidate will be required to work on site in Maidenhead, at least three days a week throughout the project.
You will: Develop report specifications and work to prioritise reports development working alongside key stakeholders.
Design, develop, and maintain SQL queries and stored procedures for reporting and data extraction.Design, develop, and deploy interactive dashboards and reports using Power BI.
Conduct data analysis to support social care services and identify areas for improvement.
Work closely with social care teams to understand their reporting requirements and develop solutions.
Conduct thorough testing of all reports and dashboards to ensure accuracy and reliability.
What we are looking for: Proven experience working with the Mosaic system in a social care environment.
Strong SQL development skills, including experience with queries, stored procedures, and database management.Proficiency in Power BI for data visualization and dashboard creation.
Excellent analytical and problem-solving skillWhat we offer:
32 days annual leaveFlexible working including a hybrid working pattern for a better work-life balance.
Generous Local Government Pension scheme includes life cover (3 times of annual salary); and an Additional Voluntary Contribution (AVC) scheme to enhance your pension provision.
Free employee parking close to the offices.
Give As You Earn scheme.
Instant Reward Scheme to recognise and reward innovative achievement.
Employee Assistance Programme providing counselling, advice and information.
Access to discounts and deals with hundreds of retailers, including discounted gym memberships and travel deals.
RBWM values a collaborative and inclusive work environment, fostering creativity and innovation in all aspects of its operations. As an equal opportunities’ employer, we encourage applications from all as we believe diverse talent makes us stronger.
If you have a disability, are a current or former member of the armed forces or have been part of any formal care system up to the age of 25, you will be guaranteed an interview, should you meet the minimum requirements for the role.