Sr. Database Engineer – ITSM, ETL, Healthcare
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Role: Sr. Database Engineer ITSM ETL Healthcare
Duration: 9 Months (Contract) W2
Location: Salem OR (Remote)
Key Skills:
Description:
Seeking 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:
Scope of Work:
Tasks:
Duration: 9 Months (Contract) W2
Location: Salem OR (Remote)
Key Skills:
Description:
Seeking 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
Scope of Work:
- Contractor will collaborate with the Clients 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 clients 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 Clients 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 Clients 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 OIS standards while making changes to artifacts.
- Flow diagrams and process documentation.
- ETL and data migration plans and other associated documentation.
- Data mapping and data transformation rules.
- SQL queries reports and dashboards.
- KPI metrics and analytics.
- User guides SOPs and knowledge articles.
- CMDB configuration specifications.
- Software normalization and categorization documentation.
- Data reconciliation and quality assurance guides and SOPs.
- UAT test scripts and validation.
- Trend analysis reports.
- Data governance and compliance reporting.
- Process improvement and optimization recommendations.
- Other ITSM/ITAM artifacts as defined in the Sprint Planning meetings.
Required Experience:
Senior IC
About Company
Advance Your Business Goals Through Valuable IT Solutions Command Your Market Share Through Digital Transformation Advance Your Career at Mavensoft...Read More