- 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.
Back to searchSQL Reporting - MOSAIC Project
Vitalis
Posted 9 hours ago, valid for 9 days
Halifax, West Yorkshire HX1 2XW
£450 per day
Full Time
In order to submit this application, a Reed account will be created for you. As such, in addition to applying for this job, you will be signed up to all Reed’s services as part of the process. By submitting this application, you agree to Reed’s Terms and Conditions and acknowledge that your personal data will be transferred to Reed and processed by them in accordance with their Privacy Policy.
Sonic Summary
- The SQL Reporting role for the MOSAIC Project in Halifax offers a pay rate of £450 per day.
- Candidates should possess in-depth knowledge of Microsoft SQL Server tools and advanced SQL skills, with experience in database design and development.
- Experience with Microsoft Azure Synapse and/or Data Factory is desirable, along with proficiency in various SQL standards such as T-SQL and PL/SQL.
- The role requires the ability to mentor and upskill team members, as well as experience in managing metadata repositories and conducting testing phases.
- This position is suitable for those with a strong background in SQL and reporting infrastructure, particularly with the Mosaic case management system.
