You work across multiple subject areas or a single large or complicated subject area setting policy relevant to good data practices.
NCF Category: Analytics Engineering
Patterns (AEC7.2) (Level Four)
You implement policy on the appropriate patterns across the enterprise or system.
Data architecture (AEC7.1) (Level Four)
You collaborate with data architects in their work to ensure all business areas are included.
Programming (AEC6.1) (Level Four)
You set policy on standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from authorized specifications and subsequent iterations. You seek out and apply best practice across all development methods and ensure compliance.
Repository design (AEC5.3) (Level Four)
You can design an optimal metadata repository liaising across technical, analytical and governance teams to do so.
Metadata best practice (Analytics Engineering) (AEC5.2) (Level Four)
You set policy around metadata management liaising across technical, analytical and governance teams to do so.
Repository tools and management (AEC5.1) (Level Four)
You set up robust governance processes to keep repositories up to date liaising across technical, analytical and governance teams to do so.
Capacity building (AEC4.4) (Level Four)
You establish a framework ensuring problem solving capacity is embedded in the professional development of the team.
Problem prevention (AEC4.3) (Level Four)
You co-ordinate workstreams across teams in your domain to implement appropriate preventive measures such as testing frameworks and write policy to support a preventive approach.
Problem resolution (AEC4.2) (Level Four)
You can ensure that the most appropriate actions are taken to resolve problems as they occur.
Problem identification (AEC4.1) (Level Four)
You delegate the identification and description of problems affecting data systems in your domain, signposting where necessary to the correct resources and people to achieve resolution and ensure strategic leads are kept informed.
Data iteration, review and maintenance (Analytics Engineering) (AEC3.5) (Level Four)
You ensure data is modelled appropriately, and modelling standards exist and are complied with.
Data engineering (AEC3.4) (Level Four)
You build and test scalable data pipelines from multiple data sources enabling monitoring and reporting for data governance and ensuring an efficient data analytics workload throughout the systems.
Reverse engineering (Analytics Engineering) (AEC3.3) (Level Four)
You set the operational framework for reverse engineering activities .
Tools (AEC3.2) (Level Four)
You understand a number of data integration tools and patterns and ensure your teams have the support and training needed to use the most appropriate methods.
Data transformation (Level Four)
You can bring multiple data sources together in a conformed model for analysis.
Data requirements (AEC2.4) (Level Four)
You can source system analysis from a complex single source.
Data innovation (AEC2.3) (Level Four)
You can identify areas of innovation in data tools and techniques, and recognise appropriate timing for adoption.
Data profiling (Analytics Engineering) (AEC2.2)(Level Four)
You can understand and help teams to apply a range of techniques for data profiling.
Facilitation (Analytics Engineering) (AEC1.4) (Level Four)
You support or host difficult discussions within the team and with diverse senior stakeholders.
Positive communication (AEC1.3) (Level Four)
You manage active and reactive communication with positive effect.
Stakeholder management (Analytics Engineering) (AEC1.2) (Level Four)
You effectively manage stakeholder expectations.
Non-technical audiences (Analytics Engineering) (AEC1.1) (Level Four)
You listen to the needs of business stakeholders and effectively interpret those needs into technical action .
Strategic alignment (Analytics Engineering) (AEC7.3) (Level Five)
You work across all organisational subject areas and internal and external programmes contributing to strategic direction setting.
Patterns (AEC7.2)(Level Five)
You set the strategy to ensure optimal use of patterns.
Data architecture (AEC7.1) (Level Five)
You collaborate in the data architecture to ensure it deals with problems across the organisation or system.
Development lifecycle (Analytics Engineering) (AEC6.3) (Level Five)
You can take technical responsibility for all stages and iterations in a software development project, providing method-specific technical advice and guidance to project stakeholders.
Programming (AEC6.1) (Level Five)
You mandate standards for programming tools and techniques across the organisation or system.
Repository design (AEC5.3) (Level Five)
You can identify how metadata repositories can support different areas of the organisation or system.
Metadata best practice (Analytics Engineering) (AEC5.2) (Level Five)
You communicate the value of metadata repositories with strategic colleagues across the organisation or system and ensure best practice is implemented.
Repository tools and management (AEC5.1) (Level Five)
You ensure data repositories support the organisation’s strategic aims, conform to legal or otherwise mandated frameworks and are subject to effective governance. You are the Senior Responsible Officer for data repositories in the enterprise.
Capacity building (AEC4.4) (Level Five)
You build a culture that values problem-solving capability and communicates the importance of this at strategic level.
Problem prevention (AEC4.3) (Level Five)
You set the strategic direction to embed a preventive approach and liaise with other system leaders to ensure adoption.
Problem resolution (AEC4.2) (Level Five)
You direct team resources to resolve problems affecting data systems in your domain and beyond, collaborating with other key technical personnel and ensuring strategic leads are kept informed.
Problem identification (AEC4.1) (Level Five)
You direct resources and resolve any bottlenecks hindering effective problem identification.
Data iteration, review and maintenance (Analytics Engineering) (AEC3.5)(Level Five)
You adopt frameworks, tools, data and quality standards that ensure data engineering activity satisfies the organisational strategic aims. You promote a culture that values data quality, efficient maintenance, automation and sustainability.
Data engineering (AEC3.4) (Level Five)
You enable the implementation of new tools and practices, understand the emerging data needs of the enterprise and translate those requirements into team workplans ensuring skills acquisition and collaboration with other enterprise data teams.
Reverse engineering (Analytics Engineering) (AEC3.3) (Level Five)
You set strategic direction determining the systems or processes requiring reverse engineering and mitigate the requirement for reverse engineering.
Tools (AEC3.2) (Level Five)
You determine and advocate for the tools to adopt which will deliver the organisational strategic aims in consultation with senior stakeholders and private sector providers.
Data modelling (Analytics Engineering) (AEC3.1) (Level Five)
You can understand different ways to model data to maximise its use and value. You build relationships with other senior data professionals e.g. data architects, data scientists and data engineers, to share best practice and continually improve data modelling, integration processes and standards.
Data transformation (AEC2.5)(Level Five)
You can bring multiple data sources together in a conformed model for analysis.
Data requirements (AEC2.4)(Level Five)
You can source system analysis from a complex single source.
Data innovation (AEC2.3)(Level Five)
You can investigate emerging trends in data-related approaches, perform horizon-scanning for the organisation and introduce innovative ways of working.
Data profiling (Analytics Engineering) (AEC2.2)(Level Five)
You can understand and help teams to apply a range of techniques for data profiling.
Facilitation (Analytics Engineering) (AEC1.4) (Level Five)
You initiate or host difficult discussions within the team and with diverse internal and external senior stakeholders.
Positive communication (AEC1.3) (Level Five)
You speak on behalf of and represent the technical community to large audiences inside and outside health and care .
Stakeholder management (Analytics Engineering) (AEC1.2) (Level Five)
You manage stakeholder expectations and moderate discussions about high risk and complexity, even within constrained timescales.
Non-technical audiences (Analytics Engineering) (AEC1.1) (Level Five)
You communicate effectively with technical staff, and influence and educate non-technical stakeholders .
Strategic alignment (Analytics Engineering) (AEC7.3)
You work across multiple subject areas or a single large or complicated subject area implementing relevant data practices.
Patterns (AEC7.2)(Level Three)
You can produce appropriate patterns for use cases in your domain.
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.
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.
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.
Repository design (AEC5.3)(Level Three)
You can design an appropriate metadata repository liaising across technical, analytical and governance teams to do so.
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 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.
Capacity building (AEC4.4)(Level Three)
You implement development activities around problem solving and provide coaching on this topic.
Problem prevention (AEC4.3) (Level Three)
You can determine the likelihood of common problems occurring and establish preventive measures and guidance.
Problem resolution (AEC4.2) (Level Three)
You can respond to problems in databases, data processes, data products and services as they occur.
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.
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.
Reverse engineering (Analytics Engineering) (AEC3.3)
You reverse engineer more complex data models and mentor less experienced staff.
Tools (AEC3.2)(Level Three)
You use data integration tools and languages to integrate and store data, and advise teams on best practice.
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.
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 profiling (Analytics Engineering) (AEC2.2)(Level Three)
You can undertake data profiling and source system analysis.
Data interpretation (Analytics Engineering) (AEC2.1) (Level Three)
You can present clear insights to colleagues to support the end use of the data.
Facilitation (Analytics Engineering) (AEC1.4) (Level Three)
You support or host difficult discussions within the team.
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.
Stakeholder management (Analytics Engineering) (AEC1.2)(Level Three)
You support and host discussions within a multidisciplinary team sometimes with potentially difficult dynamics.
Non-technical audiences (Analytics Engineering) (AEC1.1) (Level Three)
You communicate effectively with technical staff, and influence and educate non-technical stakeholders .
Strategic alignment (Analytics Engineering) (AEC7.3) (Level Two)
You work in your domain area implementing local data operations.
Patterns (AEC7.2) (Level Two)
You can work within the context of well understood architecture and identify and use appropriate patterns.
Data architecture (AEC7.1) (Level Two)
You are aware of data architecture practice and products.
Performance analysis (Analytics Engineering) (AEC6.2) (Level Two)
You can identify performance issues and risks associated with work.
Programming (AEC6.1) (Level Two)
You design, code, test, correct and document simple programs or scripts under the direction of others, maintain awareness of the development standards for your range of tools and execute test scripts under supervision and analyse results.
Metadata best practice (Analytics Engineering) (AEC5.2) (Level Two)
You implement best practice under guidance when necessary.
Repository tools and management (AEC5.1) (Level Two)
You can maintain a metadata repository to ensure information such as standard reporting metrics remain accurate and up to date.
Capacity building (AEC4.4)(Level Two)
You review domain problem resolutions and share lessons learned.
Problem prevention (AEC4.3) (Level Two)
You perform tasks in your domain according to standard operating procedures.
Problem resolution (AEC4.2) (Level Two)
You respond to problems in databases, data processes, data products and services under guidance.
Problem identification (AEC4.1) (Level Two)
You can identify the types of problems in your domain including databases, data processes, data products and services.
Data iteration, review and maintenance (Analytics Engineering) (AEC3.5) (Level Two)
You review and maintain existing data pipelines to accommodate any necessary changes.
Data engineering (AEC3.4)(Level Two)
You build and test data pipelines ensuring valid, high-quality data is available.
Reverse engineering (Analytics Engineering) (AEC3.3) (Level Two)
You can reverse engineer a data model from a live system with guidance from more senior staff.
Tools (AEC3.2) (Level Two)
You understand the uses of different tools and can compare different data models.
Data modelling (Analytics Engineering) (AEC3.1) (Level Two)
You can produce data models and understand where to use different types of data models. You understand industry-recognised data modelling patterns and standards .
Data profiling (Analytics Engineering) (AEC2.2) (Level Two)
You can undertake data profiling and source system analysis.
Data interpretation (Analytics Engineering) (AEC2.1) (Level Two)
You can present clear insights to colleagues to support the end use of the data.
Facilitation (Analytics Engineering) (AEC1.4)(Level Two)
You clarify topics to bring forward for further discussion.
Positive communication (AEC1.3)(Level Two)
You actively represent the team externally and can manage differing perspectives.
Stakeholder management (Analytics Engineering) (AEC1.2)(Level Two)
You support and host discussions within a multidisciplinary team sometimes with potentially difficult dynamics.
Non-technical audiences (Analytics Engineering) (AEC1.1) (Level Two)
You communicate effectively with technical and non-technical stakeholders.