_{21st January, 2025}

Are you eager to land a brand new role? Our client, a busy local authority in West Yorkshire, are looking for an experienced SQL Reporting Consultant to join their team and play a crucial role in their reporting & delivery operations. 

Position: SQL Reporting Consultant
Salary: £450 per day (Inside IR35) 
Contract: Temporary (July 2025) with Possible Extension
Working Pattern: Fully Remote - Working from Home

Key Responsibilities:

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.

• 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.

Job Requirements:

• Previous experience working within a local authority or a similar organisation.
• At least 2 years experience within a SQL Reporting Consultant role or equivalent.
• Evidence of continuing professional development.

Please be advised that only candidates that have the specific skills and experiences required for this role will be shortlisted and submitted to our client for review. 

How to Apply:
If you are interested in applying, please press the button below, send your CV to james.fernandez@temptingrecruitment.co.uk or contact James on      020 3854 4907 to discuss further.

To explore other exciting opportunities or learn more about our recruitment process, please visit our website https://www.temptingrecruitment

Apply For Job