|Cleaning and manipulating data for improved quality
||Designs quality assurance/ quality control (QA/ QC) procedures. Uses advanced skills with scripting languages for data manipulation.
|Structuring data and constructing a data model
||Applies advanced skills with different database options. Creates advanced file formats for data collection and transformation (for example, macro-enabled workbooks). Utilizes contextually-appropriate data modeling techniques (i.e. hierarchical, object-oriented, network, entity-relationship, relational).
|Storing data according to data governance guidelines
||Demonstrates flexibility to adapt a data management system and associated processes (for example, due to changed demands and context of a red disaster). Installs ODK Central on a cloud server. Installs KoBoToolbox on a cloud server. Sets up https for a cloud-based server.
|Backing up data according to data governance guidelines
||Creates a data lifecycle plan that covers all stages from planning and collection through to deletion.
|Establishing and maintaining a content management system
||Sets up and configures a content management system (for example, Wordpress, Drupal, and Sharepoint). Administers content management systems.
|Integrating data into data model using API
||Integrates data systems with external APIs such as those built into data sharing platforms or mobile data collection servers.
|Preventing and mitigating risks of data breaches according to data governance guidelines
||Manages implementation of a DPIA. Evaluates possible responses when data breaches occur (that is, minimizing threats, avoiding further compromise of systems, and protocols for communication with those affected). Conducts regular data vulnerability checks. Trains others on data security protocols.
|Establishing and applying user permissions according to data governance guidelines
||Develops decision trees, threshold guidance, or other tools to guide data protection integration with business processes. Regularly reviews user permissions to ensure accuracy (i.e. removing permissions for former employees).
|Establishing a geospatial database
||Converts datasets to different serialization formats as needed (binary, text, XML, JSON). Identifies appropriate use cases for spatial database management systems and implements accordingly.
|Structuring vector and raster data models
||Trains others to construct an effective and queryable geographic data model.