OM-DTA-002 Data Analyst

Provides the support, administration, and maintenance necessary to ensure effective and efficient information technology (IT) system performance and security.

Develops and administers databases and/or data management systems that allow for the storage, query, protection, and utilization of data.

Examines data from multiple disparate sources with the goal of providing security and privacy insight. Designs and implements custom algorithms, workflow processes, and layouts for complex, enterprise-scale data sets used for modeling, data mining, and research purposes.

Knowledges 32

Code	Description	Work Roles
K0001	Knowledge of computer networking concepts and protocols, and network security methodologies.	52
K0002	Knowledge of risk management processes (e.g., methods for assessing and mitigating risk).	52
K0003	Knowledge of laws, regulations, policies, and ethics as they relate to cybersecurity and privacy.	52
K0004	Knowledge of cybersecurity and privacy principles.	52
K0005	Knowledge of cyber threats and vulnerabilities.	52
K0006	Knowledge of specific operational impacts of cybersecurity lapses.	52
K0015	Knowledge of computer algorithms.	6
K0016	Knowledge of computer programming principles	3
K0020	Knowledge of data administration and data standardization policies.	2
K0022	Knowledge of data mining and data warehousing principles.	2
K0023	Knowledge of database management systems, query languages, table relationships, and views.	2
K0025	Knowledge of digital rights management.	2
K0031	Knowledge of enterprise messaging systems and associated software.	2
K0051	Knowledge of low-level computer languages (e.g., assembly languages).	4
K0052	Knowledge of mathematics (e.g. logarithms, trigonometry, linear algebra, calculus, statistics, and operational analysis).	6
K0056	Knowledge of network access, identity, and access management (e.g., public key infrastructure, Oauth, OpenID, SAML, SPML).	11
K0060	Knowledge of operating systems.	13
K0065	Knowledge of policy-based and risk adaptive access controls.	5
K0068	Knowledge of programming language structures and logic.	4
K0069	Knowledge of query languages such as SQL (structured query language).	2
K0083	Knowledge of sources, characteristics, and uses of the organization’s data assets.	2
K0095	Knowledge of the capabilities and functionality associated with various technologies for organizing and managing information (e.g., databases, bookmarking engines).	2
K0129	Knowledge of command-line tools (e.g., mkdir, mv, ls, passwd, grep).	1
K0139	Knowledge of interpreted and compiled computer languages.	8
K0140	Knowledge of secure coding techniques.	3
K0193	Knowledge of advanced data remediation security features in databases.	1
K0197	Knowledge of database access application programming interfaces (e.g., Java Database Connectivity [JDBC]).	2
K0229	Knowledge of applications that can log errors, exceptions, and application faults and logging.	1
K0236	Knowledge of how to utilize Hadoop, Java, Python, SQL, Hive, and Pig to explore data.	1
K0238	Knowledge of machine learning theory and principles.	1
K0325	Knowledge of Information Theory (e.g., source coding, channel coding, algorithm complexity theory, and data compression).	6
K0420	Knowledge of database theory.	4

Skills 26

