Quick overview
Job description
Business Analyst
The Business Analyst will play a crucial role in supporting the migration of the legacy Offender Management System to a new cloud-based platform. This role involves reviewing existing business rules, policies, standard operating procedures, reports, user stories, and Oracle SQL / PL/SQL code to ensure current functionality and business logic are accurately carried over. The analyst will work closely with internal stakeholders and a third-party vendor on core modules such as records, classification, and sentence computation.
Responsibilities
- Review and document existing application architecture, data models, workflows, and stored procedures.
- Analyze legacy functionality to identify underlying business rules and dependencies.
- Review Oracle PL/SQL packages, procedures, functions, triggers, and views to support cloud migration.
- Identify gaps, inconsistencies, and improvement opportunities in existing processes.
- Review Crystal Reports and document report logic, calculations, and data sources for migration to an AWS-compatible reporting platform.
- Analyze and document core modules: sentence computation, offender records, programs, alerts, movement, classification, disciplinary, grievances, and Community Corrections accounting and supervision.
- Work with technical teams to validate source-to-target data mappings for accuracy and completeness.
- Translate legacy functionality into functional requirements, user stories, acceptance criteria, and process documentation.
- Confirm critical business rules are accurately represented in the redesigned application.
- Support SIT and UAT; validate migrated functionality against legacy system and document defects.
- Participate in requirements walkthroughs, design reviews, and modernization discussions.
Requirements
<>Required Skills:- Detailed analysis and documentation translating legacy business rules to a new cloud-based system.
- Business Analyst experience reviewing code, business rules, end-user requirements, user stories, workflows, reports, SQL code, and documentation — 5+ years.
- Working knowledge of SQL (queries, joins, data relationships, stored procedure logic).
- Strong Microsoft Excel skills (PivotTables, Pivot Charts, data analysis, data validation).
- Programming: able to write and review SQL and PL/SQL code — 7+ years.
- Oracle PL/SQL (procedures, functions, triggers, packages, views) — 5+ years.
- Advanced SQL — 5+ years.
- Experience with AWS database and reporting services.
- Familiarity with BI / reporting platforms such as Microsoft Power BI or AWS QuickSight.
- Experience with Offender Management or enterprise justice systems.
- Familiarity with legacy web technologies, including DHTML-based applications.
- Experience working with external vendor teams on modernization projects.
Similar jobs
- AC
ERP Business Analyst with D365Recently posted
Advantra Consulting Group · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementBusiness AnalysisProcess ImprovementOperations & Project ManagementSalary not listed - IN
Business AnalystRecently posted
Innosoft Corporation · Columbia, SC · Hybrid · Posted 17 Nov 2026 🇺🇸
Microsoft OfficeProject ManagementOperations & Project ManagementSalary not listed - CI

Senior Business Analyst Operational Resilience / Enterprise ApplicationsRecently posted
ChaTeck Incorporated · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
Stakeholder ManagementBusiness AnalysisConfluence+5Operations & Project ManagementSalary not listed - NB
Solutions AnalystRecently posted Auto Apply
Neuberger Berman · New York · On-site · Posted 17 Nov 2026 🇺🇸
CFAFixed IncomePortfolio Management+1$110k - $120k/yr - CI

Technical Business Analyst - Payments OperationsRecently posted
Centillion Infotech · Greenwood Village, CO · On-site · Posted 16 Nov 2026 🇺🇸
ScrumBusiness AnalysisRequirements Gathering+3Operations & Project ManagementSalary not listed - AG
Business Analyst- Guidewire PolicyCenter- Personal LinesRecently posted
Andre Global Inc · NY · Hybrid · Posted 17 Nov 2026 🇺🇸
AgileOperations & Project ManagementSalary not listed - RI
Senior Business AnalystRecently posted
Raas Infotek LLC · Texas City, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementMicrosoft OfficeScrum+6Operations & Project ManagementSalary not listed - ES
Senior Business AnalystRecently posted
eSolutionsFirst, LLC · Philadelphia, PA · Hybrid · Posted 16 Nov 2026 🇺🇸
Operations & Project ManagementSalary not listed - VS
Business Analyst – (SQL, Oracle PL/SQL & AWS) | Jackson, MSRecently posted
Vision Square · Moss Point, MS · On-site · Posted 16 Nov 2026 🇺🇸
Microsoft ExcelBusiness AnalysisData AnalysisOperations & Project ManagementSalary not listed - RD

Business Analyst - Data TransformationRecently posted
Randstad Digital · Kansas City, MO · Remote · Posted 16 Nov 2026 🇺🇸
Business AnalysisConfluenceJira+1Operations & Project Management$50 - $55/hr - SI

ServiceNow Business Analyst (ITAM - HAM) -- Remote 100% -- Only W2Recently posted
Siri Infosolutions Inc · United States · Remote · Posted 16 Nov 2026 🇺🇸
TechnologySalary not listed - DH
Entry-Level Business Analyst
Dhalite Inc. · New York, NY · Hybrid 🇺🇸
Microsoft ExcelBusiness AnalysisProject Management+1Operations & Project ManagementSalary not listed