Database Analyst

Remote role

Client seeks an experienced Database Analyst with expertise in implementation maintenance and operations of the Ivanti ITSM suite including Neurons. Specifically the proposed key person must have Ivanti expertise in the following:

• Workflow design / flow diagrams and process documentation
• ETL and data migration documentation
• Data cleansing normalization and standardization
• Data mapping and transformation rules
• SQL queries reports and dashboards
• KPI metrics and analytics
• User guides SOPs and knowledge articles
• ITSM / ITAM subject matter expertise (SME)
• CMDB and configuration data validation
• Asset software and contract data analysis
• Software normalization and categorization
• Data reconciliation and quality assurance
• UAT support and data validation
• Executive and operational reporting
• Trend analysis and operational insights
• System integration support
• Data governance and compliance reporting
• Stakeholder collaboration and workshops
• Agile project participation
• Process improvement and optimization

This will work towards: Client is currently undergoing a large IT Service Management (ITSM) system replacement project transitioning from legacy CA Service Desk Manager (SDM) and CA Asset Portfolio Management (APM) to Ivanti ITSM and Neurons for Discovery and Configuration Management.

This role is critical to supporting the configuration of Ivanti for an automated and scalable IT asset tracking.

Contractor will also work with IT Asset Management team members including data lead ITSM Maturation Project team members the CMDB owner Ivanti system administrators.

Scope of Work:

• Contractor under this will collaborate with the team members to support the configuration and management of relational data models aligned with Ivanti ITSM and Neurons platform requirements.
• Translate spreadsheet-based and manual processes into structured scalable data systems to support hardware/software asset and purchasing workflows.
• Contribute to the design and population of the configuration management database (CMDB) asset inventories and line-item level purchasing structures.
• Assist in mapping legacy records (e.g. hardware software vendor location financial) into Ivanti object structures identifying and integrating missing or incomplete data.
• Support integration efforts with procurement systems inventory sources and automated discovery tools.
• Plan and support data migration activities including extraction transformation and load (ETL) testing cleanup and validation.
• Ensure data normalization integrity and accessibility across the asset lifecycle incorporating performance tuning error correction and auditing best practices.
• Collaborate with internal technical teams and vendors to troubleshoot and validate data mappings field configurations and automation triggers.
• Document custom database structures data dictionaries and configuration elements to support maintainability and knowledge transfer.

Tasks:

• Participate in daily and weekly Sprint Planning and review meetings with the ITSM team.
• Provide feedback and input on the project release schedules including identifying and recommending incremental delivery of work for the deliverables to be completed in a specific sprint.
• Provide updates to current Tasks and action items upcoming tasks and action items and plan work for the current and upcoming sprints.
• Demonstrate understanding of requirements using incremental functional prototypes and receiving and documenting feedback from business and technical stakeholders.
• Review any additions / modifications to requirements and determine impact to deliverables and timelines. Communicate impact to Business Operations ITSM lead and contract administrator.
• Document Services completed under this Task in the relevant Sprint Report Package.
• Keep members of the project apprised of sprint status via daily updates within daily meetings and within tracking systems as needed.
• Coordinate review and ensure updates of product delivery schedule are agreed upon by the Business Operations ITSM lead and contract administrator.
• Contractor shall complete program documentation identified in the Sprint Planning meetings. Contractor must follow standard version control configuration management principles and standards while making changes to artifacts. Contractor shall create:

o Flow diagrams and process documentation.

o ETL and data migration plans and other associated documentation.

o Data mapping and data transformation rules.

o SQL queries reports and dashboards.

o KPI metrics and analytics.

o User guides SOPs and knowledge articles.

o CMDB configuration specifications.

o Software normalization and categorization documentation.

o Data reconciliation and quality assurance guides and SOPs.

o UAT test scripts and validation.

o Trend analysis reports.

o Data governance and compliance reporting.

o Process improvement and optimization recommendations.

o Other ITSM/ITAM artifacts as defined in the Sprint Planning meetings.

• Workflow design / flow diagrams and process documentation
• ETL and data migration documentation
• Data cleansing normalization and standardization
• Data mapping and transformation rules
• SQL queries reports and dashboards
• KPI metrics and analytics
• User guides SOPs and knowledge articles
• ITSM / ITAM subject matter expertise (SME)
• CMDB and configuration data validation
• Asset software and contract data analysis
• Software normalization and categorization
• Data reconciliation and quality assurance
• UAT support and data validation
• Executive and operational reporting
• Trend analysis and operational insights
• System integration support
• Data governance and compliance reporting
• Stakeholder collaboration and workshops
• Agile project participation
• Process improvement and optimization

In addition the ideal candidate will have skills and experience in:

• Working for state government IT projects.
• Ivanti implementation / support for government health and human services agency/agencies.