Business Analyst
Posted Updated
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.
Skills
Sign in to read and join the discussion.