Sql data analyst Jobs in Salem, OR

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).

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
  • Facilitate discussions with instructors, administrators, IT personnel, compliance officers, and leadership to ensure all operational, training, and reporting needs are fully understood and captured.
  • Lead workshops, interviews, and working sessions to gather input and build consensus.
  • Surface and resolve conflicting requirements and priorities.
  • Map current processes and design future-state workflows.
  • Identify gaps, recommend operational improvements and optimization opportunities.
• 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.
• 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.