Senior Database Analyst

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Oregon Department of Human Services (ODHS). OIS provides the technology systems and services that support more than 18,000 OHA and ODHS agency staff at local offices and facilities around Oregon. These systems and services help the two agencies determine client service program eligibility;

provide medical, housing, food, and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and Oregon hospital facilities; and promote and protect the Oregon public health.

OIS 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
• 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
• Process improvement and optimization

This will work towards: OIS 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’s Key Person will also work with OIS IT Asset Management team members including data lead, ITSM Maturation Project team members, the CMDB owner, Ivanti system administrators.

• Contractor’s Key Person under this WOC will collaborate with the OIS 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.

• Participate in daily and weekly Sprint Planning and review meetings with the OIS 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…