Data Analyst

Spektrum

Eigenbrakel

On-site

EUR 41,000 - 83,000

Full time

31 hours ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Spektrum supports apex purchasers and defence ecosystems. A NATO NCIA Data Analyst role in Belgium seeks expertise in data management, reporting and BI to enable informed decisions across enterprise IT services.

The successful candidate will work with Microsoft SQL Server, Power BI, SSRS/SSIS/SSAS, ETL and data warehouses, ensuring data quality and delivering dashboards to stakeholders.

Qualifications

Minimum 3 years of experience with MS SQL Server, SSRS, SSIS and SSAS.
Experience designing data warehouses and implementing ETL processes.
Experience developing dashboards with Power BI.
Experience with SharePoint.
Programming using C#, Python or R.
Experience with BMC ITSM data and Remedy Smart Reporting.
Ability to gather reporting requirements and support enterprise reporting.

Responsibilities

Collect, analyse and validate data from multiple enterprise sources.
Develop and maintain BI dashboards and reporting solutions.
Design, create and test SQL reports using SSRS, Power BI and Excel.
Develop and maintain data-processing workflows and data integration solutions.
Prepare analytical findings and communicate results to stakeholders.
Gather user requirements and prepare reporting specifications.
Validate report functionality with stakeholders and end users.
Troubleshoot and improve existing reports based on user feedback.

Skills

Data analysis

Data modelling

Reporting

Stakeholder communication

Problem solving

Data quality assurance

Requirements gathering

Education

ITIL v3 or higher

Tools

Microsoft SQL Server

SSRS

SSIS

SSAS

Power BI

Excel

SharePoint

Python

BMC ITSM

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.
Investigate data requirements during software development activities.
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.

Essential Skills

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.
Microsoft SharePoint experience.
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.

Desirable Skill

SharePoint administration experience.

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: