IMCS Group · 5 months ago
Database Analyst IV
Salem, OR
Full-time
Hybrid
New Grad, Entry, Mid Level
0+ years expIMCS Group is one of the fastest growing MWBE staffing firms in the U.S. They are seeking an experienced Database Analyst IV to support the design, development, testing, and implementation of data structures for hardware and software asset tracking. This role involves collaborating with the Asset Management team to configure and manage relational data models aligned with Ivanti ITSM and Neurons platform requirements.
Staffing & Recruiting
Responsibilities
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
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
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
Qualification
Required
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
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
Company
IMCS Group
IMCS Group is an IT, Healthcare, and Professional Staffing Company that helps Enterprises optimize the business value of their Staffing investments and enables them to achieve world-class business performance.
201-500 employees
H1B Sponsorship
IMCS Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (11)
2024 (16)
2023 (33)
2022 (32)
2021 (47)
2020 (82)
Funding
Current Stage
Growth StageLeadership Team
Satish G Kumar
Founder and CEO
Kathleen Thompson
Diretor Client Partnership
Company data provided by crunchbase