Data Modeling & Business Intelligence Analyst

Job description

Overview

Systems Planning and Analysis, Inc.

(SPA) delivers high-impact, technical solutions to complex national security issues.

With over 50 years of business expertise and consistent growth, we are known for continuous innovation for our government customers, in both the US and abroad.

Our exceptionally talented team is highly collaborative in spirit and practice, producing Results that Matter.

Come work with the best! We offer opportunity, unique challenges, and clear-sighted commitment to the mission.

SPA: Objective.

Responsive.

Trusted.

The Joint, Office of the Secretary of Defense, Interagency Division (JOID) provides expert support services to a range of customers spanning across the Department of Defense, Federal Civilian, and international markets.

JOID provides a diverse portfolio of analytical and programmatic capabilities to help our customers make informed decisions on their most challenging issues.

SPA's NATO Allied Command Transformation Group, within JOID, provides capability development, portfolio management, program management, quality management, cost estimation analysis, standardization, reporting, software solutions and information management, and capability management support.

We also provide an improved capability requirements capture process, including the generation, documentation and tracing of user requirements, with appropriate technical scrutiny, over the entire lifecycle of the requirements from capability definition through capability realization and capability usage.

The Deputy Chief of Staff Capability Development (DCOS CAPDEV) acts as the Supreme Allied Commander Transformation's Director for guidance, direction and coordination of the activities and resources of the Capability Development Directorate.

CAPDEV is responsible to identify and prioritize Alliance capability development from short to long term, ensuring coherence between all capabilities within the CAPDEV portfolio, to lead the determination of required capabilities and prioritization of shortfalls to inform the delivery of materiel and non-materiel solutions across the Doctrine, Organisation, Training, Material, and Leadership, Personnel, Facilities and Interoperability (DOTMLPFI) lines of effort to enable a holistic approach to capability development, ensuring improved interoperability, deployability, and sustainability of Alliance Forces.

The future Capability Development Directorate will include enduring functionality to effectively plan and manage coherent through life capability development, aligned to NATO’s strategic intent and priorities.

The CAPDEV Data and Analytics Office (DAO) is responsible to DCOS for managing the data and platform operations for Capability Lifecycle, Requirements, and P3M data as well as providing analytics as service and enabling self-service analytics for CAPDEV decision makers.

As part of ongoing organizational functional reviews, CAPDEV is in the process of implementing measures for improved capability development planning and management, including the way it collects manages, analyses and reports on capability development and delivery information, both legacy and current.

We have a near-term need for a Data Modeling & Business Intelligence Analyst to provide onsite support in Norfolk, VA.

Responsibilities

The candidate will design, implement, and maintain logical and physical data models, database schemas, tables, and relationships to support enterprise-level information systems (primarily IBM Engineering Lifecycle Management (ELM), Data Integration and Interoperability).

Develop processes for importing, exporting, migrating, linking, and merging data from multiple repositories, ensuring compatibility and interoperability (., via Requirements Interchange Format), Metadata, and Data Dictionary Management.

Maintain comprehensive metadata repositories, data dictionaries, and naming conventions to ensure consistency, accuracy, and discoverability of enterprise data.

Design and execute ETL workflows to extract, transform, and load data from multiple sources—including spreadsheets, legacy systems, and modern applications—into structured repositories.

Conduct SQL tuning, query optimization, and performance diagnostics to ensure efficient operation of Oracle and MS SQL Server environments.

Develop, customize, and maintain BI reports, visualizations, and dashboards using Microsoft Power BI, Oracle BI, and other approved tools to provide actionable insights to decision-makers.

Create small-scale, fit-for-purpose database applications using platforms such as Microsoft Access, FileMaker Pro, or web-based solutions to meet specific stakeholder needs.

Support the change and configuration management of data assets, ensuring version control, documentation, and compliance with lifecycle management processes.

Perform testing, validation, and troubleshooting of database structures, BI solutions, and data pipelines to verify accuracy and functionality.

Ensure compliance with organizational, NATO, industry, and regulatory standards for data storage, reporting, and access control.

Collaborate with business analysts, developers, system administrators, and end users to capture requirements and translate them into technical specifications.

Identify opportunities for automating repetitive data preparation, reporting, and integration tasks to improve efficiency and reduce manual effort.

Integrate data across multiple systems to deliver unified, cross-domain analytics and reporting solutions.

Deliver training sessions, documentation, and user guides to ensure effective adoption and utilization of BI tools, database systems, and reporting solutions.

Provide ongoing technical support and troubleshooting for data systems, BI tools, and associated applications.

Contribute data modelling and analytics expertise to support requirements-based strategic planning, capability development, and operational decision-making processes.

Qualifications

Required:

Desired:

Required Skill Profession

Mathematical Science Occupations