Sql data analyst Jobs in Salem, OR

Business Analyst

Location: Salem Oregon - 97317

On-site/Remote/Hybrid: Remote

Duration: 12 Months

Business Analyst Learning Management System (LMS) Implementation

The Department of Public Safety Standards and Training (DPSST) serves Oregon's public safety community, including police, corrections, fire, parole and probation, and emergency medical dispatch. Its mission is to promote excellence in public safety by providing high-quality training and by developing and upholding professional standards for police, fire, corrections, parole and probation, and telecommunications personnel. DPSST also licenses private security professionals and private investigators in Oregon. DPSST is a multidisciplinary public safety learning institution that currently lacks the modern technological tools needed to efficiently create, manage, and deliver learning materials. Existing systems for managing training resources, curriculum, and instructional content are outdated, do not support distance learning, and no longer meet the evolving needs of DPSST students and stakeholders. To address these challenges and support more flexible, accessible, technology-driven training models, DPSST received funding in the 20252027 biennium to procure and implement a modern Learning Management System (LMS).

Position Summary

We are seeking an experienced Business Analyst (BA) to support the procurement and implementation of a new Learning Management System (LMS) for a public safety training institution. This role will play a critical part in ensuring the selected LMS integrates effectively with existing systems, supports operational workflows, and meets compliance and reporting requirements. The BA will work closely with the project manager and stakeholders across training, operations, IT, and administration to analyze current processes, define future-state workflows, and translate business needs into clear, actionable requirements. This full-time role averages 40 hours per week, with hours adjusted as needed but not exceeding 40 hours. The estimated project duration is approximately 12 months, though it may be extended if necessary or completed sooner.

Key Responsibilities

Stakeholder Engagement & Facilitation

• Identify and engage stakeholders across departments including training, operations, IT, and compliance
• Lead workshops, interviews, and working sessions to gather input and build consensus
• Surface and resolve conflicting requirements and priorities

Current State Analysis

• Document existing training processes, systems, and workflows
• Analyze current methods for course delivery, certification tracking, and compliance reporting
• Identify inefficiencies, risks, and opportunities for improvement

Future State Design

• Define desired future-state processes supported by the LMS
• Develop process maps, use cases, and user journeys
• Ensure alignment with operational realities, including shift-based work environments and certification requirements

Systems & Integration Analysis

• Inventory systems that will interface with the LMS (e.g., HRIS, records systems, scheduling, identity management)
• Define data flows, system interactions, and integration points
• Collaborate with technical teams to assess integration feasibility and constraints
• Identify system dependencies and risks

Requirements Management

• Elicit, analyze, and document business and technical requirements
• Develop functional and non-functional requirements, including security and compliance needs
• Maintain a requirements traceability matrix
• Support prioritization and validation of requirements with stakeholders

Procurement & Vendor Evaluation Support

• Contribute to development of RFP documents and evaluation criteria
• Participate in vendor demonstrations and solution evaluations
• Assist in scoring vendor responses based on organizational needs

Impact Assessment & Change Support

• Assess the impact of the LMS on business processes, roles, and policies
• Identify organizational readiness considerations
• Collaborate with change management and training teams as needed

Implementation Support

• Provide requirements clarification during system configuration and development
• Support user acceptance testing (UAT)
• Assist in resolving gaps between business needs and system capabilities

Required Qualifications

• Bachelor's degree in business administration, Information Systems, or related field (or equivalent experience)
• 37+ years of business analysis experience on complex system implementation projects
• Demonstrated experience analyzing system integrations and data flows
• Experience working in public sector, public safety, or highly regulated environments
• Strong documentation and requirements management skills

Preferred Qualifications

• Familiarity with compliance-driven training environments
• Experience supporting RFP or procurement processes
• Knowledge of identity management, or records management systems
• Certification such as CBAP, CCBA, or PMI-PBA
• Experience with LMS implementations or enterprise training systems

Key Skills & Competencies

• Strong analytical and problem-solving skills
• Ability to translate business needs into technical requirements
• Excellent facilitation and stakeholder engagement skills
• Process modeling and documentation (e.g., workflow diagrams, use cases)
• Effective communication across technical and non-technical audiences
• Ability to work independently and manage multiple priorities

Deliverables

• Current-state and future-state process documentation
• System and data flow diagrams
• Requirements documentation and traceability matrix
• Integration inventory and analysis
• Gap analysis
• Test plans
• Benefits Management Plan

Position Details

This position will primarily work remote. This contracted position will be issued a cell phone, and laptop. Initial travel to the DPSST campus is required to receive a laptop and cell phone, after which the position will be primarily remote. Work Arrangement: [On-site / Remote] Reports To: Program Lead, Gerod Rayburn and Project Manager, Trish Coloma The final candidate will be subject to a background check including fingerprinting. Adverse information will be reviewed and may result in withdrawal of the contract.

Skills

Education Bachelor's degree in business administration, Information Systems, or related field (or equivalent experience) Proficient (4-6 Years) Yes Certifications CBAP, CCBA, or PMI-PBA Proficient (4-6 Years) No 37+ years of business analysis experience on complex system implementation projects Proficient (4-6 Years) Yes Strong documentation and requirements management skills Proficient (4-6 Years) Yes Familiarity with compliance-driven training environments No Integrations Demonstrated experience analyzing system integrations and data flows Proficient (4-6 Years) Yes Experience with LMS implementations or enterprise training systems Proficient (4-6 Years) No Knowledge of identity management, or records management systems Novice (1-3 Years) No Experience working in public sector, public safety, or highly regulated environments Proficient (4-6 Years) Yes Experience supporting RFP or procurement processes Novice (1-3 Years) No

About Us: InterSources Inc

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.