Spektrum have a wide range of exciting opportunities in several global locations.
We are always looking to add great new talent to our team and look forward to hearing from you.
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.
Role ID – 2024-0229
Role Background
The NATO Communications and Information (NCI) Agency has established a critical role in supporting NATO's strategic capability delivery across Consultation, Command & Control, Communications, Information, and Cyber Defence functions. Within this framework, the NATO Cyber Security Centre (NCSC) plays a vital role in defending NATO networks around the clock and sharing cybersecurity intelligence with relevant stakeholders to ensure collective security.
To enhance the effectiveness of these operations, the agency is seeking a Subject Matter Expert (SME) specializing in SQL and Power BI. This role involves providing operational support, maintenance, and expert guidance on data management, analysis, and reporting tools essential for cybersecurity incident management and strategic decision-making.
Role Duties and Responsibilities
- Verify that SQL & CVA PowerBI solution is functional & operational. Ensure all relevant reports are accessible by the all internal/external stakeholders.
- Assure timely, accurate and complete collection of assessment data originating from vulnerability scans and other assessment sources. Control, maintain and ensure data is imported inside CVA PowerBI solution and that modules of CVA BI data process and operate data without interruption (scripts, storage, procedures etc.).
- Maintain/improve CVA PowerBI solution (SQL database and Power BI modules & reports). In collaboration and under instructions of Section Head and/or CVA analyst design, implement (new) functionalities in order to report aggregated security findings to the stakeholders in a dynamic fashion via tables and graphical presentation.
- Provide to Section Head CVA an overview of all newly implemented modules and reports. Ensure all relevant methodologies, scripts and processes in use are documented and accessible by all required stakeholders.
Essential Skills, Experience and Certifications
- Hands-on experience in API integration using python and PowerShell. At least 5 years' experience.
- Administering MS SQL Servers, monitoring and tuning the performance within several levels: physical level and database level (database settings and options). At least 3 years' experience.
- MS SQL query tuning (creating/maintaining database indices, stored procedures, views, functions, memory settings). At least 3 year experience.
- Creating data-rich dashboards, implementing Row-level Security (RLS) in Power BI, writing DAX expressions, developing custom BI products with scripting and programming languages such as Python.
- Proved experience working with jQuery, D3.js.
- Strong understanding of security best practices and experience with tenable products (Tenable Security Center and Nessus Agent Manager).
- 3+ years of experience in IT security, with a focus on Security Audit and / or Security Assessment of large organisation.
- Strong analytical and problem-solving skills
- Excellent communication and collaboration skills
- Knowledge of NATO organization and its IT infrastructure is a plus
- Certifications such as CISSP, CISM, or CISA is a plus.
Education
- Bachelor's degree in Computer Science, Information Technology, or related field Or equivalent experience.
Working Location
- Mons, Belgium
Working Policy
- On-site
Travel
- Some travel to other NATO sites may be required
Security Clearance
- Valid National or NATO Secret personal security clearance
We never know what new opportunities might be just over the horizon. If this opportunity isn't for you please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.