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 Care
Line management of 3x 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 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 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 our reports
Generic Accountabilities:
To maintain personal and professional development to meet the changing demands of the job, participate in appropriate training activities and encourage and support staff in their development and training
To undertake other such duties, training and/or hours of work as may be reasonably required and which are consistent with the general level of responsibility of this job
To undertake health and safety duties commensurate with the job and/or as detailed in the Directorate’s Health and Safety Policy
The duties described in this job description must be carried out in a manner which promotes equality of opportunity, dignity and due respect for all employees and service users and is consistent with the Council’s Equality and Diversity Policy
This post meets Regulated Activity (as defined by the Safeguarding Vulnerable Groups Act 2006 as amended by the Protection of Freedoms Act 2012) and is subject to an enhanced Criminal Records Check (Via the Disclosure Barring Service, DBS) and the relevant children and/ adults barred list(s) checks.