What's involved with this role:
Up to £333.00 per day PAYE depending on experience
Interim SQL Reporting MOSAIC
Reference no: Calderdale 0009 A030 / 1
Pay Rate: £333.00 per day PAYE
37 Monday - Friday, normal working hours
This opening assignment is for 3 months
City: HALIFAX
Standard DBS disclosure required
Remote working
It 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.
Key Responsibilities:
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.
Key requirements:
In-depth knowledge of Microsoft SQL Server tools, including SQL Server Integration Services (SSIS).
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.
Experience in writing optimised queries, views, and triggers for integration with other data sources.
Experience in producing relevant data models across multiple subject areas.
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.
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 SQL skills, with the ability to transform, extract, manipulate, and join/match data from a variety of sources.
Ability to reverse-engineer data models from a range of operational and transactional systems.
Proficiency in various SQL standards (e.g., T-SQL, PL/SQL).
Desirable:
Experience with Microsoft Azure Synapse and/or Data Factory
Please quote the Job Title & Vacancy Reference No. in your application, or we will be unable to match your CV to the role being applied for.
Qualification details and any other experience/skills relevant to the role to help support your application should be clearly shown in your CV.
Due to the number of CVs being sent to us unfortunately we cannot respond to all applications. If you have not heard from us within 3 working days please assume that you have not been shortlisted on this occasion.
1
Job Ref: Calderdale 0009 A030 / 1
Anticipated Length of Assignment: Unless otherwise stated (we do carry the occasional permanent vacancy) all of our roles are technically temporary, though opening assignments can be and often are, extended by clients on a longer term basis and can sometimes become permanent.
Please do try to resist contacting us with requests for progress updates.
We really do read every CV sent to us. All applications will be acknowledged by a human, not a robot, provided the job remains live and provided your CV meets the “Essential Requirements” listed.
Please note that we do our level best to take down ads as soon as roles have been filled. We are not in the business of harvesting CVs.
Important: We will interpret your application as being permission to submit your CV to this role (with the right to represent you) unless you advise us to the contrary.