£450 Per Day
Full Time
Contract
Halifax, West Yorkshire
Social Care
Posted 14 hours ago
Expires In 29 Days
Job Description
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.
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.
Molly Rylance V34
Molly.Rylance@vitalissocialcare.co.uk
0161 393 7038
Division V34
The Talent Crowd
Jobs With VitalisRecommended Jobs
Childcare Worker
Network Recruitment Wales
£12 - £21 Per Hour
Vale of Glamorgan, Vale of Glamorgan
Temporary
Posted 5 days ago
Ref RQ1447884
Project Officer, Public Health (Sexual Health) - Kent
Pertemps Social Care
£19.37 Per Hour
Kent, Kent
Contract
Posted 8 days ago
Ref EM-2939
Project Officer, Public Health (Sexual Health) at Kent
Pertemps Social Care
£19.37 Per Hour
Kent, Kent
Contract
Posted 8 days ago
Ref HO-25287