JOB DESCRIPTION

Client is currently undergoing a large IT Service Management (ITSM) system replacement project.
This role is critical to supporting the configuration of Ivanti for an automated and scalable IT asset tracking.
We are seeking an experienced Database Analyst IV to support design, development, testing, and implementation of data structures required for hardware and software asset tracking, purchasing workflows, and configuration item (CI) management. This role will provide technical expertise in translating legacy manual processes into structured, normalized datasets—supporting data modeling, cleansing, migration, and process alignment to enable automation, workflows, and reporting within Ivanti’s ITSM and ITAM platforms.

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.
• Ability to clearly document schema designs, data definitions, and mapping logic.
• Experience working in large public sector environments.
• Ability to work independently, manage competing priorities, and work collaboratively with state staff.

PREFERRED SKILLS AND EXPERIENCE

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.

TOP SKILLS & YEARS OF EXPERIENCE

• 7–9 years of advanced experience in Data Analysis
• 7–9 years of advanced experience in Data Modeling
• 7–9 years of advanced experience as a DBA
• 7–9 years of advanced experience with Microsoft Access
• 7–9 years of advanced experience with Microsoft SQL Server
• 7–9 years of advanced experience with MySQL
• 7–9 years of advanced experience with PostgreSQL
• 7–9 years of advanced experience migrating legacy ITAM data to Ivanti
• 4–6 years of proficient experience with CA APM
• 4–6 years of proficient experience in CMDB Expertise
• 4–6 years of proficient experience in large public sector environments
• 7–9 years of advanced experience with industry best practices for data modeling, cleansing, and migration
• 4–6 years of proficient experience with ITIL
• 4–6 years of proficient experience with Ivanti ITSM
• 4–6 years of proficient experience with Ivanti Neurons
• 7–9 years of advanced experience mapping legacy records to Ivanti data structures
• 7–9 years of advanced experience with backup and recovery
• 7–9 years of advanced communication skills
• 7–9 years of advanced experience in teamwork and collaboration
• 7–9 years of advanced experience using Microsoft Office

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.
• Establish repeatable processes for data quality control, deduplication, and validation to support ongoing bulk imports and integrations.
• Provide expertise and guidance for data mapping, including identifying authoritative sources and defining key configuration items (CIs), relationships, and lookup values in support of Ivanti’s data model.
• Create and support execution of plans for resolving data anomalies and discrepancies, including identifying gaps in current data and reconciling conflicting or incomplete records.
• Provide expertise, create plans, and support execution of ETL (extract, transform, load) activities to transition data into the Ivanti platform.
• Recommend and support strategies for maintaining long-term database health, performance, and governance.
• Partner with the project team members to define and document asset lifecycle processes such as procurement, deployment, changes, and disposals, ensuring alignment with audit and compliance requirements.
• Develop technical documentation, data dictionaries, and configuration guides; assist in creating training and knowledge base materials to support long-term maintainability and staff enablement.
• Provide knowledge transfer, guidance, and industry best practices with regards to the tasks above.