The mission of Functional Analyst CMDB is planned on a part-time basis (minimum 50%), with the possibility of full-time (100%).

Context

Within the Operations Department of SPW Digital, the operations services ensure, according to the ITIL model, the proper management of IT services provided by SPW Digital to the 9,000 SPW agents.

High-level volume:

• 2,000 calls to the Service Desk per month
• 1,300 service requests per month
• 1,500 incidents opened per month
• 1,000 changes opened per month
• 100 requests for validation/production deployment of a new business application version per month

Also:

• 800 applications and application components in our urbi repository
• Over 2,000 servers and virtual servers, 1,100 switches, 130 routers, 1,000 wifi access points, etc.

SPW Digital plans to implement configuration management through a CMDB, which will allow modeling the links between components of the SPW information system (CI – configuration item).

This CMDB helps break down data silos and aims to limit information obsolescence. By centralizing all configuration information, managers can better understand the configuration items (CI) and the relationships between them. CMDBs are important in areas such as technical (or future financial) impact analysis of changes, problem analysis, incident management, as well as security and legal compliance.

The Atlassian Jira tool has been used for many years at SPW, mainly to support analysis, development, and monitoring activities (bug, functional) of SPW business applications. Recently, SPW Digital has started using Jira Service Management to manage its tickets. The tool has an integrated CMDB (IT asset management).

SPW uses the Silog application based on the SOOLID (ODOO) platform for purchases, stock, and inventory management (asset management) and the URBI application as the application repository.

In addition, within the General Directorate of Mobility & Infrastructures (SPW MI), a parallel initiative is underway to create a CMDB for Smartphone/tablet applications, Telecom, and “Operational Technology” (road infrastructure, waterways, and airports).

The candidate will join the SPW Digital analyst team and will be fully assigned to the implementation of the SPW Digital CMDB (primary objective) and the mutualization of the solution with the SPW MI CMDB (secondary objective).

An analyst is needed to reinforce the operations project team and bring their expertise. Given the nature of the project, the analysis covers both functional elements and data to be processed.

Functional elements

Main activities:

• Needs analysis: Understand and analyze the needs of users and stakeholders.
• Writing specifications: Write detailed functional specifications.
• Solution proposals: Propose technical solutions adapted to the identified needs.
• Monitoring and testing: Monitor developments and carry out functional tests.
• Training and support: Train users and provide functional support.

Data elements

Main activities:

• Data collection and cleaning: Retrieve and prepare data for analysis.
• Data analysis: Use statistical tools to analyze data and identify trends.
• Report creation: Create dashboards and reports to communicate results.
• Recommendations: Propose actions based on analyses to improve company performance.
• Database management: Design and maintain database systems.

Deliverables for each data source

• Functional analysis documentation (which need are we addressing? Who is the requester? What are the use cases to be addressed)
• Data analysis
• Analysis of the structure of the source
• Description of objects in the source and in the CMDB (Categories + attributes + relationships)
• Standard formats for attributes and names
• Lifecycle of the CI in the CMDB (notably management of attributes inside or outside the CMDB)

• Links between CIs

• Proposed solution including:

• Proposal for data schema structures (CIs) in relation to the SPW information system and the data model used
• Links between CIs and services in JiraSM

• Links with existing elements in the CMDB and impact analysis of the planned change

• Dashboards and data quality reports

• Enrichment of best practices for use and feeding the CMDB
• Monitoring and testing of the implemented solution

Current environment

Jira Service Management, Jira datacenter, version 9.4

Behavioral skills

• Ability to work effectively in a team (collaboration)
• Analytical mindset
• Rigor (formality and structure)
• Good communication to present results to stakeholders
• Ability to work independently
• Proactive
• Result-oriented
• Ability to write technical documents

IT Infrastructure skills

• LAN/WAN network
• MAN network
• Datacenter
• Operating systems
• Virtualization
• Cloud
• Storage / Backup
• IP telephony
• CI/CD pipelines
• Databases
• Application servers
• Containerization (Tanzu / Kubernetes)
• Middlewares
• PCs
• Printers
• Collaborative platforms

Evaluation method

The quality criteria will be assessed based on a technical and behavioral interview that will verify the profile in relation to the expected technical and behavioral skills (request for example, real-life scenario). A short specific case study may also be used to test the candidate's ability to manage a project and apply suitable methodologies.