SQL Reporting Specialist

SQL Reporting Specialist needed in Halifax Paying  £450 per day ref 0009 A030 /1

Full time hours on a temporary basis 

We are seeking an SQL Reporting Specialist with a strong background in Microsoft SQL Server tools and advanced SQL skills. The ideal candidate will lead efforts in database design, development, maintenance, and management.

Key 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 team members 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.

• Requirements:

  • Proven experience in SQL reporting and database management.

  • Strong analytical and problem-solving skills.

  • Excellent communication and mentoring abilities.

  • Ability to work independently and collaboratively.

Employment is acting as an Employment Business in relation to this vacancy. Essential Employment is an Equal Opportunities Employer.

All our roles may be subject to pre-employment checks including references so please be prepared