Description

You will support the transition and instantiation of ITAM data from legacy sources to the Ivanti suite as part of the ITSM Maturation Project.

Responsibilities

• Collaborate with Asset Management teams to configure and manage 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 execute ETL activities, including extraction, transformation, loading, testing, cleanup, and validation.
• Review existing data systems, queries, and security to provide migration roadmaps and recommendations.
• Execute data cleansing, standardization, and purging to transform legacy data from Excel and CA APM into Ivanti.

Required Skills

• 5+ years of experience in database design, development, and analysis.
• Hands-on ETL experience migrating legacy ITAM data to Ivanti platforms.
• Proven experience mapping legacy records to Ivanti object structures.
• Expertise in data cleansing, validation, and resolving data anomalies.
• Strong SQL skills with proficiency in PostgreSQL, SQL Server, or Oracle.
• In-depth knowledge of Ivanti data mapping and platform capabilities.
• Familiarity with CI relationships and CMDB structures within ITSM/ITAM contexts.
• Experience working in large public sector environments.
• Bachelor's degree or equivalent graduate level education.

Preferred Skills

• Experience with Ivanti ITSM, Neurons for Discovery/Configuration, and CA Service Desk Manager (SDM) or Asset Portfolio Management (APM).
• Knowledge of ITIL v4 practices, specifically Asset Management, Configuration Management, and Change Enablement.
• Experience with automated discovery tools and state government IT projects.

Key Skills

Education

Any Gradute