Lead Data Analyst

Summary

Supports complex data analysis needs of specific management or governance processes or operational areas. Investigates the need for data analysis and reporting where there is complexity and ambiguity. Selects and applies non-standard data analysis tools and techniques to provide insights and aid decision-making. Selects, acquires and integrates complex data for analysis. Identifies opportunities to digitise and streamline operational data handling and optimise data analysis capabilities.

Work Activity Components

Title Details
Automation and opportunities (Level 4)(VISL) Works with others to create automated scripts and processes that prepare the data ready for presentation. Works with job scheduling to ensure data preparation activities fit at the appropriate point of data acquisition and do not impact on other system resource needs e.g. backups.
Information requirements and search (Level 4)(BINT) Determines what information is required and defines search and other criteria to meet a specified requirement.
Testing (Level 4)(VISL) Plans, designs and conducts tests of data visualisation to assure it meets the needs of end users, that data is succinct and that information maps to underlying raw data through known and appropriate translation and visual representation techniques. Corrects errors and retests to achieve an error-free result.
Automation and opportunities (Level 4)(VISL) Works with others to create automated scripts and processes that prepare the data ready for presentation. Works with job scheduling to ensure data preparation activities fit at the appropriate point of data acquisition and do not impact on other system resource needs e.g. backups.

Technical Skills

Title Details Depth
Database Software Software that enables the user to capture, create, populate and manipulate data structures and where appropriate unstructured data. Proficient in
Business Environment The business environment relating to own sphere of work (own organisation and/or closely associated organisations, such as customers, suppliers, partners and competitors), in particular those aspects of the business that the specialism is to support (i.e. localised organisational awareness from a technical perspective). Proficient in
Graphic Layering The use of graphic design, shapes, colours and plotting techniques to represent data. Familiar with graphic layering and using GIS information. Proficient in
Module Management The use of version control and linked versions (module management) to record and store versions of data sets and the associated versions of algorithms that led to a data visualisation and/or outcome. e.g. tools that provide such capability. Proficient in

Other Skills

Title Details Depth
Standards Writing Techniques Principles, methods and techniques for establishing, documenting, and maintaining standards. Familiar with

Training

Title Details
Information and Data Modelling Tools and techniques used to investigate, analyse and model the structure, relationships and use of data and information within an organisation.
Data Management Data management concepts, methods, tools and techniques relating to the planning, development, implementation, administration and curation of data.
Coaching Concepts, methods and techniques for providing coaching in subject specialisms to individuals or groups (e.g. GROW model).

Professional Development Activity (PDA)

Title Details PDA Group
Deputising Standing in for supervisor or manager on a temporary basis during periods of absence. Broadening Activities
Job Shadowing and Special Assignments Undertaking temporary periods or secondments in other roles, particularly those that offer a new perspective on own function or exposure to other environments and cultures. Broadening Activities
Research Assignments Exploring a topic which is not part of own normal responsibilities and presenting findings to colleagues and/or management Increasing Knowledge
Gaining Knowledge of Activities of Employing Organisation Developing an understanding of the potentially diverse range of activities (service, governance, administrative, regulatory, commercial, charitable, industrial, etc.) undertaken by the employing organisation. Increasing Knowledge
Gaining Knowledge of IT Concepts and Techniques Undertaking study, learning and, where possible, practice in IT concepts and techniques external to own function. Increasing Knowledge
Participation in Professional Body Affairs Taking an active part in professional body affairs at branch, specialist group, committee or board level. Participation in Professional Activities
Negotiating and Influencing Undertaking learning and practice of negotiating with and influencing others. Developing Professional Skills
Team Leadership Undertaking learning and practice of the skills required to lead teams, including motivation, direction, coaching, delegation, appraisal, counselling and developing others. Developing Professional Skills

Qualification Components

Title Awarding Bodies
FEDIP Advanced Practitioner The Federation for Informatics Professionals
BCS Professional Certificate in Data Analysis BCS The Chartered Institute for IT
Certified Business Intelligence Professional (CBIP) TDWI Transforming Data with Intelligence
CBDA Certification in Business Data Analytics IIBA International Institute of Business Analysis

