Job Title:         

London Innovation and Improvement Alliance (LIIA) Intelligence Analyst

Responsible to: LIIA Lead Intelligence Analyst

Responsible for:  n/a

Key Contacts:

ALDCS, Children’s Services Practice Leaders Network, LA HR Leads, London Councils Officers, London Information Exchange Group (LIEG)[children’s], Data to Insight (d2i).  Leaders and strategy makers across services for children in London.

Band:  D

Job Purpose

•To assist in the delivery of a portfolio of data products for the London Innovation and Improvement Alliance (LIIA), that inform strategy and practice across children’s services in London.

• Deputise for the LIIA Strategic Intelligence Lead or the Lead Intelligence Analyst when required

• To continue the development of the dataset and products which support the work of The London Innovation and Improvement Alliance (LIIA) on behalf of the Association of London Directors of Children’s Services (ALDCS) sector-led improvement partnership (hosted by London Councils)

• To maintain existing products with data refresh when new data releases are available

Principal Accountabilities

1.  Delivery of data to support objectives of the LIIA

o  Required outcomes are delivered to relevant quality standards within agreed timescales

o  Engagement with stakeholders to ensure the provision of suitable data products.

2.Support Deep Dive work and Peer Review / Challenge with data for the LIIA

o Uses knowledge or experience in the specific service delivery area, or conducts desk-based research using DfE & other organisations’ statistical releases or local data to provide analysis

o Data is delivered to agreed timescales to stakeholders

o Supports other data aspects of LIIA Peer Review/ Challenge work

3. Gather, assess and document the requirements for data products and projects.

o The requirements for data products and projects are understood and communicated.

o Opportunities for innovation and transformation in the design and delivery of work are identified and maximised.

o Work with colleagues across London as required, to help design & coordinate the efficient implementation of data collections supporting LIIA & ALDCS projects.

o Produce monitoring information and analysis as required.

4. Extract, manipulate and integrate data using data science techniques so that it can be used effectively for analysis and reporting

o Data is transformed into a format and structure using tools such as excel, Power BI or code (i.e. Python) to enable further analysis.

o Accurate information and valuable intelligence can be extracted through data analysis.

o For specific projects stakeholders are able to interrogate data using self-serve dashboards built in software such as power bi.

o Use manual methods to update existing data tools where the data stack is simple such as pasting data in excel to existing tools.

• Design and develop data models and processes to enable comprehensive and accurate reporting.

o   Data models & analytics are designed & implemented to produce accurate, useable intelligence.

o  Data models & analysis exploit new developments and improvements in data Intelligence technologies, approaches and methods.

6.  Produce quarterly data & performance information to deliver SLI performance information to staff at all levels

o  Assist in the Production of quarterly data & performance information compiled from the data submitted by London data managers

o  Produce quarterly and annual analysis of trends based on the range of indicators agreed by ADCS and ALDCS and drawing from local and published data

o  Give regular feedback to the LIIA Lead Intelligence analyst of any items of significance (eg. sudden regional/London-wide changes)

o  Work with Data to Insight (d2i) colleagues responsible for ChAT and the London Information Exchange Group (LIEG), to look at how to obtain the ‘raw data’ required for the dashboards directly from the London Boroughs in the most efficient way.

o Provide periodic feedback to individual data managers and the LIEG about the data submitted (inconsistencies, anomalies etc)

7.  Manage the communication of releases, products and general data information to stakeholders

o  The ALDCS Sector-led Improvement (SLI) website (www.LIIA.london) is updated on an agreed basis with quarterly data releases when required

o  The administration of users to the data restricted areas of the website is maintained on a timely basis

o  Content for the data area of the www.LIIA.london website is uploaded and updated when required. 

o  Ad-hoc communications are delivered when requested for example via email or meetings.

o  Work with LIIA Programme Management Team/ London Council Comms team as required

8. Ensuring access for stakeholders to the suite of data products.

o  Raising timely requests with IT to ensure and maintaining the directory of contacts to access Power BI products

o  Assisting with Ad-hoc enquiries on access or usage of any LIIA data products. Supporting the use of dashboard tools, by swiftly responding to queries and demonstrating usage with users.

9. Work with a range of partners and stakeholders across London & England

o Support the LIIA objectives, plans and projects with various partner organisations across London and sometimes beyond.

o Collaborate with colleagues in these organisations on topics such as data synchronisation/ alignment, secure data transfer with due regard to Data Protection and GDPR requirements.

o Work with data & intelligence colleagues across the eight other regions in England, d2i and other organisations working in the data & intelligence space.

General Accountabilities

10.  Undertake / support consultation procedures. Identify issues, resolving as appropriate and escalating complex problems if necessary.

o Activities are undertaken according to relevant guidelines / regulations / procedures.

o Customer / stakeholder views are available to inform recommendations.

o Data and measurements are accurately recorded.

11.  Collate process and analyse complex information. Ensure all required records and information are maintained correctly in accordance with Information Governance.

o  Information is managed efficiently and accurately.

