Lead Reporting and Data Analyst

Duration: 3 months

Start: ASAP

Rate: £400 per day (Inside IR35)

Hybrid Working: You will be required to travel to the office one day per week

Our client is looking for someone to oversee statutory and operational reporting for Children’s Social Care, manage a team of 3 Data Analysts, and ensure the accuracy of SQL-based statutory returns while developing Power BI and SSRS reports.

Responsibilities:

• Lead in the designing and maintenance of statutory and operational reporting for Children Social Care
• Line management of three Data Analysts
• Provide expert knowledge and guidance to teams and people on technical best practice
• Effectively communicate business requirements clearly to the team to ensure joint understanding, and working closely with the Mosaic development team to keep up to date with the changes on the case management system which then needs to be reflected in the statutory and operational reports
• Ensuring that the architecture of the data warehouse is fit for purpose
• Ensuring data accuracy in all reports the team produces, or address issues with Children’s Services if user input of Mosaic is the issue
• Lead in the implementation of the agile methodology process within the team and be instrumental in educating other areas of the business
• Collaborate and partner with all parts and levels of the organisation as an expert technical advisor
• Lead in the application of agile techniques to ensure digital solutions meet the requirements of both the business and the user, providing simple, functional, flawless and quick delivery
• Lead on improving customer satisfaction and engagement
• Research and identify BI options for existing and new services to aid service improvement
• Design and deliver digital solutions using your expert knowledge of SSRS and SQL
• Maintain and apply up to date, specialist knowledge of database concepts, object and data modelling techniques and design principles and assist BI developers in these areas
• Provide secure information provision and ensure full compliance of GDPR in the reports

Requirements:

• You will have overseen statutory reporting for Children Social Care
• You have expert knowledge and skills in the architecture of the data warehouse
• You will have expert knowledge and skills in writing SQL scripts for accurate statutory returns and operational reporting
• You will have knowledge and understanding of Children’s social care case management system (ideally Mosaic)
• You will have a sound knowledge and skills on creating BI solutions, especially PowerBI dashboards and SSRS
• You will have line managed Data Analysts or equivalent
• You will work closely with the Data Lead, Business Systems Analysts for Mosaic, Children’s Services, the Education Analysts, and the rest of the organisation

If you have the skills and experience required, we encourage you to apply.