Salesforce Business Analyst

Role: Salesforce Business Analyst

Location: Albany, NY

Duration: Long Term

Role summary: The BA will lead requirements elicitation and produce an implementation ready technical design blueprint for the new CMS, including systems design, architecture, integrations, workflows, and detailed requirements. The BA will translate statutory, regulatory, security, and investigative needs into clear, implementable specifications and workflows for civil law enforcement style investigations.

Key responsibilities :

• Eliciting and documenting business, functional, and technical requirements via meetings with OSI SMEs and leadership.
• Analyzing current tools and processes (databases, spreadsheets, SharePoint, mainframe notations) and defining future state case management workflows.
• Designing detailed investigative workflows (intake, prioritization, assignment, alerts, reassignment, supervisory review/approval).
• Specifying integration requirements with external data/analytics systems (e.g., Splunk, NASWA IDH, banking feeds, UI systems, data warehouses) and rules for Risk Based Alert (RBA) intake/updates.
• Defining document management capabilities (secure repository, court ready reports, exportable case files, worksheets, audit histories).
• Capturing security/privacy/access-control requirements (MFA, encryption in transit/at rest, RBAC, PII/CTI protections, controlled sharing with partners).
• Designing supervisor dashboards and reporting (caseloads, status, time-to-completion, backlogs, audit trails, compliance reporting).
• Adapting and extending existing Salesforce UI Benefits workflows and defining interconnections for referrals between OSI, UI Benefits, and other stakeholders.
• Producing and refining Systems Design Document, Architectural Diagram, Integration Diagram, and Requirements Document (draft by end of week 4; final within 2 months).
• Providing weekly documentation of effort, progress, and key decisions.

Required qualifications:

• Minimum 5 years' experience gathering requirements and drafting technical specifications on projects of similar scope and complexity.
• Minimum 5 years' experience, with at least three completed projects:
  • Developing workflows in Salesforce.
  • Developing investigative workflows for civil law enforcement investigations, audits, or personnel misconduct investigations.
  • Working within detailed statutory and regulatory frameworks, including confidentiality requirements.
  • Working with data analytic systems (e.g., Splunk) and designing integrated workflows that use those analytics.

Preferred qualifications:

• Experience designing investigative workflows for criminal investigations or comparable high stakes enforcement environments.
• Experience designing case management or investigative solutions for government labor, benefits, or fraud investigation programs.