Context

The General Directorate of Civil Security (DGSC) of the FPS Interior develops and operates Nexus HR, an internal solution designed to enhance the exploitation, quality, visualization, and monitoring of HR and operational data necessary for the functioning of its services and operational units. The solution is mainly based on the Microsoft 365 and Power Platform ecosystem (SharePoint, Power Apps, Power Automate, and Power BI). The DGSC retains functional and technical responsibility for the solution and wishes to benefit from occasional external support to strengthen its architecture and accelerate certain technical developments.

Mission Objective

The consultant will provide advanced expertise in Microsoft Power Platform and Microsoft 365 to strengthen the robustness, maintainability, automation, and sustainability of the Nexus HR solution.

They will work closely with the DGSC’s internal resources and will serve as a technical expert supporting the existing teams, without replacing them.

Main Responsibilities

The consultant will be responsible for:

• Analyzing the current architecture of Nexus HR and providing improvement recommendations.
• Consolidating and securing the existing technical architecture.
• Optimizing and automating the feeding and updating of the Nexus Master List.
• Designing and implementing data historization mechanisms required for statistical analysis and reporting.
• Developing and optimizing Power Automate flows and data integration processes.
• Strengthening quality control, error management, and traceability mechanisms.
• Improving the maintainability and performance of the platform.
• Contributing to the design of solutions usable in Power BI.
• Producing the required technical and functional documentation.
• Ensuring a structured knowledge transfer to internal teams.

Required Technical Skills

Mandatory

• Proven expertise in Microsoft Power Platform:
• Power Apps
• Power Automate
• Power BI
• Excellent command of Microsoft 365:
• SharePoint Online
• Microsoft Lists
• Permission management and security
• Experience in business process automation.
• Experience in data integration and synchronization.
• Proficiency in governance, traceability, and data quality concepts.
• Ability to produce high-quality technical documentation.
• Experience in complex and decentralized organizational environments.

Assets

• Knowledge of public or semi-public environments.
• Experience in low-code/no-code architecture.
• Knowledge of Dataverse.
• Experience with Microsoft Graph API.
• Experience in HR data management and operation.

Desired Profile

• Senior consultant with demonstrable experience in Power Platform.
• Strong analytical and problem-solving skills.
• Excellent communication and technical simplification skills.
• Autonomous while working effectively with an internal team.
• Focus on quality, sustainability, and knowledge transfer.

Expected Deliverables

• Architectural analysis and recommendations.
• Implemented solutions and automations.
• Complete technical documentation of developments carried out.
• Documentation of maintenance procedures.
• Documentation of flows and data models.
• Knowledge transfer sessions to internal resources.

Security and Confidentiality

The consultant must comply with all security and confidentiality rules applicable to the FPS Interior. Development and testing must be carried out, as far as possible, on fictitious or anonymized data. Any access to real data will be strictly regulated according to the Need-to-Know principle.

Languages

• French: excellent level required.
• Knowledge of Dutch is an asset.