Senior Data Integration 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 ID: ACT-CDMS-27-01-A-LC07

Role and Duties

Provide hands-on data integration, engineering, data collection modernization, analytics, and decision-support support to the Enabling Capabilities Portfolio, with an initial emphasis on Infrastructure Programmes. This is a hands-on delivery role. The contractor is expected to personally design, configure, develop, test, document, and improve working data and analytical solutions in direct collaboration with operational users. The requirement is not primarily for strategic advisory, enterprise architecture, programme management, or supervision of development performed by others. The objective is to transform fragmented programme information and manual data operations into structured, trusted, reusable information that improves programme and portfolio decision making and delivery.

Taskings:

• Support the Enabling Capabilities Portfolio, with an initial emphasis on Infrastructure Programmes, through hands-on data integration, data engineering, analytics, and decisionsupport activities.
• Work directly with programme managers, portfolio staff, analysts, data owners, and other stakeholders to understand priority decisions, information requirements, existing data sources, data gaps, and opportunities to improve programme delivery through better use of data.
• Design, develop, test, and maintain repeatable data integration processes that ingest, transform, reconcile, and prepare information from multiple programme and enterprise sources for operational use and analysis
• Develop and maintain structured data models, common definitions, business rules, reference data, and data-quality controls required to produce trusted programme and portfolio-level information.
• Design, prototype, configure, and improve digital data-collection applications and workflows that replace or materially reduce spreadsheet-intensive, manually consolidated, emaildriven, or otherwise fragmented data operations. 
• Support the continued development, maturation, and operational use of digital Management and Oversight Review (MOR) data collection and decision-support solutions for Infrastructure Programmes and other Enabling Capabilities Portfolio requirements.
• Develop dashboards, metrics, visualizations, analytical products, and other decision-support solutions that improve visibility of programme status, delivery performance, schedule, resources, risks, dependencies, and emerging issues.
• Apply descriptive and diagnostic analytical techniques, and predictive or prescriptive techniques when directed and appropriate to the decision requirement, to identify trends, relationships, anomalies, risks, and opportunities relevant to programme or portfolio management.
• Integrate programme and portfolio information with authoritative NATO or enterprise data sources through approved mechanisms including relational databases, APIs, data services, structured file exchange, or other available interfaces.
• Identify data-quality, ownership, lineage, governance, stewardship, and authoritative-source issues affecting delivered solutions and implement or recommend practical remediation measures in coordination with responsible stakeholders.
• Use appropriate development and engineering practices, including source or configuration control, documented transformations and business rules, reproducible processing, configuration management, and separation of development and operational artifacts where supported by the technical environment.
• Document data sources, data models, transformations, business rules, analytical logic, dependencies, assumptions, operating procedures, and solution configuration sufficiently to support transparency, auditability, reuse, sustainment, and transition.
• Conduct user testing and iteratively improve solutions based on operational use, stakeholder feedback, data-quality findings, and changes to programme or portfolio information requirements.
• Establish appropriate baselines and assess the effect of delivered solutions on factors such as data quality, timeliness, manual processing effort, information availability, workflow efficiency, and usefulness to decision makers.
• Present analytical findings, assumptions, limitations, risks, and decision implications to programme managers, portfolio leadership, and other stakeholders.
• Support transition of successful prototypes, pilots, data products, and analytical solutions to enduring enterprise platforms, production-support organizations, or designated scaling teams, including preparation of sufficient technical and operational documentation to enable another appropriately qualified individual or team to sustain the solution.
• Perform additional tasks as required by the COTR that are directly related to this labour category and do not constitute a materially different labour requirement.

Essential Qualifications

