Power BI Dashboard Developer

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 – 2025-0195

Role Background

The scope of this Contract includes the design and development of an Enterprise Service Performance Dashboard. For year 2025, this interactive Dashboard will display and analyse

the service levels of all the cyber security services.

This Project will enable / produce:

• The development of the backend infrastructure and ETL process further to scan and collect data from any relevant sources through accessible environments,
• A methodology in designing dashboards and finally enable visualization of performance of the Cyber Security Services.
• A working dashboard, which allows the user to visualize the service performance of the implemented services, to find answers, drill down the data in a hierarchical breakdown from the level of entity, SLAs, services to the individual KPIs.

Role Duties and Responsibilities

Dashboard Design:

• The Contractor shall produce User Personas describing the fictional, yet realistic, target users of the Dashboard. Purchaser will appoint exemplary “user” representatives amongst the dashboard audience for the Contractor to compile User Personas through surveys and using questionnaires.
• The Contractor shall produce a Wireframe Prototype, which is a visual representation of the skeletal framework of the Dashboard, focusing on layout, content, and functionality without the detailed visual design elements.
• The Contractor shall assist in maintaining a KPI Specification document describing how the individual KPIs of each service will be combined into a single KPI for the service, the service group, the service provider, the location and the entity.
• The Contractor shall contribute to the detailed design for a centralised, fully managed service performance dashboard (including a style guide, a component library and a pattern library) intended to manage visual design at scale using reusable components and patterns.
• The Contractor shall produce a design documentation package describing the technical infrastructure needed for the Dashboard (focusing on all the layers of the technical stack: application, platform and infrastructure - both hardware and software, at the level of detail needed to start the procurement, if additional hardware/software is needed), the data providers and the data sources, the interfaces exposed/used by the Dashboard and the feeding mechanisms.
• The Contractor shall perform the required tasks as managed in line with Agile project principles.
• The Contractor shall produce a monthly progress update report

Implementation:

• The Contractor shall install all components of the Service Performance Dashboard in accordance with project requirements and Purchaser-approved designs.
• The Contractor shall carry out all activities as planned within Agile Project lifecycle. D.2.3 The Contractor shall deliver implementation tasks as planned in Sprints.
• The Contractor shall test the deliverables after implementation.
• The Contractor shall assure that all data sources are managed through ETL (Data
• Extraction, Transfer & Loading) Process, they are visualized in the Dashboard and data accuracy is maintained.
• The Contractor shall generate User Manuals describing how to navigate the Dashboard (for the data consumers) and how to feed the data (for the data providers)
• The Contractor shall document “As-built Use Case Specification”, which is a set of Use Cases describing the "as-built" functional requirements of the Dashboard. For completeness, this document will include also the "as-built" non-functional requirements of the Dashboard.
• The Contractor shall document “As-built Technical Design”, which is the as-built version of the Technical Design that will have been produced during the Concept phase.
• The Contractor shall perform the required tasks as managed in line with Agile project principles.
• The Contractor shall produce a monthly progress update report

Handover:

• The Contractor shall handover to Purchaser team; all developed designs, installation, configuration files and other deliverables stated in previous sections of this document. The Contractor can complete handover when all assigned Tasks are performed and approved by the Purchaser.
• The Contractor shall produce a Project Completion report.

Essential Skills, Experience and Certifications

• Extensive experience in dashboard development and maintenance;
• Experience designing and developing the data Extract, Transform and Load (ETL) activities;
• Sound knowledge and wide-experience with KPIs and formal reporting via Dashboards;
• Experience in ETL activities in Dashboard development teams and working groups in military IT environments;
• Sound knowledge of Dashboard UX Design, Transition and Operation processes with proven experience on one of these processes;
• Sound knowledge of ITIL processes with proven experience on one of these processes;
• Sound knowledge and experience on IT Service Management;
• Experience in writing ETL Deliverables, Requirements documentation and understanding translations into technical solutions;
• Excellent communication skills. Proven ability to effectively communicate orally and in writing, with good briefing skills;
• Sound experience in reporting and use of BI tools;
• Advanced organizational skills and analytical approach to problem solving;
• Sound knowledge and experience with monitoring tools and techniques on measuring service performance.
• Experience in generating technical documentation aiming for both technical and non- technical audience.
• Knowledge and experience configuring CMDB reconciliation and normalisation jobs, and optimising performance of such jobs;
• Experience building Remedy ITSM on Microsoft technologies (Windows server 2016 and MS SQL Server 2016 and above versions);
• Understanding of infrastructure solutions hosting Service Management tools and technology, including understanding of market leading database solutions (including but not limited to MS SQL and Oracle), hypervisor solutions, storage solutions and load balancing solutions.
• A minimum of 3 years recent experience of Power BI;
• A minimum of 3 years recent experience in Business Intelligence domain;
• A minimum of 3 years recent experience in ETL process and coding;
• ITIL 4 Foundation certificate beneficial.

Working Location

• Braine-l’Alleud, 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.