Code	Description	Work Roles
S0013	Skill in conducting queries and developing algorithms to analyze data structures.	2
S0017	Skill in creating and utilizing mathematical or statistical models.	3
S0202	Skill in data mining techniques (e.g., searching file systems) and analysis.	2
S0028	Skill in developing data dictionaries.	1
S0029	Skill in developing data models.	1
S0037	Skill in generating queries and reports.	2
S0060	Skill in writing code in a currently supported programming language (e.g., Java, C++).	7
S0088	Skill in using binary analysis tools (e.g., Hexedit, command code xxd, hexdump).	3
S0089	Skill in one-way hash functions (e.g., Secure Hash Algorithm [SHA], Message Digest Algorithm [MD5]).	3
S0094	Skill in reading Hexadecimal data.	1
S0095	Skill in identifying common encoding techniques (e.g., Exclusive Disjunction [XOR], American Standard Code for Information Interchange [ASCII], Unicode, Base64, Uuencode, Uniform Resource Locator [URL] encode).	1
S0103	Skill in assessing the predictive power and subsequent generalizability of a model.	1
S0106	Skill in data pre-processing (e.g., imputation, dimensionality reduction, normalization, transformation, extraction, filtering, smoothing).	1
S0109	Skill in identifying hidden patterns or relationships.	1
S0113	Skill in performing format conversions to create a standard representation of the data.	1
S0114	Skill in performing sensitivity analysis.	1
S0118	Skill in developing machine understandable semantic ontologies.	1
S0119	Skill in Regression Analysis (e.g., Hierarchical Stepwise, Generalized Linear Model, Ordinary Least Squares, Tree-Based Methods, Logistic).	1
S0123	Skill in transformation analytics (e.g., aggregation, enrichment, processing).	1
S0125	Skill in using basic descriptive statistics and techniques (e.g., normality, model distribution, scatter plots).	1
S0126	Skill in using data analysis tools (e.g., Excel, STATA SAS, SPSS).	1
S0127	Skill in using data mapping tools.	1
S0129	Skill in using outlier identification and removal techniques.	1
S0130	Skill in writing scripts using R, Python, PIG, HIVE, SQL, etc.	1
S0160	Skill in the use of design modeling (e.g., unified modeling language).	3
S0369	Skill to identify sources, characteristics, and uses of the organization’s data assets.	1

Abilities 5

Code	Description	Work Roles
A0029	Ability to build complex data structures and high-level programming languages.	1
A0035	Ability to dissect a problem and examine the interrelationships between data that may appear unrelated.	2
A0036	Ability to identify basic common coding flaws at a high level.	2
A0041	Ability to use data visualization tools (e.g., Flare, HighCharts, AmCharts, D3.js, Processing, Google Visualization API, Tableau, Raphael.js).	1
A0066	Ability to accurately and completely source all data used in intelligence, assessment and/or planning products.	12

Tasks 23

Code	Description	Work Roles
T0342	Analyze data sources to provide actionable recommendations.	1
T0347	Assess the validity of source data and subsequent findings.	1
T0349	Collect metrics and trending data.	1
T0351	Conduct hypothesis testing using statistical processes.	1
T0353	Confer with systems analysts, engineers, programmers, and others to design application.	1
T0361	Develop and facilitate data-gathering methods.	1
T0366	Develop strategic insights from large data sets.	1
T0381	Present technical information to technical and nontechnical audiences.	3
T0382	Present data in creative formats.	2
T0383	Program custom algorithms.	1
T0385	Provide actionable recommendations to critical stakeholders based on data analysis and findings.	1
T0392	Utilize technical documentation or resources to implement a new mathematical, data science, or computer science method.	1
T0402	Effectively allocate storage capacity in the design of data management systems.	1
T0403	Read, interpret, write, modify, and execute simple scripts (e.g., Perl, VBScript) on Windows and UNIX systems (e.g., those that perform tasks such as: parsing large data files, automating manual tasks, and fetching/processing remote data).	2
T0404	Utilize different programming languages to write code, open files, read files, and write output to different files.	1
T0405	Utilize open source language such as R and apply quantitative techniques (e.g., descriptive and inferential statistics, sampling, experimental design, parametric and non-parametric tests of difference, ordinary least squares regression, general line).	1
T0460	Develop and implement data mining and data warehousing programs.	1
T0007	Analyze and define data requirements and specifications.	1
T0008	Analyze and plan for anticipated changes in data capacity requirements.	2
T0068	Develop data standards, policies, and procedures.	1
T0146	Manage the compilation, cataloging, caching, distribution, and retrieval of data.	2
T0195	Provide a managed flow of relevant information (via web-based portals or other means) based on mission requirements.	1
T0210	Provide recommendations on new database technologies and architectures.	2