Data Analyst

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.

**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.

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**
- Takes responsibility for the accessibility, retrievability and security of specific subsets of data.
- Assesses the integrity of data from multiple sources (including, Data from sensors measurement systems or ticketing systems).
- Maintains and implements information handling procedures.
- Manipulates specific data from information services, to satisfy local or specific information needs.
- Investigates enterprise data requirements, and applies data analysis, data modelling and quality assurance techniques, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions).
- Provides advice and guidance to database designers and others using the data structures and associated components.
- Collects required data through various data sources.
- Utilizes designated data analysis software (both internal and external software) to analyse data.
- Applies data analysis and data modelling techniques to establish, modify, and maintain data structure, and its associated components.
- Writes reports from data analysis to help decision making at the senior level.
- Investigates data requirements in the software development process.
- Participates in designing blueprints on how to structure, store and utilize data.
- Follows standards, processes and methodologies to develop each phase of data architecture (e.g. data manipulating processes, database technology generating processes).
- Selects criteria used to support data processing operations, data flow and the flow control system.
- Detects and summarizes patterns in data and findings by producing simple reports.
- Assesses common problems and obstacles surrounding data gathering.
- Customizes data fields to meet clients' needs.
- Interprets and explains results of a data-gathering initiative.
- Participates in projects to gather data for needs analysis.
- Compile user requirements and specifications for reports
- Design, create and test SQL reports using SSRS, Power BI and Excel
- Validate report functionality with internal staff/end users
- Respond to users to troubleshoot and/or improve existing reports
- Design/develop ETL processes, data models and data warehouses

**Essential Skills and Experience**
- Minimum 3 years of experience with Microsoft SQL Server, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services).
- Experience with data warehouse design
- Experience with ETL processes
- Working experience with SharePoint (Administration experience is desirable).
- Demonstrated competence and experience with programming languages such as C#, Python or R.
- Experience with dashboard development on Microsoft Power BI or similar reporting tools.
- Ex