• Education or Relevant Professional Experience: A University/bachelor’s degree in data science, Computer Science, Information Systems, Engineering, Operations Research, Statistics, Applied Mathematics, or a closely related field; or a minimum of five years of directly relevant professional experience in lieu of the degree. Directly relevant professional experience shall include work in at least two of the following areas: data integration or data engineering; analytical programming; business intelligence, analytics, or decision-support development. Either the degree or experience-in-lieu route fully satisfies this qualification.
• Recent End-to-End Hands-On Solution Delivery: Demonstrated recent experience personally, developing operational data or analytical solutions from identification of a user or decision requirement through data preparation or integration, solution development, user testing, and operational use. The candidate shall demonstrate at least twelve calendar months within the last twenty-four months during which hands-on technical delivery was a regular part of the candidate's assigned work, and at least one data or analytical solution personally developed and used by an identified user group as part of an active business or decision-making process within the last eighteen months. The candidate shall identify the month and year of the qualifying experience, the business or information requirement addressed, the candidate's personal technical contribution, technologies or methods used, and the user group. Experience limited to directing, supervising, managing, advising, coordinating, or overseeing development performed by others does not satisfy this requirement. Multiple components developed for the same user group to address the same business or information requirement shall be considered one example.
• Data Integration and Engineering: Minimum of three years within the last five years, including hands-on experience within the last twenty-four months, performing data integration or data engineering activities using relational databases, ETL/ELT, APIs, data pipelines, data services, structured data exchange, or comparable methods. The candidate shall demonstrate at least one example integrating data from two or more separately administered systems, databases, services, or authoritative data sources and shall identify the source systems and integration mechanism used. Two tables, files, or other objects within the same administered system do not constitute separate sources. Transformation or combination of data performed solely within a business intelligence, visualization, or reporting tool does not by itself satisfy this requirement.
• SQL and Analytical Programming: Minimum of two years within the last five years, including hands-on use within the last twenty-four months, using SQL against relational data sources and at least one of Python, R, Scala, Julia, SAS, MATLAB, Stata, or an equivalent general-purpose or statistical analytical programming language to prepare, transform, integrate, automate, analyse, or quality-control data. The candidate shall identify at least one example within the last twenty-four months in which SQL and at least one qualifying analytical programming language were personally used. DAX, Power Query M, VBA, Excel formulas, spreadsheet macros, and comparable reporting or spreadsheet expressions do not satisfy the analytical programming language requirement.
• Digital Data Collection and Workflow Modernization: Demonstrated experience within the last five years personally designing or developing at least two structured digital data collection, workflow, low-code/no-code, configured-application, or comparable solutions that reduced reliance on manual, email-driven, or spreadsheet-based information processes. At least one example must have been personally developed or materially enhanced within the last three years. For each example, the candidate shall identify the business process addressed, personal contribution, technology or platform used, previous manual or fragmented process, and resulting operational use. A material enhancement must add new data collection, workflow logic, integration, functionality, or a new user population; cosmetic changes or routine maintenance do not qualify. Multiple components supporting the same workflow and user requirement shall be considered one example.
• Business Intelligence and Decision Support: Minimum of three years within the last five years personally developing business intelligence products, analytical products, dashboards, metrics, visualizations, or comparable decision-support products. The candidate shall demonstrate at least one personally developed product used by an identified programme, portfolio, management, or operational user group as part of an active business or decision-making process, rather than solely as a demonstration or proof of concept. The candidate shall identify the information or decision requirement addressed, personal contribution, technology used, user group, and period of operational use. Multiple dashboards, views, or visualizations supporting the same user group and substantially the same information or decision requirement shall be considered one product. Experience limited to supervising, directing, managing, or advising development performed by others does not satisfy this requirement.
• Applied Data Modelling, Data Quality, and Governance: Demonstrated hands-on experience within the last five years, including at least one example within the last three years, applying data modelling, data quality, or data-governance practices as part of an operational data or analytical solution. The candidate shall demonstrate practical application in at least two of the following four areas: (1) development of data models or relationships; (2) development of data definitions, metadata, or common data standards; (3) implementation of validation rules or data-quality controls; or (4) implementation of data lineage, stewardship, or authoritative-source controls. The candidate shall provide a brief description of how each claimed area was personally applied. General familiarity with data governance concepts without evidence of practical application does not satisfy this requirement.
• Transition, Documentation, and Sustainment: Demonstrated experience within the last five years documenting and transferring at least one data, analytical, or digital solution for continued operation or maintenance by another developer, colleague, support team, platform owner, or operational organization. The candidate shall identify the solution, receiving individual or team, documentation or transition material provided, and method used to manage code or configuration artifacts. The candidate must also demonstrate use within the last three years of at least one of the following: Git or equivalent source control; platform-native solution or environment management supporting versioned deployment; or a documented configuration baseline maintained under change control. Formal transfer between organizations is not required. Internal handover to another appropriately qualified individual or team satisfies this requirement.
• Requirements Elicitation and Decision Communication: Minimum of two years within the last five years working directly with operational users, programme personnel, managers, or decision makers to identify information or analytical requirements and communicate findings, assumptions, limitations, risks, or decision implications. The candidate shall identify at least one example including the user or decision-maker group supported, information or analytical requirement addressed, and the candidate's personal role in both elicit

Language Proficiency

Demonstrated proficiency in English as defined in STANAG 6001 (Standardized Linguistic Profile (SLP) 3333 - Listening, Speaking, Reading, and Writing) or equivalent.

Working Location

• Norfolk, VA

Working Policy

• On-Site

Contract Duration

• January 2027 - December 2031

Security Clearance

• Valid National or NATO Secret personal security clearance