About The Position

The Senior Business Analyst will support the migration of a legacy Offender Management System to a new cloud-based platform. The role focuses on translating existing business requirements, application workflows, business rules, reports, and technical logic into clear functional requirements and documentation for the redesigned system. The analyst will collaborate with business users, internal technical teams, and a third-party vendor to preserve and validate legacy functionality, including core modules such as records, classification, and sentence computation. The position involves reviewing legacy application architecture, data models, workflows, Oracle SQL/PL/SQL code, and Crystal Reports. Analysts will help validate source-to-target data mappings, support System Integration Testing and User Acceptance Testing, and document defects or gaps. Selected candidates must work on-site under a contractual agreement for a minimum commitment of two years. Two analysts are being sought.

Requirements

  • Experience performing detailed analysis and preparing documentation that translates and supports business rules from a legacy system to a new cloud-based system.
  • Experience reviewing technical documentation, business rules, workflows, reports, and SQL code.
  • Working knowledge of SQL, including the ability to read and understand queries, joins, data relationships, and stored procedure logic.
  • Strong Microsoft Excel skills, including PivotTables, Pivot Charts, data analysis, and data validation.

Nice To Haves

  • Experience with AWS database and reporting services.
  • Familiarity with business intelligence and reporting platforms such as Microsoft Power BI or AWS QuickSight.
  • Knowledge of Oracle PL/SQL, including procedures, functions, triggers, packages, and views.
  • 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.

Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy application functionality to identify underlying business rules and dependencies.
  • Review Oracle PL/SQL packages, procedures, functions, triggers, and views to understand application logic and support migration to the cloud environment.
  • Identify gaps, inconsistencies, and potential improvements in existing business processes and application functionality.
  • Review Crystal Reports and document report logic, calculations, data sources, and business rules to support migration to a modern reporting platform compatible with AWS.
  • Analyze and document logic modules including sentence computation, offender records, offender programs, alerts, movement, classification, offender disciplinary matters, offender grievances, and Community Corrections accounting and supervision.
  • Work with technical teams to validate source-to-target data mappings and ensure data accuracy and completeness.
  • Translate existing system functionality into functional requirements, user stories, acceptance criteria, and process documentation.
  • Ensure critical legacy business rules and functionality are accurately represented in the redesigned application.
  • Support System Integration Testing (SIT) and User Acceptance Testing (UAT).
  • Validate migrated functionality against the legacy system and help identify and document defects.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service