Lead Reporting and Data Analyst

Lead Reporting and Data Analyst

37 Hours per week

3 Month Contract

Hereford - Hybrid with requirement as 1 day per week in person

£400 per day

Purpose of Job:

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

Main Activities & Responsibilities:

Lead in the designing and maintenance of statutory and operational reporting for Children Social CareLine management of 3x Data AnalystsProvide expert knowledge and guidance to teams and people on technical best practiceEffectively 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 our 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 businessCollaborate 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 deliveryLead on improving customer satisfaction and engagement

Research and identify BI options for existing and new services to aid service improvementDesign 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 our reports