Summary
Conducts end-to-end analytics engineering, defining data requirements and ensuring data integrity. Applies advanced analytical and statistical techniques to extract meaningful insights and develop predictive models. Communicates complex findings to stakeholders in an understandable manner. Contributes to the development of analytics engineering processes and standards. Identifies opportunities for improving analytics engineering practices.
Work Activity Components
| Title | Details |
|---|---|
| Data analysis (Level Four) (DAAN) | Conducts end-to-end data analysis, defining data requirements and ensuring data integrity. |
| Data preparation (Level Four) (DAAN) | Cleans raw data by identifying and resolving duplicates, errors, extreme values, and other anomalies. |
| Process, methods and standards (Level 4)(BINT) | Develops and applies processes to support the analysis needs of the organisation. Defines standard and non-standard techniques and tools to deliver data analysis such as OLAP reporting, data mining, predictive analysis and data storytelling. |
Technical Skills
| Title | Details | Depth |
|---|---|---|
| Big Data | The discipline associated with data sets so large and/or complex that traditional data processing applications are inadequate. The data files may include structured, unstructured and/or semi-structured data, such as unstructured text, audio, video, etc. Challenges include analysis, capture, curation, search, sharing, storage, transfer, manipulation, analysis, visualization and information privacy. | 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). | Familiar with |
Other Skills
| Title | Details | Depth |
|---|---|---|
| Standards Writing Techniques | Principles, methods and techniques for establishing, documenting, and maintaining standards. | Aware of |
Training
| Title | Details |
|---|---|
| AI and Machine Learning | AI and machine learning methods, tools and techniques that enable computers to model behaviours based on empirical data in order to solve business problems and/or provide greater business insight. |
| Coaching | Concepts, methods and techniques for providing coaching in subject specialisms to individuals or groups (e.g. GROW model). |
| Security Awareness | Tools and techniques to help users and employees understand the role they play in helping to combat information security breaches and for IT and security professionals to prevent and mitigate risk. |
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 |
| 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 |
| 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 |
| Negotiating and Influencing | Undertaking learning and practice of negotiating with and influencing others. | Developing Professional Skills |
| 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 |
| Research Assignments | Exploring a topic which is not part of own normal responsibilities and presenting findings to colleagues and/or management | Increasing Knowledge |
Qualification Components
| Title | Awarding Bodies |
|---|---|
| BCS Foundation Certificate in the Ethical Build of AI | BCS The Chartered Institute for IT |
| FEDIP Senior Practitioner | The Federation for Informatics Professionals |
Additional Frameworks
National Competency Framework for Data Professionals in Health and Care
Behaviours
| Title | Details |
|---|---|
| Delivering outcomes (B1.1) (Level Three) | You initiate work with others in your team and beyond in order to bring about a generally agreed outcome. |
| Communicating within a hierarchy (B1.2) (Level Three) | You are able to communicate to those in authority when their requests are in conflict with each other. |
| Generating consensus (B1.3) (Level Three) | You are generally able to quickly gather a consensus of opinion to support your ideas. |
| Logical arguments (B1.4) (Level Three) | You are able to construct a clearly predicated argument with logically consistent conclusions. |
| Negotiation (B1.5) (Level Three) | You are able to negotiate exchanges over multiple poles of interest in order to achieve a specific result. |
| Generating support (B1.6) (Level Three) | You are always able to gather help with minimal effort when faced with a tricky problem. |
| Influence (B1.7) (Level Three) | You are able to apply influence even when faced with being influenced by a number of peers. |
| Equality (B2.1) (Level Three) | You make extra efforts to ensure that, where the voices of certain groups are not being heard, you take the time to hear them. |
| Challenging discrimination (B2.2) (Level Three) | You articulate, when prompted, the fact that discrimination of any kind will not be tolerated by your organisation and signpost issues to senior management for immediate resolution. |
| NHS Constitution (B2.3) (Level Three) | You have a detailed understanding of following the behaviours and values listed in the NHS Constitution. |
| Supporting others (B2.4) (Level Three) | You are supportive of others and take time to ensure they are okay. Whilst ensuring everyone has someone to talk to, you ensure that you are able to talk to someone when you need to as well. |
| Open environment (B2.5) (Level Three) | You help to model an open environment by facilitating sessions for underrepresented and marginalised individuals to share their lived experiences with you and your colleagues, asking questions and escalating concerns to your line manager. |
| Written communication (B3.1) (Level Three) | You are able to convey complex written ideas, citing a variety of sources, in a clear and concise manner. |
| Discussing complex ideas (B3.2) (Level Three) | You are able to discuss complex ideas in a clear and accessible manner to a non-technical audience. |
| Delivering complex ideas (B3.3) (Level Three) | You deliver complex ideas and insights to a diverse range of audiences. |
| Understanding new ideas (B3.4) (Level Three) | You are able to understand new and complex ideas from multiple sources in order to convey the information concisely. |
| Reading audiences (B3.5) (Level Three) | You are able to assess how comfortable someone is in understanding your information and naturally cover the information they are unclear on in a new and accessible manner. |
| Problem sharing (B4.1) (Level Three) | You regularly work on problems with others outside of your immediate work area while respecting pre-agreed boundaries. |
| Seeking opinions (B4.2) (Level Three) | You seek out the opinions of a number of others to create a rich solution to a problem. |
| Sharing best practice (B4.3) (Level Three) | You collate and offer best practice in your area and openly share your findings. |
| Embedding best practice (B4.4) (Level Three) | You seek out exemplars of "what good looks like" and embed them within your area. |
| Patient impact (B5.1) (Level Three) | You seek out ways of making your actions better for patients. |
| Understanding the customer (B5.2) (Level Three) | You take time to consult with the client, offering a range of solutions. |
| Customer service (B5.3) (Level Three) | You spend time on complex problems to understand the customer's perspective and solutions that would add value. |
| Customer solutions (B5.4) (Level Three) | You seek out new and innovative solutions to proactively inform customers of efficiencies in your provision. |
Leadership
| Title | Details |
|---|---|
| Empathy and understanding (Level Three) | You are always available to your team and consistently act with care, empathy and compassion. |
| Pressure (Level Three) | You are able to explain to those around you why organisational and political pressures make it seem like senior managers are pulling in a different direction sometimes. |
| EDI (Level Three) | You actively engage in your organisation's EDI networks and take care to appreciate the lived experiences of those people different to you. |
| Team support (Level Three) | You back your team consistently when questioned in public. |
| Positivity (Level Three) | You are able to act effectively and fairly when under pressure whilst being aware of the dangers of favouritism on morale. |
| Innovation (Level Three) | You seek out innovations that will support your team's work. |
| Safe to fail (Level Three) | You will promote your team's successes publicly and examine failures privately, taking responsibiity for those failures in public. |
| Fairness (Level Three) | You understand the preferences and strengths of individuals within your team and can utilise them effectively whilst developing their skills in other areas. |
| Opportunities (Level Three) | You empower the team to follow through on new ideas or processes, providing a safe environment in which to try new things. |
| Goals (Level Three) | You set clear goals and articulate achievable expectations. |
| Performance (Level Three) | You offer support to your team to exceed expectations. |
| Motivation (Level Three) | You consistently celebrate success but also promote learning through failure in safe environments. |
| Expectations (Level Three) | You are able to articulate disappointment when the efforts of others fall below expectations. |
| 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 Three) | You are able to manage your expenditure and ensure you have no quarterly or annual overspend. |
| Budget control (Level Three) | You are able to plan and manage your budgets ensuring that you have the enough money allocated to the correct area. |
| Forecasting (Level Three) | You are able to produce accurate forecasts based on current expenditure and foreseen developments within your team. |
| Business cases (Level Three) | You are able to highlight the need for a business case in new areas or work and identify options for appraisal. |
| Recruitment (Level Three) | You take time to build your recruitment processes around professional standards whilst ensuring that the process remains open and transparent for all. |
| Supporting ambition (Level Three) | You understand the backgrounds and motivations for all members of your team and ensure that all efforts are made to support their ambitions whilst aligning them to the needs of the organisation. |
| Training opportunities (Level Three) | You provide ample opportunity for training for all members of your team whether that is from internal colleagues, external organisations or specialist providers. |
| Professional development (Level Three) | You ensure that all staff are able to focus a portion of their work time on CPD and ensure that their Personal Development Plans are regularly reviewed, updated and constantly worked on. |
| Managing external pressures (Level Three) | 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 |
|---|---|
| Non-technical audiences (Analytics Engineering) (AEC1.1) (Level Three) | You communicate effectively with technical staff, and influence and educate non-technical stakeholders . |
| Stakeholder management (Analytics Engineering) (AEC1.2)(Level Three) | You support and host discussions within a multidisciplinary team sometimes with potentially difficult dynamics. |
| Positive communication (AEC1.3) (Level Three) | You advocate for the team externally and can positively handle conflicting perspectives. You ensure good news stories are celebrated. |
| Facilitation (Analytics Engineering) (AEC1.4) (Level Three) | You support or host difficult discussions within the team. |
| Data interpretation (Analytics Engineering) (AEC2.1) (Level Three) | You can present clear insights to colleagues to support the end use of the data. |
| Data profiling (Analytics Engineering) (AEC2.2)(Level Three) | You can undertake data profiling and source system analysis. |
| Data innovation (AEC2.3)(Level Three) | You can understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage. |
| Data modelling (Analytics Engineering) (AEC3.1) (Level Three) | You can build and review complex data models, ensuring adherence to standards. You work with other data professionals to improve modelling, integration patterns and standards. |
| Tools (AEC3.2)(Level Three) | You use data integration tools and languages to integrate and store data, and advise teams on best practice. |
| Reverse engineering (Analytics Engineering) (AEC3.3) | You reverse engineer more complex data models and mentor less experienced staff. |
| Data iteration, review and maintenance (Analytics Engineering) (AEC3.5) (Level Three) | You ensure data for analysis meets data quality standards and is interoperable with other data sets, enabling reuse. |
| Problem identification (AEC4.1) (Level Three) | You can initiate actions, monitor services and identify trends in problems in your domain and redirect concerns outside your area to appropriate colleagues. |
| Problem resolution (AEC4.2) (Level Three) | You can respond to problems in databases, data processes, data products and services as they occur. |
| Problem prevention (AEC4.3) (Level Three) | You can determine the likelihood of common problems occurring and establish preventive measures and guidance. |
| Capacity building (AEC4.4)(Level Three) | You implement development activities around problem solving and provide coaching on this topic. |
| Repository tools and management (AEC5.1) (Level Three) | You understand a range of tools for storing and working with metadata. You can suggest changes to improve current metadata repositories and use them to complete complex tasks such as data and systems integration impact analysis. |
| Metadata best practice (Analytics Engineering) (AEC5.2)(Level Three) | You lead on implementing metadata best practise within the team and advise others where necessary. |
| Repository design (AEC5.3)(Level Three) | You can design an appropriate metadata repository liaising across technical, analytical and governance teams to do so. |
| Programming (AEC6.1) (Level Three) | You use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations. You advise on the application of standards and practices across the team and ensure compliance. |
| Performance analysis (Analytics Engineering) (AEC6.2) (Level Three) | You can manage issues and risks associated with work liaising with other technical colleagues to solve issues. |
| Data architecture (AEC7.1) (Level Three) | You can contribute to the design of data architecture that deals with problems spanning different business areas in collaboration with data architects. |
| Patterns (AEC7.2)(Level Three) | You can produce appropriate patterns for use cases in your domain. |
| Strategic alignment (Analytics Engineering) (AEC7.3) | You work across multiple subject areas or a single large or complicated subject area implementing relevant data practices. |
| Data Visualisation (Level Two) | You can import data into underlying data models. You understand the relational structure of the data and use the most appropriate visualisation method. |
| Statistical Process Control (Level Two) | You understand the statistics and assumptions behind XmR charts, including when they are not the best method to use. You know the other types of SPC charts for different data types. |
| Descriptive and Explicative Analytics (Level Two) | You understand variablilty and how it affects the data being analysed. You understand how descriptive statistics such as prevalence and incidence are interdependent. You are able to describe data in an unambiguous fashion. |
| Predictive and Prescriptive Analytics (Level Two) | You are able to use key techniques in predictive analytics including regression methods and use them with different data types. You can select the appropriate technique for the subject. |
| Evaluative Analytics (Level Two) | You understand the iterative nature of evaluative techniques. You can identify when there is a cause and effect relationship and take into account the related time lag within any evaluative analysis. |
| Advanced Statistics (Level Two) | You understand key regression models, cluster analysis, factor analysis, principal component analysis etc. You apply the currect techniques to the business questions. You understand the limits and assumptions behind each technique. |
| Longitudinal Analysis (Level Two) | You can identify when longitudinal analysis is suitable and know the key techniques for analysis. You understand repeated measures designs and the limitations of standard statistical techniques. |
Project Skills
| Title | Details |
|---|---|
| Business cases (WP1.1) (Level Three) | You assess business requirements with stakeholders and draft business cases for your area of expertise, highlighting benefits, risks and costs and ensuring issues such as sustainability are addressed where appropriate. |
| Scope (WP1.2) (Level Three) | You adopt rigorous scope, quality and change management practices and ensure they are adhered to throughout the team. |
| Reviews (WP1.3) (Level Three) | You contribute to project reviews, documenting and communicating where lessons are learned. |
| Advice and monitoring (WP2.1)(Level Three) | You advise on and monitor budgets for time, resources and other costs for data and digital project activities enforcing budget controls. |
| Scheduling (Level Two) | You schedule project work appropriately for yourself and the team, ensuring business needs are met both within the project and in business as usual. |
| 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 (WP3.1)(Level Three) | You identify and budget for the resources required to fulfil the project plan's requirements. |
| 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 (WP4.1)(Level Three) | You manage the allocation and co-ordination of project-related activities, collaborating with project managers to establish and embed key risk management and issue resolution processes. |
| Pilots and testing (WP4.2)(Level Three) | You lead on the scoping of testing and pilots, reporting key findings and re-assessing the expected benefits. |
| Implementation (WP4.3)(Level Three) | You engage with project beneficiaries to co-ordinate effective roll-out. |
| Business change (WP5.1)(Level Three) | You understand the business case for change and how data and digital can facilitate that, collaborating with project managers to define an achievable technological outcome which fosters new ways of working. |
| Assurance (WP5.2)(Level Three) | You positively influence stakeholders, building networks and alliances and lead the focus within data and digital on customer satisfaction. |
| 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.