Data Analyst
Analyzes and interprets data from multiple disparate sources and builds visualizations and dashboards to report insights.
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 |