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 NATOs 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 Transformations 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 NATOs strategic objectives.

Role Background

• Deputy Chief of Staff Capability Development (DCOS CAPDEV) acts as the Supreme Allied Commander Transformations 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 NATOs 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 sourcesincluding spreadsheets legacy systems and modern applicationsinto 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