Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead SQL database design and development for the Mosaic Project, enhancing data-driven decisions.
- Company: Join a dynamic team focused on impactful projects with leading UK employers like the NHS.
- Benefits: Enjoy remote work, competitive pay, free training, healthcare options, and pension schemes.
- Why this job: Make a real impact by shaping reporting strategies while working from home in a supportive environment.
- Qualifications: Extensive SQL experience, knowledge of SSRS/Power BI, and mentoring skills required.
- Other info: Competitive daily rate outside IR35 and access to a dedicated consultant for support.
The predicted salary is between 36000 - 60000 £ per year.
We are looking for a SQL Reporting Specialist to lead the technical delivery of the Reporting Strategy for the Mosaic Project. This role is ideal for a candidate with extensive experience in SQL Server tools and a deep understanding of database management and reporting systems. The successful applicant will be instrumental in enhancing data-driven decision-making processes.
Day-to-day of the role:
-
Lead the design and development of SQL database architectures, focusing on automation and integration with various data sources.
-
Implement advanced SQL techniques to transform, extract, manipulate, and join data for analytics and business intelligence purposes.
-
Develop and maintain automated data flows, replacing manual processes to increase efficiency and accuracy.
-
Produce and optimise comprehensive data models across multiple subject areas and reverse-engineer data models from operational systems.
-
Design and maintain metadata repositories to support data integrity and accessibility.
-
Utilise SSRS and Power BI to create and manage advanced reporting solutions.
-
Conduct extensive testing to ensure the reliability and accuracy of data reports.
-
Mentor and train permanent team members on the Mosaic case management system and its reporting tools.
-
In-depth knowledge of Microsoft SQL Server tools, including SQL Server Integration Services (SSIS).
-
Proficiency in SQL standards such as T-SQL and PL/SQL.
-
Desirable experience with Microsoft Azure Synapse and/or Data Factory.
-
Advanced SQL skills for data manipulation and extraction from diverse sources.
-
Experience in database design, development, and maintenance within major software platforms like Liquidlogic LCS/EHM, Servelec Synergy/Mosaic, SAP, ERP, OLM CareFirst.
-
Strong knowledge of SSRS and Power BI for developing reporting solutions.
-
Proven ability to mentor others and deliver training on data reporting and management.
-
Experience in managing data dictionaries and conducting thorough testing phases.
-
Competitive daily rate outside IR35.
-
Opportunity to work on a significant, impactful project from the comfort of your home.
-
Chance to lead and influence the reporting strategies within a major project.
-
Access to a dedicated consultant for ongoing support.
-
Secure and user-friendly online system for timesheets, holiday requests, and employment documents.
-
Free training, access to discount clubs, healthcare options, and Reed rewards.
-
Inclusion in pension schemes, paid holiday schemes, and maternity benefits.
-
Opportunities to work with leading UK employers including local authorities, the NHS, and local SMEs.
SQL Reporting - MOSAIC employer: Reed Specialist Recruitment Ltd
Contact Detail:
Reed Specialist Recruitment Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Reporting - MOSAIC
✨Tip Number 1
Make sure to showcase your extensive experience with SQL Server tools during any networking opportunities. Engage with professionals in the field through platforms like LinkedIn, and don't hesitate to share your insights on database management and reporting systems.
✨Tip Number 2
Familiarize yourself with the specific technologies mentioned in the job description, such as SSRS, Power BI, and Azure Synapse. Consider creating a small project or case study that demonstrates your skills in these areas, which you can discuss during interviews.
✨Tip Number 3
Highlight any previous experience where you've led a team or mentored others, especially in the context of data reporting and management. This will show that you not only have the technical skills but also the leadership qualities that are essential for this role.
✨Tip Number 4
Stay updated on the latest trends and best practices in SQL reporting and database management. Join relevant online forums or communities where you can learn from others and share your knowledge, which can help you stand out as a candidate.
We think you need these skills to ace SQL Reporting - MOSAIC
Some tips for your application 🫡
Understand the Role: Make sure to thoroughly read the job description for the SQL Reporting Specialist position. Understand the key responsibilities and required skills, especially focusing on SQL Server tools and reporting systems.
Tailor Your CV: Customize your CV to highlight your experience with SQL Server, database management, and reporting tools like SSRS and Power BI. Include specific examples of projects where you led the design and development of SQL database architectures.
Craft a Strong Cover Letter: Write a compelling cover letter that showcases your passion for data-driven decision-making and your ability to mentor others. Mention any relevant experience with Microsoft Azure Synapse or Data Factory if applicable.
Highlight Technical Skills: In your application, emphasize your advanced SQL skills, including T-SQL and PL/SQL. Provide examples of how you've implemented automation and integration in previous roles to enhance efficiency and accuracy.
How to prepare for a job interview at Reed Specialist Recruitment Ltd
✨Showcase Your SQL Expertise
Be prepared to discuss your extensive experience with SQL Server tools. Highlight specific projects where you implemented advanced SQL techniques, and be ready to explain how you transformed and manipulated data for analytics.
✨Demonstrate Your Reporting Skills
Since the role involves using SSRS and Power BI, come equipped with examples of reporting solutions you've developed. Discuss how you optimized data models and ensured data integrity in your previous roles.
✨Emphasize Automation and Efficiency
Talk about your experience in developing automated data flows and replacing manual processes. Share specific instances where your contributions led to increased efficiency and accuracy in reporting.
✨Prepare for Technical Questions
Expect technical questions related to database design, maintenance, and testing phases. Brush up on your knowledge of T-SQL, PL/SQL, and any relevant experience with Microsoft Azure Synapse or Data Factory to impress the interviewers.
