3046 SQL PowerBI Sme

SQL Subject Matter Expert
- PowerBI Subject Matter Expert
- Iterative approach using sprints.

**Required Security Clearance**: NATO SECRET

**SCOPE OF WORK**
The aim of this SOW is to support NCSC with technical expertise specifically related to the operation and maintenance of SQL databases and Power BI SME activities with a deliverable-based contract to be executed in 2025.

The Cyber Security SQL and Power BI SME gives visibility and insight on the networks in NATO environment, which in turn is critical to effective management, strong security and compliance, and efficient migrations and consolidations.

More broadly, NATO needs to be able to monitor the configuration of its domain controllers in order to prevent exploitation by malicious threat actors.
Under the direction / guidance of the NCSC Point of Contact, the contractor’s personnel will be part of the NCSC Team supporting the following activities:

- Verify that SQL & CVA PowerBI solution is functional & operational. Ensure all relevant reports are accessible by all internal/external stakeholders.
- Assure timely, accurate and complete collection of assessment data originating from vulnerability scans and other assessment sources. Control, maintain and ensure data is imported inside CVA PowerBI solution and that modules of CVA BI data process and operate data without interruption (scripts, storage, procedures etc.).
- Maintain/improve CVA PowerBI solution (SQL database and Power BI modules & reports). In collaboration and under instructions of Section Head and/or CVA analyst design, implement (new) functionalities in order to report aggregated security findings to the stakeholders in a dynamic fashion via tables and graphical presentation.
- Provide to Section Head CVA an overview of all newly implemented modules and reports. Ensure all relevant methodologies, scripts and processes in use are documented and accessible by all required stakeholders.

**SKILL, KNOWLEDGE & EXPERIENCE**
The resource providing services under this SOW is required to have the following profile:

- Bachelor's degree in Computer Science, Information Technology, or related field Or equivalent experience.
- Hands-on experience in API integration using python and PowerShell. At least 5 years’ experience.
- Administering MS SQL Servers, monitoring and tuning the performance within several levels: physical level and database level (database settings and options). At least 3 years’ experience.
- MS SQL query tuning (creating/maintaining database indices, stored procedures, views, functions, memory settings). At least 3-year experience.
- Creating data-rich dashboards, implementing Row-level Security (RLS) in Power BI, writing DAX expressions, developing custom BI products with scripting and programming languages such as Python.
- Proved experience working with jQuery, D3.js.
- Strong understanding of security best practices and experience with tenable products (Tenable Security Center and Nessus Agent Manager).
- 3+ years of experience in IT security, with a focus on Security Audit and / or Security Assessment of large organization.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.

Desirable
- Knowledge of NATO organization and its IT infrastructure is a plus.
- Certifications such as CISSP, CISM, or CISA is a plus.