Database Analyst

Key Person under this WOC will participate in the OIS ITSM Maturation Project by supporting the transition and instantiation of ITAM data from legacy sources to the Ivanti suite. The Key Person will:
•Collaborate with the Asset Management team members to support the configuration and management of relational data models aligned with Ivanti ITSM and Neurons platform requirements.
•Contribute to the design and population of the configuration management database (CMDB), asset inventories, and line-item-level purchasing structures.
•Plan and support data migration activities, including extraction, transformation, and load (ETL), testing, cleanup, and validation.

Tasks:
Contractor’s Key Person shall:
•Review existing data systems—models, queries, quality, security—and provide recommendations and a suggested roadmap for migration.
•Provide expertise and guidance for data cleansing, data validation, data standardization, and data purging, with a focus on transforming and importing legacy data from Excel and CA APM into Ivanti.
•Provide expertise, create plans, and support execution of ETL (extract, transform, load) activities to transition data into the Ivanti platform.

Required skills and experience:
The key person must have similar, recent experience supporting the launch of Ivanti tools, including recent, relevant experience:
•Hands-on ETL experience migrating from legacy ITAM data to Ivanti.
•Experience mapping legacy records to Ivanti object structures.
•Experience with data cleansing, validation, standardization, and purging as part of an Ivanti implementation.
•Proven ability to detect and resolve data anomalies and discrepancies.
•In-depth understanding of Ivanti data mapping and platform capabilities.
•In-depth knowledge of industry best practices for data modeling, cleansing, and migration.
•Demonstrated experience in relational database design, development, and analysis.
•Strong SQL skills (e.g., PostgreSQL, SQL Server, Oracle).
•Familiarity with CI relationships and CMDB structures in an ITSM/ITAM context.
•Experience working in large public sector environments.

In addition, the ideal candidate will have skills and experience in:
•Ivanti ITSM and Neurons for Discovery/Configuration.
•Familiarity with CA Service Desk Manager (SDM) and Asset Portfolio Management (APM).
•Knowledge of ITIL v4 practices, especially Asset Management, Configuration Management, and Change Enablement.
•Experience with CMDB best practices and automated discovery tools.
•Understanding of service catalog structure and line-item-level procurement workflows.
•Experience working on state government or similar public sector IT projects.
•Building and managing scalable, clean, and auditable datasets in support of enterprise ITSM and ITAM solutions.
•Experience performing knowledge transfer / mentoring