Database Analyst

Summary

InterSources Inc is a Small, Woman, and Minority-Owned Business Enterprise with over 18 years of experience in providing IT Consulting Services. They are seeking an experienced Database Analyst to support the implementation, maintenance, and operations of the Ivanti ITSM suite, focusing on data management and system integration for the Oregon Health Authority and Oregon Department of Human Services.

Responsibilities

• 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 business and technical stakeholders
• Review any additions / modifications to requirements and determine impact to deliverables and timelines. Communicate impact to OIS 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 OIS 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. Contractor shall create:
• 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
• Contractor shall provide Services for the purpose of transferring knowledge, ideas, concepts, and information regarding the Deliverables and the System to OIS in order that OIS and OIS-identified employees become self-reliant with respect to the day-to-day operation of the Ivanti tool, as it relates to Contractor's work and expertise as it applies in this WOC ("Know-How")

Skills

• 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
• Bachelor's degree in Computer Science or a related field is required
• 0–2 years of relevant professional work experience in Software Development, Maintenance, or Implementation
• Experience as a Data Analyst, with the ability to analyze existing tools and databases
• Strong knowledge of methodologies and processes for managing large-scale databases
• High-level written and verbal communication skills
• More than nine years of experience maintaining data storage and access by evaluating, designing, and implementing company databases
• Working for state government IT projects
• Ivanti implementation / support for government health and human services agency/agencies

Qualifications

Must Haves

• 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
• Bachelor's degree in Computer Science or a related field is required
• 0–2 years of relevant professional work experience in Software Development, Maintenance, or Implementation
• Experience as a Data Analyst, with the ability to analyze existing tools and databases
• Strong knowledge of methodologies and processes for managing large-scale databases
• High-level written and verbal communication skills

Nice to Haves

• More than nine years of experience maintaining data storage and access by evaluating, designing, and implementing company databases
• Working for state government IT projects
• Ivanti implementation / support for government health and human services agency/agencies