Data Analyst

Work Role ID: 422  |  Workforce Element: AI / Data

What does this work role do? 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
108 * Knowledge of risk management processes (e.g., methods for assessing and mitigating risk). Knowledge
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
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
ADDITIONAL KSATs
KSAT ID Description KSAT
31 Knowledge of data mining and data warehousing principles. Knowledge
104 Knowledge of query languages such as SQL (structured query language). Knowledge
166 Skill in conducting queries and developing algorithms to analyze data structures. Skill
201 Skill in generating queries and reports. Skill
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
1120 Ability to interpret and incorporate data from multiple tool sources. Ability
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
5440 Present data in creative formats. Task
5570 Provide actionable recommendations to critical stakeholders based on data analysis and findings. 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
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
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
7036 Knowledge of laws, regulations, and policies related to AI, data security/privacy, and use of publicly procured data for government. Knowledge