Government Digital and Data Profession Capability Framework Skills

Skill Level

Logical and creative thinking

Practitioner Logical and creative thinking

You can: ensure that the most appropriate actions are taken to resolve problems as they occur co-ordinate teams to resolve problems and implement solutions and preventative measures

Additional Frameworks

National Competency Framework for Data Professionals in Health and Care

Behaviours

Title Details
Delivering outcomes (B1.1) (Level Four) You are able to gather the skills of a diverse multi-disciplinary team in order to achieve an agreed outcome.
Communicating within a hierarchy (B1.2) (Level Four) You are able to challenge the use of hierarchical arguments where logic supports a different course of action and call out the use of emotional or coercive influence.
Generating consensus (B1.3) (Level Four) You are consistently able to gather a consensus of opinion to support your arguments and often know what people will support prior to discussion.
Logical arguments (B1.4) (Level Four) You are able to construct a clearly predicated argument with logically consistent conclusions whilst providing robust refutations of counterarguments.
Negotiation (B1.5) (Level Four) You are able to negotiate exchanges over multiple poles of interest in order to achieve a specific result even when those involved have hidden agendas, while allowing everyone to share multiple viewpoints.
Generating support (B1.6) (Level Four) Your team and colleagues will often go above and beyond to support your initiatives.
Influence (B1.7) (Level Four) Your opinion is often sought early by peers dealing with politically sensitive issues.
Equality (B2.1) (Level Four) You make extra efforts to ensure that, where the voices of certain groups are not being heard, you take the time to give them a voice.
Challenging discrimination (B2.2) (Level Four) You are able to engage with sensitive ED&I issues and deal with them with the utmost dignity, respect and fairness.  
NHS Constitution (B2.3) (Level Four) You promote the behaviours and values listed in the NHS Constitution.
Supporting others (B2.4) (Level Four) You view the wellbeing of you and those around you with high priority.  You take every step to ensure that people within your domain know that it's okay not to be okay.
Open environment (B2.5) (Level Four) You are an ally for underrepresented and marginalised groups and model an open environment by facilitating sessions for these individuals to share their lived experiences with you and your colleagues.
Challenging disrespect (B2.6) (Level Four) You support staff to understand the impact of disrespectful behaviour and support them in challenging it.
Written communication (B3.1) (Level Four) You are able to produce original written material that is accessible, referenced and publishable, including the production of literature reviews.
Discussing complex ideas (B3.2) (Level Four) You are able to engage in complex technical debates with other specialists whilst using accessible and accurate language.
Delivering complex ideas (B3.3) (Level Four) Your confidence in your expertise enables others to feel confident and at ease with your contribution.
Understanding new ideas (B3.4) (Level Four) You are able to design all insight into complex information in a way that is both accurate and concise.
Reading audiences (B3.5) (Level Four) You are able to read large audiences to assess how well they have understood a series of multi-disciplinary concepts.
Problem sharing (B4.1) (Level Four) You look to provide multi-disciplinary solutions for maximum adoption throughout the organisation, while respecting pre-agreed boundaries.
Seeking opinions (B4.2) (Level Four) You regularly create multi-disciplinary teams to address complex problems.
Sharing best practice (B4.3) (Level Four) You create an environment where the sharing of best practice is viewed as a central part of every review process.
Embedding best practice (B4.4) (Level Four) You ensure that all processes within your area are based on models of "what good looks like".
Patient impact (B5.1) (Level Four) You ensure work within your area is as efficient as possible and enables better health and care outcomes.
Understanding the customer (B5.2) (Level Four) You seek out opportunities to work collaboratively with customers to pre-empt requests.
Customer service (B5.3) (Level Four) You understand changes within health and care with a view offering solutions to foreseen requirements.
Customer solutions (B5.4) (Level Four) You apply new solutions to customer requirements in order to ensure maximum accuracy and efficiency.

Leadership

