Senior Data Integration Analyst

Spektrum•Norfolk, VA

4d•Onsite

About The Position

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

Requirements

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.
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.
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.
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.
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.
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.
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.
Minimum of three years within the last five years personally developing business intelligence products, analytical products, dashboards, metrics, visualizations, or comparable decision-support products.
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.
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.
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.
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.
Must 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.
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.
Demonstrated proficiency in English as defined in STANAG 6001 (Standardized Linguistic Profile (SLP) 3333 - Listening, Speaking, Reading, and Writing) or equivalent.
Valid National or NATO Secret personal security clearance

Responsibilities

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.
Design, configure, develop, test, document, and improve working data and analytical solutions in direct collaboration with operational users.
Transform fragmented programme information and manual data operations into structured, trusted, reusable information that improves programme and portfolio decision making and delivery.
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.