Data Modeling and Business Intelligence Analyst

Spektrum supports apex purchasers (NATO, UN, EU and National Government and Defence) and their Tier 1 supplier ecosystem with a wide range of specialist services. We provide our clients with professional services, specialised aerospace and defence sales, delivery, and operational subject matter expertise. We are looking for personnel to join our team and support key client projects.

---

Who we are supporting

Allied Command Transformation (ACT) is NATO’s leading agent for change: driving, facilitating, and advocating the continuous improvement of Alliance capabilities to maintain and enhance the military relevance and effectiveness of the Alliance. The main objectives of ACT are: providing appropriate support to NATO missions and operations; leading NATO military transformation; and improving relationships, interaction and practical cooperation with partners, nations and international organisations. ACT therefore leads Alliance concept development, capability development, training and lessons-learned initiatives and provides unfettered military support to policy development within NATO.

---

The program 

Capability Development & Management Support (CDMS)

DCOS Capability Development (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.

The Requirements Division will execute all tasks and activities needed to support requirements management for NATO capabilities

The Capability Requirements (CR) Branch will develop the Capability Requirements Brief and recommended courses of action to resolve issues through the life cycle management of requirements using matrixed, cross-functional project-specific Requirements Management teams.

The Requirements Forward Branch (Mons) is responsible for conducting requirements development and management representation and engagement-related functions in Europe.

The Capability Division coordinates the development of capabilities from capability planning through acceptance and then disposal with management entities, NATO Headquarters staff and the NATO Governance Structure

The Capability Forward Branch (Mons) coordinates with ACO, NCIA, NSPA, NATO HQ, territorial Host Nations, and NATO Centres of Excellence (COEs) to support the development of capabilities.

Strategic Plans and Policy (SPP) supports Allied Command Transformation in formalizing military advice to shape future military strategy, political guidance, and other policy documents supporting NATO’s strategic objectives.

---

Role Background

• Deputy Chief of Staff Capability Development (DCOS CAPDEV) acts as the Supreme Allied Commander Transformation's Director for guidance, direction and co-ordination 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.
  • 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, deploy ability 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 organisational 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.

Role Duties and Responsibilities

• Data Modeling and Repository Architecture: 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 (e.g., 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.
• ETL Development: Design and execute ETL workflows to extract, transform, and load data from multiple sources—including spreadsheets, legacy systems, and modern applications—into structured repositories.
• SQL Optimization: Conduct SQL tuning, query optimization, and performance diagnostics to ensure efficient operation of Oracle and MS SQL Server environments.
• Business Intelligence Development: 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.
• Custom Application Development: 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.
• Change and Configuration Management: Support the change and configuration management of data assets, ensuring version control, documentation, and compliance with lifecycle management processes.
• Testing and Quality Assurance: Perform testing, validation, and troubleshooting of database structures, BI solutions, and data pipelines to verify accuracy and functionality.
• Data Governance and Compliance: Ensure compliance with organizational, NATO, industry, and regulatory standards for data storage, reporting, and access control.
• Stakeholder Engagement: Collaborate with business analysts, developers, system administrators, and end users to capture requirements and translate them into technical specifications.
• Process Automation: Identify opportunities for automating repetitive data preparation, reporting, and integration tasks to improve efficiency and reduce manual effort.
• Cross-System Reporting: Integrate data across multiple systems to deliver unified, cross-domain analytics and reporting solutions.
• User Training: Deliver training sessions, documentation, and user guides to ensure effective adoption and utilization of BI tools, database systems, and reporting solutions.
• Technical Support: Provide ongoing technical support and troubleshooting for data systems, BI tools, and associated applications.
• Capability Lifecycle Analysis Support: Contribute data modelling and analytics expertise to support requirements-based strategic planning, capability development, and operational decision-making processes.
• Performs additional tasks as required by the COTR related to the labor category

Essential Skills and Experience

• Three years’ recent (i.e., in the last 5 years) experience in data modelling, database administration, and BI development in IBM-ELM and/or IBM-DOORS and the IBM database environment (Db2), including the relational database management system (RDBMS).
• Five years’ recent (i.e., in the last 10 years) experience in data modeling and database design in enterprise environments using Oracle and/or MS SQL Server.
• Three years’ recent (i.e., in the last 5 years) experience designing and implementing ETL processes to integrate multiple data sources into enterprise repositories in enterprise environments such as Open Services for Lifecycle Collaboration (OSLC) (API development and management), and experience with Requirements Interchange Format (ReqIF) for information exchange across the NATO enterprise.
• Five years’ recent (i.e., in the last 10 years) experience developing business intelligence dashboards, reports, and documents using tools such as Microsoft Power BI, Oracle BI, and IBM Rational Publishing Engine.
• Experience in change management, configuration management, and maintaining metadata repositories/data dictionaries in compliance with organizational or governmental standards.
• Demonstrable proficiency in effective oral and written communication, including briefing and coordinating with business stakeholders.

Desirable Skills, Experience and Certifications

• Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred.

Education

• A University Degree in Computer Science, Information Systems, or related field.

Language Proficiency

• Advanced Proficiency in English

Working Location

• Norfolk, VA, USA

Working Policy

• On-Site

Contract Duration

• January 2026 – December 2026

Security Clearance

• Valid National or NATO Secret personal security clearance