Senior Analyst

5 Star Recruitment; East Midlands; On-site; GBP 40,000 - 55,000; Full time

Job summary

5 Star Recruitment is seeking a data and insight professional to design and build high-quality BI reports using Power BI, SQL and Business Objects for a range of stakeholders within local government services.

You will coordinate statutory returns, cleanse and validate data, and support decision-making with analytics and performance trends, while liaising with ICT and external partners to ensure compliance and up-to-date systems.

Qualifications

• Degree or equivalent experience.
• Evidence of relevant continued professional development.
• Significant experience in using systems to support local government services.
• Experience coordinating, compiling and analysing statutory or performance returns.
• Experience of using numerical information to analyse performance and trends.
• Experience of working with information systems and databases.
• Experience of writing database queries and reports using business intelligence tools.
• Ability to develop and coach junior staff and/or users through training, coaching or supervision of work.
• Ability to deliver presentations or training clearly and confidently.
• Ability to communicate with people at all levels.
• Good written communication skills and ability to write summarise numeric information in a clear way.
• Able to use Microsoft Office software.
• Advanced skills in the design and build of business intelligence reports and databases.
• Able to interpret statistical data using a range of different appropriate methodologies to identify trends, forecasts and support service development.
• Advanced skills in the use of spreadsheets and ability to develop appropriate management reports.
• Ability to present information in tabular or graphical format.

Responsibilities

• Design and build high quality data and intelligence reports and produce analysis to meet the needs of the service using relevant business intelligence tools (e.g. Power BI, Business Objects, SQL) for a variety of audiences including Service Directors, Heads of Service, Boards, members and external partners as required.
• Coordinate and lead the processing of statutory returns to Government, including data cleansing, analysis, validation and sign off procedures on behalf of the Council and Derby Homes in accordance with relevant requirements and deadlines.
• Maintain a good understanding of service context, structures and business processes to inform the development of enhanced reporting which meet the needs of users.
• Liaise with ICT, software suppliers and services to ensure that upgrades and software issues are resolved to a satisfactory standard and statutory requirements are met.
• Attend external meetings/workshops/user groups with software providers, other authorities and partner organisations and/or government departments to keep up to date with latest developments and ensure that systems and processes are improved for end users.
• Provide system administration, support, training and guidance in using business applications as appropriate.
• Design and build ad hoc reports for service users, responding promptly to urgent requests which may be needed for inspection, strategy or commissioning purposes.
• Create statistical analysis and interpretation of data and intelligence for managers identifying trends, forecasting and projections to inform decision making.
• Devise innovative business intelligence solutions and that meet user needs and contribute towards the development of the service offer.
• Provide accurate and timely datasets to support Inspection and Audit regimes.
• Monitor the data quality of systems to ensure that the information included in reports and statutory returns is correct. This involves the creation of exception reports and liaising with the service area to ensure that data quality guidelines are followed and inaccuracies are corrected.
• Respond to Freedom of Information requests as required.
• Support the raising of awareness of information governance and data quality standards and responsibilities, for example the Data Protection Act.
• Provide training and advice for internal and external partners to enable accurate and effective data returns which meet statutory requirements and local data quality standards, using different approaches to train different audiences such as members of internal or external teams.
• Undertake benchmarking with other authorities and sectors to inform performance analysis.
• Work closely with senior managers and the Policy and Insight Team to develop, compile and monitor key performance measures within the corporate performance reporting system to evaluate impact and to assess implications for service improvement and delivery.
• Support service improvement processes, including business planning and performance surgeries as well as contribute to the development and implementation of Performance Management frameworks.
• Deputise for the Insight Manager as required.
• Provide coaching, training and supervision for Analysts, Data Support Officers and temporary employees as required.
• Respond promptly to enquiries and information requests from service users.
• Liaise as necessary with all Council directorates, other local authorities, partners and external organisations.
• Carry out any other duties within the overall function, commensurate with the grade and level of responsibility of the post.

Skills

Interpersonal skills

Communication

Numeracy

Literacy

