SQL Reporting – MOSAIC Project

MR-288

£450 Per Day

Full Time

Contract

Halifax, West Yorkshire

Social Care

Posted 2 hours ago

Expires In 29 Days

Job Description

SQL Reporting – MOSAIC Project, Halifax
Pay rate £450 per day
This is a highly specialised and technical role and requires someone who can pump prime the delivery of the technical elements of the Reporting Strategy for the Mosaic Project.
Job Purpose and Responsibilities: -

In-depth knowledge of Microsoft SQL Server tools, including SQL Server Integration Services (SSIS).
Experience with Microsoft Azure Synapse and/or Data Factory (desirable).
Proficiency in various SQL standards (e.g., T-SQL, PL/SQL).
Advanced SQL skills, with the ability to transform, extract, manipulate, and join/match data from a variety of sources.
Lead efforts in database design, development, maintenance, and management.
Design, develop, and implement automated data flows to extract, transform, and join data sources for analytics and business intelligence systems.
Review manual data flows and identify opportunities to develop automated data flows.
Develop and maintain appropriate metadata repositories.
Experience in writing optimised queries, views, and triggers for integration with other data sources.
Experience in producing relevant data models across multiple subject areas.
Ability to reverse-engineer data models from a range of operational and transactional systems.
Experience in designing and maintaining appropriate metadata repositories.
Experience in designing SQL database architecture within major software platforms (e.g., Liquidlogic LCS/EHM, Servelec Synergy/Mosaic, SAP, ERP, OLM CareFirst).
Advanced knowledge and experience with the Mosaic case management system and its reporting infrastructure (e.g., mapping, filters, and switches).
Knowledge and skills with SSRS (SQL Server Reporting Services) and Power BI.
Willingness to mentor and upskill permanent council employees within the Reporting Team to independently create and maintain Mosaic reports.
Experience and willingness in delivering training to team members.
Experience in conducting thorough testing phases.
Experience in managing data dictionaries and metadata with regular maintenance and detailed record-keeping.

Please contact Molly Rylance on 07815461919 or email molly.rylance@vitalissocialcare.co.uk for more information.
We recruit across all areas of Qualified Social Work. If you are a Social Worker and this isn’t the role for you, contact us about other roles including IRO, BIA, MASH, LAC, Children’s Social Work, Adult Social Work, Service Manager, Head of Service, Team Manager and Assistant Team Manager.

Apply for this Job