Kapsuun Group (KG) provides federal agencies and the DoD with a customer-focused partner that has quickly become one of the established industry leaders in software engineering and intelligence operations. Mission success and customer satisfaction are our highest priorities.
The Senior Data Analyst will work in close collaboration with our stakeholders to support the data and reporting needs for the development of Navy’s Risk Management Information (RMI) System. The incumbent will be a key contributor to analyze data from legacy systems to be integrated in the RMI system. The Senior Data Analyst will review complex sets of data and will develop data mapping, business rules and develop SQL script documents based on their analysis to transfer legacy data into the new system. The Senior Data Analyst will support the deployment of new technical solutions, products, and/or standards in support of functions strategy and operations under limited supervision.
The incumbent will work closely with stakeholders, DBAs, testers, and developers to identify and solve data issues, design solutions, develop conceptual models, map functional requirements into technical requirements, and support design and implementation of conversions and interfaces throughout the lifecycle of system development and sustainment.
Develop logical and physical model design, source-to-target mapping, use cases, and other development processes and artifacts.
Identify data subject areas, entities, attributes, relationships, information types, and domains.
Perform code reviews, data model reviews, and testing.
Establish standards and best practices.
Update and maintain metadata repositories and dictionaries.
Work within a daily Agile/Scrum process for sprints across projects and operations.
Responsible for promoting an understanding of data integrity and methodology.
Identify, document, and recommend solutions for poor quality data.
Define, maintain, and enforce data architecture definitions and standards.
Recommend optimum approach and advise on alternatives and the implications of new or revised data processing systems.
Work with Functional Leads, Team Leads, and ETL Developers to communicate business and technical requirements clearly and effectively.
Write and optimize in-application SQL and SQL statements as required.
Other duties as assigned
Bachelor’s degree required OR
High school diploma or GED and 5+ years of related experience in lieu of a degree is required
Active T3 Investigation/Secret
The position requires a COVID vaccination or an approved accommodation/exemption for a disability/medical condition or religious belief
Knowledge, Skills and Abilities
5+ years of military experience in Navy Safety and Occupational Health field preferred but not required.
Experience with data mapping for integration of legacy and interface data.
Experience with data analysis, data mining, data cleansing, modeling, metrics analysis, performance measures, and research.
Experience with aggregating and analyzing performance measure data collected from various sources.
Experience with identification, research, and resolving discrepancies in analytical procedures or cross-functional methods.
Experience with Software Development Life Cycle (SDLC) and Agile methodologies, in particular the test process associated with Agile development programs.
Ability to work independently, collaboratively, creatively, and analytically.
Experience with Enterprise Data Warehouse (EDW) data analysis/library products to support automated test tool development.
Ability to design/re-design, document, administer, and fine tune database environments.
Ability to create and maintain data standards, lineage, and attribute mapping from various data sources, as well as various formats.
Skilled in the integration of Commercial Off-the-Shelf (COTS) products and legacy DOD systems as part of an integrated information system, including the organization and execution of large-scale test and evaluation events.
Experience with ETL development software, cloud architectures, Amazon Web Services (AWS), Oracle, Java, Toad Data Point, Microsoft Access, and SQL.
Must be very proficient in Microsoft Excel.
Ability to determine database structural requirements by analyzing functional requirements, client business operations information, and evaluating existing systems or applications.
Must be well organized.
Must be an effective communicator at multiple levels with the ability to grasp system concepts and communicate their applications.
Must be capable of quickly learning new systems and associated software applications for proficient execution of tasks.
Must be capable of managing multiple projects with time related constraints in a fast- paced contract manufacturing environment.
Must be able to speak effectively before groups of internal and/or external customers or employees.