Coaching staff

Education

Degree or equivalent experience

Tools

Power BI

Business Objects

SQL

Microsoft Office

Job description

To apply innovative approaches to data capture, data analysis and intelligence development, using sophisticated information systems and analytical software to meet local needs and statutory requirements.

MAIN DUTIES AND RESPONSIBILITIES

• Design and build high quality data and intelligence reports and produce analysis to meet the needs of the service using relevant business intelligence tools (e.g. Power BI, Business Objects, SQL) for a variety of audiences including Service Directors, Heads of Service, Boards, members and external partners as required.
• Coordinate and lead the processing of statutory returns to Government, including data cleansing, analysis, validation and sign off procedures on behalf of the Council and Derby Homes in accordance with relevant requirements and deadlines.
• Maintain a good understanding of service context, structures and business processes to inform the development of enhanced reporting which meet the needs of users.
• Liaise with ICT, software suppliers and services to ensure that upgrades and software issues are resolved to a satisfactory standard and statutory requirements are met.
• Attend external meetings/workshops/user groups with software providers, other authorities and partner organisations and/or government departments to keep up to date with latest developments and ensure that systems and processes are improved for end users.
• Provide system administration, support, training and guidance in using business applications as appropriate.
• Design and build ad hoc reports for service users, responding promptly to urgent requests which may be needed for inspection, strategy or commissioning purposes.
• Create statistical analysis and interpretation of data and intelligence for managers identifying trends, forecasting and projections to inform decision making.
• Devise innovative business intelligence solutions and that meet user needs and contribute towards the development of the service offer.
• Provide accurate and timely datasets to support Inspection and Audit regimes.
• Monitor the data quality of systems to ensure that the information included in reports and statutory returns is correct. This involves the creation of exception reports and liaising with the service area to ensure that data quality guidelines are followed and inaccuracies are corrected.
• Respond to Freedom of Information requests as required.
• Support the raising of awareness of information governance and data quality standards and responsibilities, for example the Data Protection Act.
• Provide training and advice for internal and external partners to enable accurate and effective data returns which meet statutory requirements and local data quality standards, using different approaches to train different audiences such as members of internal or external teams.
• Undertake benchmarking with other authorities and sectors to inform performance analysis.
• Work closely with senior managers and the Policy and Insight Team to develop, compile and monitor key performance measures within the corporate performance reporting system to evaluate impact and to assess implications for service improvement and delivery.
• Support service improvement processes, including business planning and performance surgeries as well as contribute to the development and implementation of Performance Management frameworks.
• Deputise for the Insight Manager as required.
• Provide coaching, training and supervision for Analysts, Data Support Officers and temporary employees as required.
• Respond promptly to enquiries and information requests from service users.
• Liaise as necessary with all Council directorates, other local authorities, partners and external organisations.
• Carry out any other duties within the overall function, commensurate with the grade and level of responsibility of the post.

Experience

Significant experience in the use of systems to support local government services (relevant to job role).

Experience of coordinating, compiling and analysing statutory or performance returns from the start to the end of the process.

Experience of using numerical information to analyse performance and trends.

Experience of working with information systems and databases.

Experience of writing database queries and reports using business intelligence tools.

Qualifications

Degree or equivalent experience.

Evidence of relevant continued professional development.

Skills and Knowledge

Interpersonal

Ability to develop and coach junior staff and/or users through training, coaching or supervision of work.

Communication

Ability to deliver presentations or training clearly and confidently.

Ability to communicate with people at all levels.

Good written communication skills and ability to write summarise numeric information in a clear way.

IT

Able to use Microsoft Office software.

Advanced skills in the design and build of business intelligence reports and databases.

Able to interpret statistical data using a range of different appropriate methodologies to identify trends, forecasts and support service development.

Advanced skills in the use of spreadsheets and ability to develop appropriate management reports.

Ability to present information in tabular or graphical format.

Numeracy

Confident in handling data and performance indicators.

Literacy

Ability to write clear and concise letters, reports, leaflets and other publications.