Data Analyst

The Data Analyst will work with a team to provide high-quality service to our customer by applying analysis techniques to determine solutions based on client requirements with an IT services/solutions-based scope. They will review, analyze, map and reverse engineer business and technical artifacts such as spreadsheets, programs, data models, data catalogs, design documentation and interfaces to capture, store and maintain relevant metadata for the systems within the portfolio

you will do:

• Decipher data elements from various domain sources (programs, data dictionaries, interfaces) and map/cross-walk to financial terms
• Able to understand complex system environments using non-standardized data domains
• Able to provide data collection of disparate data sources into common data categorizations
• Decipher complex financial descriptions and work through a process/protocol to see if terms can be matched in 9 internal catalog source files
• Update Data Dictionaries
• Create and work with matrixed excel files to track mapped data elements
• Able to piece together data entities from large non-normalized data sets
• Able to understand how data is linked to other data
• Collects and analyzes data and associated system artifacts
• Understand DODAF documents/images and data architectures
• Understand data attributes and how they can be used to assist with data mapping efforts
• Data Mining, Data Mapping, Data Modeling, Data Preparation
• Retrieve data using SQL, PowerShell or other common tools
• Provides support in mission requirements determination, conceptualization, design, development, testing, verification and validation, documentation, and implementation of system application data

• Performs analysis to determine how data is used within the application

• Other duties as assigned
• Understand and convey to leadership topics related to data management, data governance, and data maturity

• Reverse engineer data models and other design or build artifacts to extract relevant business and technical metadata
• Map data in system tables to compliance items
• Creates plans to achieve performance-based objectives
• Review data to detect data quality problems and anomalies
• Help the organization correct data: both current and historical

You'll need to have:

• Ability to obtain an active DoD Secret Clearance
• Bachelor's degree in Computer Science or equivalent 3 to 5 years of experience
• Experience using SQL for data analysis, data quality, and data profiling
• Experience in one or more scripting languages
• Experience working with data sets in enterprise-level data
• Experience creating data mapping documentation for databases, interfaces and applications
• Experience with Agile development methodologies and roles

Even better if you have:

• Experience with AF Logistics systems and data
• Experience in requirements elicitation
• DOD data background
• SFIS background
• Advanced excel skills
• Knowledge of PowerShell and MS Project
• A good problem solver
• Understanding of older database technologies and programming languages (ADABAS, COBOL, Natural, Focus, etc.)
• Data standards experience/knowledge
• Data interface experience/knowledge