Title Details
Empathy and understanding (Level Four) You act with care, empathy and understanding and ensure that your team knows you are always available to them.
Pressure (Level Four) You are aware of the pressures faced by your senior managers, as well as those in your team, and are able to work collaboratively to ease them.
EDI (Level Four) You actively engage in your organisation's EDI networks to better understand and appreciate the lived experiences of people different to you and how you can create a working environment supportive to all.
Compassion (Level Four) You ensure that, whilst being a workplace, emotional issues are dealt with care and sensitivity.
Team support (Level Four) Your team feels supported and empowered to exceed their goals.
Positivity (Level Four) You set clear goals and expectations that are visible to your team and others in affiliated areas.
Innovation (Level Four) You build the importance of trying new things and failing in a controlled environment into your ways of working whilst always celebrating success.
Safe to fail (Level Four) You facilitate networking opportunities for your team, including those with external organisations.
Fairness (Level Four) You are regarded as fair by your team who consistently give you the best of their abilities.
Opportunities (Level Four) You identify opportunities for your team to learn from failure including fast fails and sandbox environments.
Goals (Level Four) You set challenging goals whilst empowering the team to explore a number of different solutions whilst keeping yourself available to support them.
Performance (Level Four) You regard sub standard work as a reflection of your ability as you had the opportunity to prevent it.
Motivation (Level Four) You use your knowledge of the motivations of your team to plan succession and support them in their ambitions beyond your team.
Expectations (Level Four) You are able to express the ramifications of below standard work in an honest and unemotional way.
Developing talent (Level Four) You take pride in the talent of your team and go to great lengths to develop their skills and innovations.
Succession planning (Level Three) You are able to readily identify those in your team who have the opportunity to excel at their level and beyond and use this knowledge to begin succession planning.
Managing expenditure (Level Four) You are able to agree and control expenditure required for the effective running of your team.
Budget control (Level Four) You agree and control budget allocations, highlighting anomalies in expenditure and make suggestions for the reallocations of funding.
Forecasting (Level Four) You are able to produce accurate forecasts based on current expenditure and foreseen developments within your division.
Business cases (Level Four) You deliver accurate and insightful business cases with appropriate and balanced options appraisals.
Headcount (Level Four) You are able to articulate the ramification of headcount on service provision to negotiate for alternative staffing levels.
Recruitment (Level Four) You support your team to recruit effectively whilst ensuring that fairness towards equality and diversity remains a priority throughout the process.
Supporting ambition (Level Four) You take the time to talk to all staff members within your remit and encourage your managers to support their ambitions, providing solutions where these diverge from perceived organisational drivers.
Training opportunities (Level Four) You ensure that your managers enable training on a regular basis within their unit and have ample access to training for their own development. You ensure that everyone understands delegation is a development opportunity that requires time and should not be seen as a shortcut to alleviating workloads.
Professional development (Level Four) You take an active interest in all staff members' PDPs within your area and ensure that development opportunities are seized upon.
Managing external pressures (Level Four) You ensure that time is set aside for the team to focus on each aspect of their role, wherever possible, free from distraction and interruption, protecting them, where possible, from the pressures of other managers outside the department, ensuring their well-being is protected from external pressures.

Data Skills

