Data Analyst

Spektrum; Henegouwen; On-site; EUR 45,000 - 65,000; Full time

Job summary

Spektrum seeks a Data Analyst to support enterprise data management, reporting, data modelling and business intelligence for the NCIA program. You will work with Microsoft SQL Server technologies, Power BI, SSRS and ETL processes to analyse data, develop reports, maintain data quality and support data-driven decision‑making.

The role includes designing data structures, developing data warehouses and supporting reporting across IT service management environments.

Qualifications

• Minimum 3 years of experience with Microsoft SQL Server, SSRS, SSIS and SSAS.
• Experience designing data warehouses and implementing ETL processes.
• Experience developing dashboards using Power BI or similar reporting technologies.
• Experience with SharePoint.

Responsibilities

• Collect, analyse and validate data from multiple enterprise sources (sensor systems and ticketing).
• Design, create and test SQL reports using SSRS, Power BI and Excel.
• Develop and maintain BI dashboards and reporting solutions.
• Design and develop ETL processes, data models and data warehouses.
• Prepare analytical findings and communicate results to stakeholders.
• TROUBLESHOOT and optimise reporting solutions.

Skills

Data analysis

Data modelling

Stakeholder communication

BI reporting

Tools

Microsoft SQL Server

SSRS

SSIS

SSAS

Power BI

Excel

SharePoint

C#

Python

R

BMC ITSM data

BMC Remedy Smart Reporting

Job description

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

The NATO Communication and Information Agency (NCIA) is responsible for providing secure and effective communications and information technology (IT) services to NATO's member countries and its partners. The agency was established in 2012 and is headquartered in Brussels, Belgium.

The NCIA provides a wide range of services, including:

• Cyber Security: The NCIA provides advanced cybersecurity solutions to protect NATO's communication networks and information systems against cyber threats.
• Command and Control Systems: The NCIA develops and maintains the systems used by NATO's military commanders to plan and execute operations.
• Satellite Communications: The NCIA provides satellite communications services to enable secure and reliable communications between NATO forces.
• Electronic Warfare: The NCIA provides electronic warfare services to support NATO's mission to detect, deny, and defeat threats to its communication networks.
• Information Management: The NCIA manages NATO's information technology infrastructure, including its databases, applications, and servers.

Overall, the NCIA plays a critical role in ensuring the security and effectiveness of NATO's communication and information technology capabilities.

The program

Assistance and Advisory Service (AAS)

The NATO Communications and Information Agency (NCI Agency) is NATO’s principal C3 capability deliverer and CIS service provider. It provides, maintains and defends the NATO enterprise-wide information technology infrastructure to enable Allies to consult together under Article IV, and, when required, stand together in the face of attack under Article V.

To provide these critical services, in the modern evolving dynamic environment the NCI Agency needs to build and maintain high performance-engaged workforce. The NCI Agency workforce strategically consists of three major categorise's: NATO International Civilians (NIC)'s, Military (Mil), and Interim Workforce Consultants (IWC)'s. The IWCs are a critical part of the overall NCI Agency workforce and make up approximately 15 percent of the total workforce.

Data Analyst

Role ID – C004521/2

Role Background

The NATO Communications and Information Agency (NCIA) is seeking an experienced Data Analyst to support enterprise data management, reporting, data modelling and business intelligence activities.

The successful candidate will work with Microsoft SQL Server technologies, Power BI, SSRS and ETL processes to analyse data, develop reports, maintain data quality and support data-driven decision-making.

The position also involves designing data structures, developing data warehouses and supporting reporting requirements across enterprise IT service management environments.

Role Duties and Responsibilities

• Collect, analyse and validate data from multiple enterprise sources, including sensor systems and ticketing systems.
• Ensure the accessibility, integrity, security and retrievability of data.
• Develop and maintain information-handling procedures and data structures.
• Investigate enterprise data requirements and apply data modelling and quality assurance techniques.
• Design, create and test SQL reports using SSRS, Power BI and Excel.
• Develop and maintain business intelligence dashboards and reporting solutions.
• Design and develop ETL processes, data models and data warehouses.
• Analyse data patterns, identify trends and produce reports supporting management decisions.
• Gather user requirements and prepare reporting specifications.
• Validate report functionality with stakeholders and end users.
• Troubleshoot and improve existing reports based on user feedback.
• Participate in designing data architecture and data storage solutions.
• Support database designers with data structures, relationships and attribute definitions.
• Develop and maintain data-processing workflows and data integration solutions.
• Customise data fields and reporting outputs to meet business requirements.
• Prepare analytical findings and communicate results to technical and non-technical stakeholders.
• Apply established data management standards, processes and methodologies.
• Microsoft SQL Server.
• SQL Server Reporting Services (SSRS).
• SQL Server Integration Services (SSIS).
• SQL Server Analysis Services (SSAS).
• SQL reporting and query development.
• Data warehouse design and development.
• ETL process design and implementation.
• Microsoft Power BI and dashboard development.
• Microsoft Excel for reporting and analysis.
• Data modelling and database structures.
• Data quality assurance and validation.
• Programming experience with C#, Python or R.
• BMC ITSM / ITSM data.
• BMC Remedy Smart Reporting.
• Data analysis, reporting and requirements gathering.
• Troubleshooting and optimisation of reporting solutions.

Experience

• Minimum 3 years of experience working with Microsoft SQL Server, SSRS, SSIS and SSAS.
• Experience designing data warehouses and implementing ETL processes.
• Experience developing dashboards using Microsoft Power BI or similar reporting technologies.
• Experience with SharePoint.
• Demonstrated programming experience using C#, Python or R.
• Experience working with BMC ITSM data and BMC Remedy Smart Reporting.
• Experience gathering reporting requirements and supporting enterprise reporting solutions.

Certifications

Mandatory Certification:

- ITIL v3 or higher certificate.

Working Location

Working Policy

• Working arrangement: 100% on-site attendance indicated.
• End date: 30 December 2026.
• Total scope: 675 hours

Travel

Travel to other NATO sites may be required.

Security Clearance

Valid NATO SECRET personnel security clearance