Data Analyst

Data Analyst Work Role ID: 422 (NIST: OM-DA-002) Workforce Element: Data/AI

Analyzes and interprets data from multiple disparate sources and builds visualizations and dashboards to report insights.


Items denoted by a * are CORE KSATs for every Work Role, while other CORE KSATs vary by Work Role.

Core KSATs

KSAT ID Description KSAT
22

* Knowledge of computer networking concepts and protocols, and network security methodologies.

Knowledge
31

Knowledge of data mining and data warehousing principles.

Knowledge
104

Knowledge of query languages such as SQL (structured query language).

Knowledge
108

* Knowledge of risk management processes (e.g., methods for assessing and mitigating risk).

Knowledge
166

Skill in conducting queries and developing algorithms to analyze data structures.

Skill
201

Skill in generating queries and reports.

Skill
1120

Ability to interpret and incorporate data from multiple tool sources.

Ability
1157

* Knowledge of national and international laws, regulations, policies, and ethics as they relate to cybersecurity.

Knowledge
1158

* Knowledge of cybersecurity principles.

Knowledge
1159

* Knowledge of cyber threats and vulnerabilities.

Knowledge
3022

Ability to communicate complex information, concepts, or ideas in a confident and well-organized manner through verbal, written, and/or visual means.

Ability
5030

Analyze data sources to provide actionable recommendations.

Task
5100

Collect metrics and trending data.

Task
5270

Develop strategic insights from large data sets.

Task
5430

Present technical information to technical and non-technical audiences.

Task
5899

Manipulate and clean large, disparate datasets for bulk analysis to identify connections.

Task
6130

Ability to identify basic common coding flaws at a high level.

Ability
6180

Ability to use data visualization tools (e.g., Flare, HighCharts, AmCharts, D3.js, Processing, Google Visualization API, Tableau, Raphael.js).

Ability
6300

Knowledge of how to utilize Hadoop, Java, Python, SQL, Hive, and PIG to explore data.

Knowledge
6470A

Read, interpret, write, modify, and execute scripts, macros, and functions.

Task
6570

Skill in identifying hidden patterns or relationships.

Skill
6710

Skill in using basic descriptive statistics and techniques (e.g., normality, model distribution, scatter plots).

Skill
6720

Skill in using data analysis tools (e.g., Excel, STATA SAS, SPSS).

Skill
6780

Utilize different programming languages to write code, open files, read files, and write output to different files.

Task
6900

* Knowledge of specific operational impacts of cybersecurity lapses.

Knowledge
6935

* Knowledge of cloud computing service models Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS).

Knowledge
6938

* Knowledge of cloud computing deployment models in private, public, and hybrid environment and the difference between on-premises and off-premises environments.

Knowledge
7029

Knowledge of how to collect, store, and monitor data.

Knowledge
7031

Knowledge of how to structure and display data.

Knowledge
7032

Knowledge of how to use data to tell a story.

Knowledge

Additional KSATs

KSAT ID Description KSAT
796

Provide a managed flow of relevant information (via web-based portals or other means) based on a mission requirements.

Task
942

Knowledge of the organization’s core business/mission processes.

Knowledge
1034A

Knowledge of Personally Identifiable Information (PII) data security standards.

Knowledge
1034C

Knowledge of Personal Health Information (PHI) data security standards.

Knowledge
5030

Analyze data sources to provide actionable recommendations.

Task
5440

Present data in creative formats.

Task
5570

Provide actionable recommendations to critical stakeholders based on data analysis and findings.

Task
5896

Maintain current knowledge of advancements in DoD AI Ethical Principles and Responsible AI.

Task
6915A

Skill in communicating with all levels of the organization, including senior/mid-level executives, and operational-level personnel (e.g., interpersonal skills, approachability, effective listening skills, appropriate use of style and language for the audience).

Skill
7020

Knowledge of DoD AI Ethical Principles (e.g., responsible, equitable, traceable, reliable, and governable).

Knowledge
7036

Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government.

Knowledge