Title Details
Data transformation (Data Analysis) (DAC1.1) (Level Four) You can apply innovative approaches to resolve business and team issues.
Data interpretation (DAC1.2) (Level Four) You guide colleagues to create and interpret strategic insights. 
Context (DAC1.3) (Level Four) You oversee the development and maintenance of performance measurement frameworks.
Performance measures (DAC1.4) (Level Four) You ensure these frameworks are continuously aligned to business needs and strategy.
Insight (Level Four) You look beyond initial requirements, challenge assumptions and communicate insight. 
Difficult Messages (Level Four) You confidently communicate difficult messages based on the data.
Data lifecycle (DAC2.1) (Level Four) You appraise the accuracy and quality of a range of data ensuring that data is fit for the intended analysis and that the analytical products are suitable for their audience. 
Data quality (Data Analysis) (DAC2.2) (Level Four) You anticipate and remove blockages to the processing of data and influence senior stakeholders to facilitate the creation and flow of appropriate data. 
Data cleansing (DAC2.3) (Level Four) You can explain data patterns and their implications on interpretation and promote data-driven decision-making. 
Analysis standards (DAC2.4) (Level Four) You proactively promote approaches to ensure data variability and standardisation are routinely used in analysis and explore how further metrics and statistics could enhance comprehension of the data. 
Data models (DAC2.5) (Level Four) You advise and support your team on the most appropriate analytical techniques to use and create models that support the business strategy, supporting your team to do so. 
Data security (DAC 2.6) (Level Four) You oversee the development of systems to provide continuous availability of business-critical data. 
Alignment (DAC2.7) (Level Four) You ensure analysis is aligned to business needs and exploit technologies to automate repetitive outputs. 
Data risk (DAc2.8) (Level Four) You identify and mitigate risks to the data flows and processing capacity and implement improvements. 
Data governance (Data Analyst) (DAC 2.9) (Level Four) You anticipate and plan for changes to any business or technical constraints. 
Data Protection (Level Four) You have good knowledge of data security and of applying data protection principles and legislation.
Analytical techniques (Level Four) You develop advanced knowledge of predictive, prescriptive and evaluative analytical technique You have advanced expertise across a range of techniques or you may have a recognised deep expertise in a narrower range of specialisms.
Analytical tools DAC 3.2 (Level Four) You develop advanced expertise in relevant tools, applications and systems and share your knowledge with others. 
Statistical practices DAC 3.3 (Level Four) You apply a range of statistical practices, can advise on best practice and guide others to a high standard. 
Solving business issues DAC 3.4 (Level Four) You can determine which tools and techniques to use to explore or solve a variety of business issues. 
Tool adoption DAC 3.5 (Level Four) You develop systems and processes to improve the use of tools and techniques employed in your organisation.
Knowledge sharing DAC 3.6 (Level Four) You share your knowledge with the wider analytic community to help others develop analytical skills.
Emerging tools DAC 3.7 (Level Four) You actively seek out emerging tools and techniques and find ways to apply them. 
Analytics community DAC 3.8 (Level Four) You engage with the wider analytical community to share learning.
Problem analysis DAC 4.1 (Level Four) You are able to solve complex analytical problems which require data or information from multiple sources.
Underlying questions DAC 4.2 (Level Four) You can design and test new techniques which can be replicated in other areas of analytics.
Preferred approach DAC 4.3 (Level Two) You are able to employ a number of problem solving techniques (e.g. root cause analysis) to identify the reason for unexpected problems with routines, and utilise a range of skills to solve these.
Appropriate media DAC5.1 (Level Four) You can communicate relevant, compelling stories using the most appropriate medium. 
Shaping communication DAC5.2 (Level Four) You know how to give complex recommendations at a tactical and strategic level.
Analysis presentation DAC5.3 (Level Four) You can present analysis and visualisations in clear ways to communicate complex messages. 
Delivering messages DAC5.4 (Level Four) You know how to communicate negative and positive information to stakeholders and can manage their expectations.
Influence (B1.7) (Level Four) Your opinion is often sought early by peers dealing with politically sensitive issues.
Professional development (Data Analyst) DAC6.1 (Level Four) You are adaptable and develop new or improved ways of working to support your team, directorate and wider analytical community.
Development opportunities (Data Analyst) DAC6.2 (Level Four) You identify development opportunities for yourself and those around you, adopting innovations and practices learned from the wider analytics community.
Professional values DAC6.3 (Level Four) You can focus on these initiatives to support the enhancement of patient care as an ultimate goal and this will be recognised beyond your organisation.
Professional standards DAC6.4 (Level Four) As a respected specialist, you act as an advocate for professional standards and values within your field of expertise.
Professional networking (Data Analysis) DAC6.5 (Level Three) You are active in the wider analytical community, sharing your work and actively engaging in a network of your peers. 
Advocacy DAC6.6 (Level Three) You act as an advocate for professional values and standards and promote well-being amongst your colleagues.
Data Visualisation (Level Three) You can use underlying coding such as mCODE, DAX etc to create the most efficient datasets to visualise. You can tell a story using data.
Statistical Process Control (Level Three) You understand the different types of SPC charts and when each should be used. You have knowledge of process redesign and its dependence on removing special cause variation.
Descriptive and Explicative Analytics (Level Three) You produce indicators and metrics that clearly measure what is required. You understand and apply reliability and validity assessments. You select the most appropriate methods of visualisation.
Predictive and Prescriptive Analytics (Level Three) You understand the difference between predictive and prescriptive analysis, and have knowledge of tools and techniques for prescriptive analysis including business modelling and algorithms. You are aware of the link to machine learning.
Evaluative Analytics (Level Three) You understand the role of proxy measures for less straightforward outcomes. You can assess these measures and quantify their uncertainty. You can evaluate previous research to determine appropriate measures.
Advanced Statistics (Level Three) You know all standard advanced statistical techniques and keep up to date with new developments e.g. time series modelling using ETS, ARMA, ARIMA, BATS, TBATS etc. You understand the context for these developments and their limitations.
Longitudinal Analysis (Level Three) You understand pragmatic differentiation between independent measures and repeated measures design. You understand how changing populations can affect analysis and choice of techniques used. You understand data attrition.

