Sign upLog in

Database Analyst

InterSources Inc.

Salem, OR

Apply
JOB DETAILS
SKILLS
Acceptance Testing, Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Asset Management, Auditing, Automation, Best Practices, Business Operations, CMVC (Configuration Management Version Control), Claims Processing, Cloud Applications, Cloud Computing, Communication Skills, Computer Science, Configuration Management, Contract Analysis, Contract Management, Customer Support/Service, Data Administration, Data Analysis, Data Management, Data Mapping, Data Migration, Data Modeling, Data Quality, Data Storage, Data Warehousing, DataArchitect Data Modeling Tool, Database Analysis, Database Architecture, Database Extract Transform and Load (ETL), Department of Health and Human Services, Documentation, ERP (Enterprise Resource Planning), Government, Hardware Administration, Hospital, ISO (International Organization for Standardization), IT Service Management (ITSM), Information Technology & Information Systems, Information Technology Consulting, International Electro-Technical Commission (IEC), Internet Security, Investment Management, Knowledge Transfer, License Management, Metrics, Online Marketing, Operational Audit, Oracle, Performance Metrics, Performance Tuning/Optimization, Plan Meetings, Presentation/Verbal Skills, Problem Solving Skills, Process Flow Diagram (PFD), Process Improvement, Project Schedule, Prototyping, Psychiatry and Mental Health, Purchasing/Procurement, Quality Assurance, Reconciliation, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Software Administration, Software Development, Spreadsheets, Sprint Planning, Standard Operating Procedures (SOP), State Government, Structured Data, System Integration (SI), System Migration, Systems Administration/Management, Systems Scalability, Test Scripts, Testing, Trend Analysis, User Experience Design (UXD), User Interface Design, Validation Testing, Web Programming, Writing Skills
LOCATION
Salem, OR
POSTED
5 days ago
Title:Database Analyst
Location:Salem, OR 97302
On-site/Remote/Hybrid: Remote
Duration: 9 Months
Interview Process: Webcam (Teams)
No of submissions:
No of Positions:

SUMMARY OF THE FUNCTION/ROLE
  • 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
  • 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: 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.
  • Scope of Work:
  • 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.

Tasks:
  • Contractor's Key Person shall:
  • 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:
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.
  • 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”).

Required skills and experience:
  • 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.

Database Analyst:
  • Bachelor's degree in Computer Science or a related field is required, with 0–2 years of relevant professional work experience in Software Development, Maintenance, or Implementation. Equivalent experience may be substituted with accredited college training (up to four years), graduate training (up to two years), or successful completion of an accredited Information Technology Certification program (up to two years, with proof of certification). Alternatively, two (2) years of work experience as a Data Administrator, Data Warehousing Administrator, Data Architect, Database Analyst-Intermediate, or Data Warehousing Analyst may substitute for all required experience. Candidates should demonstrate experience as a Data Analyst, with the ability to analyze existing tools and databases, provide software solution recommendations, and translate business requirements into clear, non-technical terms. Strong knowledge of methodologies and processes for managing large-scale databases is required, along with 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 is preferred.
  • Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications and constructions. Relies on established guidelines and instructions to perform daily job functions. Works under immediate supervision and usually reports to a manager. Bachelor's degree in Computer Science or a related field is required, with 0–2 years of relevant professional work experience in Software Development, Maintenance, or Implementation. Equivalent experience may be substituted with accredited college training (up to four years), graduate training (up to two years), or successful completion of an accredited Information Technology Certification program (up to two years, with proof of certification). Alternatively, two (2) years of work experience as a Data Administrator, Data Warehousing Administrator, Data Architect, Database Analyst-Intermediate, or Data Warehousing Analyst may substitute for all required experience. Candidates should demonstrate experience as a Data Analyst, with the ability to analyze existing tools and databases, provide software solution recommendations, and translate business requirements into clear, non-technical terms. Strong knowledge of methodologies and processes for managing large-scale databases is required, along with 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 is preferred.

About Us:
InterSources Inc, is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.

About the Company

I

InterSources Inc.

It’s all about harnessing the real power of data. InterSources Inc was founded in 2007 providing intelligent data solutions to clients across industries and geographies.

Over the years, we have built products on Business Intelligence & Big Data platform simplifying and transforming the way business intelligence and real-time data analytics empower Corporations and end-users using Softwares like Tableau, Business Objects, MicroStrategy, etc.

In the process, we have enabled companies to use data analytics to help better understand, predict and influence consumer behavior, identify new market opportunities as they emerge, provide to users the data they need, alert the user when and why key business metrics have changed and enable them to make smart decisions.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
2007
WEBSITE
https://www.intersourcesinc.com/

Resume Resources

Free Resume TemplatesFree Resume Builder