o  Data is recorded and stored in compliance with policies.  These may include but not restricted to local council policies, the ALDCS Memorandum of Understanding or specific Information Governance Agreements.

12.  Prepare and present results / responses / reports / recommendations.

o  Accurate, complete and relevant information / reports are provided for LIIA Project Team or other stakeholders use.

o  Issues are clearly summarised, progress and implications are reported.

13.  Work closely with others to clarify changing requirements. Identify, recommend and support the development and delivery of improvements. Contribute to the development and implementation of procedures and systems.

o  Improvement opportunities and plans to achieve them are identified and recommended.

o Agreed improvements are developed, delivered and evaluated.

o  Changes are effectively communicated to others

14.Lead projects or improvement programmes, or contribute to the delivery of larger projects

o  Practical, effective solutions are developed and delivered in accordance with legislative requirements and good practice guidelines and address any relevant environmental / conservation / technical / design issues.

o  Projects are delivered to agreed specification, timescales and budgets.

o All project documentation and reports are completed correctly

15.  Develop good working relationships and communicate effectively with internal / external organisations / partners and stakeholders. Represent specialist area internally and / or externally. Model, demonstrate and promote good practice relevant to the role.

o  Relevant work area reputation is maintained or enhanced.

o  Stakeholders are engaged with activity relevant to them.

o Positive feedback is received from stakeholders.

o Communications are clear, well planned and effective.

o Best practice is shared and promoted.

16.Support partnership agreements and partnership working within area of responsibility.

o Activities which support partnership working are effectively delivered.

o Partnership working groups produce valid and timely outputs.

17.  Quality check documents, decisions and / or presentations before delivery

o All work meets the required standards

18.  Act in accordance with all policies and procedures which apply to the job and understand the reasons for this.

o All policies and procedures are complied with.

• To adhere to London Councils’ corporate policies, procedures, regulations and protocols, including the Data Protection Act 2018.

• To promote equality, diversity and inclusion in all areas of work and actively challenge discrimination.

• To always take care to uphold health and safety at work for self and others.  To always observe London Councils’ Health and Safety policy and related procedures.

• To uphold the highest standards of ethical conduct in line with the expectations of a local government officer and to lead staff to adhere to such standards in order to uphold the reputation of London Councils and local government in London.

• A Flexi system is worked. Evening and out-of-hours working may be required on occasions and a willingness to travel within London.

Nature of Contacts

·  Frequent contact with performance managers across London to collect data and provide feedback on quality checks.

·  Some contact with Senior & other representatives from external organisations in the public sector including the London Information Exchange Group, the London Government Association and partner organisations such as Health and the Metropolitan Police.

·  Working directly with data scientist colleagues in external agencies to exchange information on code and co-ordinate actions together for reporting.

·  Report into the LIIA Strategic Intelligence Lead on a regular basis to provide updates on agreed projects and deliverables.

·  Work in a timely manner to produce ad-hoc reporting to queries for Senior stakeholders across London such as DCS.

Person Specification

LIIA  Intelligence Analyst

Qualifications

·  Educated to degree level or equivalent (an advantage would be to have a significant statistical element to the qualification) Certificates or evidence of corporate training and/or demonstrable advanced proficiency in use of code such as R, Python or SQL.

· Certificates or evidence of corporate training and/or demonstrable advanced proficiency in use of dashboard software such as Power BI, Qlik, or Tableau.

Knowledge

·  Knowledge and experience of extracting and manipulating data using a coding language such as DAX, SQL, R and/or Python

·  Thorough understanding of core concepts of how data is organised and managed in complex business environments, including relational databases and data modelling

·   Thorough understanding of the requirements of GDPR and Data Protection Act 2018 and ability to design and implement approaches to ensure compliance. 

Skills & Abilities

·  Highly numerate, with excellent analytical and problem-solving skills

·  Advanced statistical and analytical skills, including (for example): Use of spreadsheets, databases, coding, statistical analysis packages to analyse and manipulate large and complex datasets (e.g. Excel, Power Query, Power BI, Python, SQL or others such as Business Objects, SSRS)

·  Advanced user of Office productivity software, such as Excel, Outlook, Word, PowerPoint, Teams and other Office 365 (or equivalent) apps

·  Adaptable to be able to complete bespoke or Ad-hoc data requests from stakeholders.  Ability to research possible data sources to produce accurate information quickly with minimal supervision.

·  Accustomed to managing conflicting deadlines and a demanding workload

·  Ability to see the bigger picture as well as attend to detail

Experience

· Experience of developing and reporting on performance measures and indicators, and designing and implementing performance management frameworks

·  Ability to design and produce clear and compelling data visualisations in reports, dashboards

·  Experience of providing complex information and advice to key decision makers, to a similar level to Project leads and Directors of Social Care.

·  Ability to communicate effectively using a wide variety of media and methodologies, including written, oral and visual means of communication

·  Self-motivated, enthusiastic, and able to work with minimal supervision

Personal Characteristics

·  Creative and innovative 

·  Demonstrable commitment to equal opportunities and equality in employment and service delivery

·  Well-developed interpersonal, persuasion and negotiating skills