Project Skills

Title Details
Business cases (Level Four) You instigate business case development and work with project management colleagues to define project requirements, scope and overall time, quality and cost constraints.
Scope (Level Four) You define and engage stakeholders.
Reviews (Level Four) You advise on the coherence of programmes in data and digital to maximise the effectiveness of time and available skills within the business.
Quality assurance - Data and digital (Level Four) You lead quality assurance in data and digital, drawing on external expertise where necessary, learning lessons and sharing those with the wider data and digital community for their project work.
Advice and monitoring (Level Four) You monitor and manage the capacity of data and digital teams to meet current project plans, escalating any issues with skills, timeframes and other resources impacting upon project plans with colleagues in project management.
Complexity (Level Two) You understand and can articulate when the complexity of a proposed project requires further professional management or support.
Scheduling (WP2.3)(Level Three) You sequence the activities in data and digital projects logically, effectively and efficiently, incorporating any lessons learned from similar past projects.
Refinement (Level Two) You refine the plan within your work area to take account of any authorised changes communicating actions, progress and results with project managers.
Resource identification (Level Four) You ensure resources for projects are in place and optimised across any programmes, communicating their business value to non-data and digital colleagues and stakeholders.
Skill acquisition and management (WP3.2)(Level Three) You plan for the recruitment of staff with additional required skill sets, liaising with HR and/or other providers to source skilled staff to fulfil project roles, onboard and manage them and their workloads.
Additional tools and resources (Level Three) You cost and acquire, deploy and contract for the support of additional tools and resources such as hardware, software, training and data sources for the course of the project life cycle.
Resource allocation (Level Two) You plan the allocation of existing resources to project work whilst effectively maintaining business as usual wherever feasible.
Project management (Level Four) You ensure the team's project delivery activities have sufficient resources to co-exist with business as usual.
Pilots and testing (Level Four) You manage the risks and issues affecting data and digital roles in the project or programme.
Implementation (Level Four) You engage with project managers and stakeholders to map out all necessary resources and activities for effective and sustained implementation
Communications (Level Two) You communicate effectively with others, adapting your style and approach as and when required.
Business change (Level Four) You promote how data and digital can champion business change and identify further technological opportunities to bring about business benefits.
Assurance (Level Four) You provide assurance that the business benefits identified for a project can be realised, refining options for delivery and managing change control processes.
Evaluation (WP5.3) (Level Three) You ensure appropriate solutions are evaluated and viable alternatives are considered to deliver the intended business benefits.

The Professional Body Responsible for this job family is AphA. This job role profile was created in collaboration with BCS, using Role Model Plus.

Give Feedback

The Occupational Architecture Project is interactive and dynamic


If you would like to provide feedback on this job role, or the job families, please click the button below.

Give Feedback