#NC25SME174716 - #2 Data warehousing and Dashboard Expertise Support - Closed
Deadline: January 30, 2025
Requester: NATO
Location: The Hague, the Netherlands
Job type: Contractor
Start date: March 10, 2025
Security clearance: NATO Secret
SCOPE OF WORK / DUTIES / ROLES
The needs identified are to define, design and implement the necessary ELT logic, data warehouse components and implement the given designs for interoperability dashboards. These must be implemented in our existing NET based Interoperability (IO) Dashboard application.
In addition our bespoke NET based solution needs to be replaced with open source or commercial data warehouse and dash boarding tools. A product analysis will be part of the contract.
More specifically, the work will be to:
- Perform a product selection of possible open source or low cost commercial products to support the ELT and data warehousing logic;
- Support a product selection of possible open source or low cost commercial products to support the data visualization;
- Develop the queries and logic to extract data from our external data sources;
- Develop the logic to load the extracted data into our central data warehouse,
- Develop the transformation logic to convert the loaded data into our internal ontology, which is a model to express the real-world (organizational) view of our data;
- Support the modelling of the data warehouse’s ontology with our internal business experts;
- Design and develop multi-dimensional databases (OLAP Cubes);
- Develop the end-user-facing applications and the actual dashboards to visualize the data to our customers.
REQUIRED SKILLS, KNOWLEDGE AND EXPERIENCE
- More than three years experience and strong working knowledge of and experience with data warehousing and dash boarding concepts:
- Semantic Modelling, Ontologies, Taxonomies;
- Data Modelling;
- Data Warehouse design;
- Multi-Dimensional Database Design and Implementation;
- Visual Dashboards;
- ETL/ELT processes;
- More than three years proven experience with data warehouse modelling, design and implementation;
- More than three years experience and strong working knowledge of and proven experience with the use of SQL Server and SQL Server Analysis Services in the context of data warehousing solutions;
- More than three years experience and ability to design and implement multi-dimensional databases using SQL Server Analysis Services;
- More than three years experience and strong working knowledge of and proven experience with Transact SQL and MDX queries or a similar dialect;
- More than three years experience and strong working knowledge of and proven experience with ETL/ELT Processes and the technical implementation;
- Ability to develop and maintain clear and concise technical documentation, including procedures.
Desirable:
- Experience with the iDesign methodology is considered an advantage;
- Experience with software development using C# and NET Core as a programming language using design patterns and SOLID;
- Experience with Microsoft Blazor;
- Experience with DevExpress BI Dashboard for .NET.
- Relevant soft skills:
- Very good communication skills, both spoken and written, in English;
- Ability to think abstractly;
- Ability to communicate with clarity, coherence, conciseness and engagement in both oral and written communication;
- Demonstrable ability to work autonomously and proactively and to follow internal processes;
- Team player, always willing to help others and to share knowledge;
- Good collaboration skills, with the ability to work in a multinational and diverse team.
This position is now closed.
We regularly add new positions. We suggest exploring other available opportunities and staying updated by following our LinkedIn page.
If you don’t find any suitable opportunities, you can send us your CV, as an open application. However, we will not submit you to any vacancies without your written consent.