BI 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 Duties and Responsibilities

Power BI Integration:

• Proficiently manage Power BI Report Server and Power BI Desktop proficient, including setup, configuration and optimization;
• Write SQL and integrate various data sources (including Oracle) in Power BI;
• Develop and publish interactive dashboards and reports in Power BI;
• Create and maintain data models in Power BI;
• Utilize DAX (Data Analysis Expressions) for advanced data analysis and calculations;
• Ensure data accuracy, consistency, and security within the Power BI environment;
• Troubleshoot activities and resolve issues related to Power BI Report Server and Power BI Desktop.

Oracle Expertise:

• Identify data objects from OBIA data warehouses and data marts;
• Perform data extraction, transformation, and loading (ETL) processes;
• Troubleshoot and resolve OBIA-related issues;
• Integrate data from multiple sources, including flat files, APIs, and other databases, into Oracle Data Base;
• Write SQL and optimize database queries, ODI mappings, and ETL processes for performance and scalability (including OBIA);
• Stay current with the latest OBIA best practices and technologies

Consulting & Project Management:

• Conduct data analysis and requirements gathering sessions with clients;
• Provide expert consultation on data warehousing, business intelligence, and data visualization best practices;
• Communicate effectively with clients and stakeholders;
• Manage project timelines, budgets, and deliverables

Essential Skills and Experience

• 7 - 10 years of Software implementation experience and in configuring and integration of business applications.
• Data Modelling and Design. Proficient in designing normalized and denormalized data models, star/snowflake schemas;
• In depth knowledge and extensive experience with Power BI, including data modelling, DAX, and dashboard design;
• Oracle Data Integrator (ODI) Proficiency. Strong hands-on experience with Oracle Data Integrator for designing and implementing ETL processes;
• Strong analytical and problem-solving skills with the ability to analyse complex data sets;
• Excellent communication and interpersonal skills, with the ability to explain technical concepts to both technical and non-technical audiences.
• Strong project management and organizational skills.
• Ability to work independently and as part of a team.

Training/Certifications

• Microsoft Power BI (Report Server and Desktop)
• Oracle Business Intelligence Applications (OBIA)
• ETL Tools (e.g. Oracle Data Integrator (ODI))
• Oracle Data Base
• SQL
• Data Warehousing Concepts
• Data Modelling
• DAX
• Reporting and Data Visualization Tools

Desirable Skills and Experience

• Proven experience as a BI Consultant, a strong understanding of Power BI and DWH architecture, components, functionalities and Oracle and Microsoft Data base security.
• Prior experience of working in Agile development methodologies.
• Experience with ODAC.

Working Location

• Braine-l’Alleud, Belgium

Working Policy

• Hybrid (75% Remote, 25% onsite)
• Monday to Thursday 8.30 – 17.30 and Friday 8.30 – 15.30

Travel

• Occasional requirement to work on site at the NCI Agency Belgium location (Braine-l'Alleud, Brussels or The Hague) for a couple of days per month (maximum 1 week per month)

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.