数据架构师
数据架构师设计组织如何构建、存储、传输和治理其医疗卫生和照护数据，使其能够安全地用于直接照护、服务规划和研究。他们设计数据模型、数据平台和数据流，制定数据标准，并确保临床含义、质量和保密性在端到端过程中得到保持。
本文由人工智能助手从英文翻译而来，尚未经过母语人士审校。引自英国政府数字与数据专业能力框架（UK GDaD PCF）和 ESCO 的内容保留英文原文。
- 职族
- 架构
- UK GDaD PCF 角色
- Data architect (Architecture)
- ESCO 职业
- database designer (ISCO-08 2521); data warehouse designer (ISCO-08 2521)
级别
| 职级 | 角色级别 | UK GDaD PCF 级别 | 英国公务员职等 | 岗位评估分数 |
|---|---|---|---|---|
| 8a | 数据架构师 | Data architect | SEO/G7 | 560 |
| 8b | 高级数据架构师 | Senior data architect | G7/G6 | 613 |
| 8c | 总数据架构师 | Chief data architect | G6 | 662 |
在数字医疗卫生组织中
- 健康数据必须保持其临床含义，因此数据模型使用 SNOMED CT 等临床术语和 ICD 等分类。
- 用于直接照护的数据与用于规划或研究的数据具有不同的合法依据，因此架构师在设计中考虑数据分离、去标识化和受控访问。
- 数据来自许多质量不一的临床和照护系统，因此架构师在设计中考虑数据质量检查、患者匹配和数据血缘。
- 共享照护记录和数据交换依赖于 HL7 FHIR 资源等通用模型以及商定的国家或国际数据集。
- 记录必须长期保存，因此设计必须为归档和访问历史数据做好规划。
UK GDaD PCF 角色描述
A data architect sets the vision for the organisation’s use of data, through data design, to ensure that data is managed properly and meets the organisation’s needs.
ESCO 职业与技能
ESCO 列出了雇主对每种职业通常需要（必备）或可能需要（可选）的技能和知识。可将其用作发展谈话的检查清单。
database designer
Database designers specify the database's logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
必备技能和知识（27）
技能与能力
- analyse business requirements
- apply ICT systems theory
- assess ICT knowledge
- create data sets
- create database diagrams
- create software design
- define technical requirements
- design database scheme
- develop automated migration methods
- manage database
- manage standards for data exchange
- migrate existing data
- operate relational database management system
- perform data analysis
- use markup languages
- write database documentation
知识
可选技能和知识（76）
技能与能力
- apply technical communication skills
- build business relationships
- define database physical structure
- design database backup specifications
- design database in the cloud
- manage cloud data and storage
- perform resource planning
- use access control software
- use databases
知识
- ABAP
- AJAX
- APL
- ASP.NET
- Agile project management
- Assembly (computer programming)
- C#
- C++
- CA Datacom/DB
- COBOL
- CoffeeScript
- Common Lisp
- DB2
- Erlang
- Filemaker (database management systems)
- Groovy
- Haskell
- IBM Informix
- ICT project management methodologies
- Java (computer programming)
- JavaScript
- LDAP
- LINQ
- Lisp
- MATLAB
- MDX
- ML (computer programming)
- MarkLogic
- Microsoft Access
- Microsoft Visual C++
- MySQL
- N1QL
- ObjectStore
- Objective-C
- OpenEdge Advanced Business Language
- OpenEdge Database
- Oracle Relational Database
- Oracle WebLogic
- PHP
- Pascal (computer programming)
- Perl
- PostgreSQL
- Process-based management
- Prolog (computer programming)
- Python (computer programming)
- R
- Ruby (computer programming)
- SAP R3
- SAS language
- SPARQL
- SQL Server
- Scala
- Scratch (computer programming)
- Smalltalk (computer programming)
- Swift (computer programming)
- Teradata Database
- TripleStore
- TypeScript
- VBScript
- Visual Basic
- XQuery
- computer programming
- data engineering
- data models
- data science
- lean project management
- unstructured data
data warehouse designer
Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
必备技能和知识（28）
技能与能力
- analyse business requirements
- apply ICT systems theory
- assess ICT knowledge
- create data sets
- create database diagrams
- create software design
- define technical requirements
- design database scheme
- develop automated migration methods
- identify software for warehouse management
- manage database
- manage standards for data exchange
- migrate existing data
- operate relational database management system
- use databases
- use markup languages
- write database documentation
知识
可选技能和知识（82）
技能与能力
- apply technical communication skills
- build business relationships
- define database physical structure
- design database backup specifications
- design database in the cloud
- design user interface
- develop reporting software
- manage cloud data and storage
- perform data analysis
- perform resource planning
- respond to customers' inquiries
- store digital data and systems
- use access control software
- use back-up and recovery tools
- use query languages
知识
- ABAP
- AJAX
- APL
- ASP.NET
- Agile project management
- Assembly (computer programming)
- C#
- C++
- CA Datacom/DB
- COBOL
- CoffeeScript
- Common Lisp
- DB2
- Erlang
- Filemaker (database management systems)
- Groovy
- Haskell
- IBM Informix
- ICT project management methodologies
- Java (computer programming)
- JavaScript
- LDAP
- LINQ
- Lisp
- MATLAB
- MDX
- ML (computer programming)
- MarkLogic
- Microsoft Access
- Microsoft Visual C++
- MySQL
- N1QL
- ObjectStore
- Objective-C
- OpenEdge Advanced Business Language
- OpenEdge Database
- Oracle Relational Database
- PHP
- Pascal (computer programming)
- Perl
- PostgreSQL
- Process-based management
- Prolog (computer programming)
- Python (computer programming)
- R
- Ruby (computer programming)
- SAP R3
- SAS language
- SPARQL
- SQL Server
- Scala
- Scratch (computer programming)
- Smalltalk (computer programming)
- Swift (computer programming)
- Teradata Database
- TripleStore
- TypeScript
- VBScript
- Visual Basic
- XQuery
- computer programming
- data models
- data science
- data visualisation software
- lean project management
- product data management
- unstructured data
Contains ESCO v1.2.1 data (https://esco.ec.europa.eu/). © European Union. Reuse authorised under Commission Decision 2011/833/EU.