Back to Jobs
Recently postedOperations & Project Management

Business Analyst – (SQL, Oracle PL/SQL & AWS) | Jackson, MS

Vision SquareMoss Point, MS🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationMoss Point, MS, United States
Microsoft ExcelBusiness AnalysisData Analysis

Job description

Business Analyst – Legacy System Modernization, SQL, Oracle PL/SQL & AWS Cloud Migration

Job Details

Job Title: Business Analyst – Legacy System Modernization, SQL, Oracle PL/SQL & AWS Cloud Migration

Location: Jackson, Mississippi (Hinds County)

Work Arrangement: 100% Onsite

Number of Openings: 2

Employment Type: Temporary / Contract (Staff Augmentation)

Estimated Start Date: December 1, 2026

Estimated End Date: December 31, 2028

Contract Duration: Minimum 2 Years

Work Schedule: Monday – Friday

Working Hours: 8:00 AM – 5:00 PM

Hours Per Day: 8

Hours Per Week: 40

Travel: Occasional local travel may be required.

Security Requirement: Standard Background Check

Position Overview

We are seeking two experienced Business Analysts to support a large-scale legacy application modernization and cloud migration project.

The selected candidates will play an important role in migrating an existing Offender Management System to a new cloud-based platform. They will analyze existing application functionality, review business rules, document workflows, examine technical documentation and SQL code, and translate legacy system requirements into clear functional requirements for the redesigned application.

The Business Analysts will work closely with business stakeholders, technical teams, and third-party vendors to ensure that existing business processes and system functionality are accurately understood, documented, validated, and represented in the new environment.

The project involves reviewing application modules, reports, database logic, stored procedures, and existing business processes to support successful system modernization.

This position requires 100% onsite work. Remote candidates will not be considered. Selected candidates must be available for a minimum two-year contractual commitment.

Education Requirement

Professional Degree identified in the detailed job posting questionnaire.

Required Skills / Experience

Business Analysis – Advanced (Required)

Experience reviewing existing application code and business rules.

Ability to review and understand end-user requirements.

Experience analyzing user stories and technical documentation.

Ability to translate business requirements into functional requirements.

Experience reviewing workflows, application functionality, and business processes.

SQL and Technical Analysis

Working knowledge of SQL.

Ability to read and understand SQL queries, joins, data relationships, and stored procedure logic.

Experience reviewing technical documentation, business rules, workflows, reports, and SQL code.

Experience performing detailed analysis and preparing documentation to support migration of legacy business rules into a new cloud-based system.

Microsoft Excel

Strong Microsoft Excel skills, including PivotTables and Pivot Charts.

Ability to perform data analysis and data validation.

Preferred Skills / Experience

Programmer / SQL / PL-SQL experience at SME level (7+ years identified in the client's skill-level classification), preferred.

Ability to write and review SQL and PL/SQL code.

Advanced experience with Oracle database systems.

Advanced SQL knowledge and experience.

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 Systems or enterprise justice systems.

Familiarity with legacy web technologies, including DHTML-based applications.

Experience working with external vendor teams on modernization projects.

Job Responsibilities

Legacy Application Analysis

Review and document existing application architecture, data models, workflows, and stored procedures.

Analyze legacy application functionality and identify underlying business rules and dependencies.

Review existing application processes and identify gaps, inconsistencies, and potential improvements.

Understand existing application functionality and support its transition to the new cloud-based platform.

SQL and Oracle Database Analysis

Review Oracle PL/SQL packages, procedures, functions, triggers, and views to understand existing application logic.

Analyze SQL code and database relationships to support system migration.

Work with technical teams to understand existing database functionality.

Support migration of existing application logic to the new cloud environment.

Business Rules and Documentation

Review business rules, policies, Standard Operating Procedures (SOPs), user stories, and requirements verification documents.

Translate existing system functionality into clear functional requirements, user stories, acceptance criteria, and process documentation.

Ensure critical business rules and functionality from the legacy system are accurately represented in the redesigned application.

Identify gaps and inconsistencies in existing business processes and application functionality.

Reports and Reporting Migration

Review existing Crystal Reports.

Document report logic, calculations, data sources, and business rules.

Support migration to a modern reporting platform compatible with AWS.

Application Modules

Analyze and document core application logic, including:

· Sentence computation.

· Offender records.

· Offender programs.

· Alerts.

· Movement.

· Classification.

· Offender disciplinary.

· Offender grievances.

· Community Corrections accounting and supervision.

Data Mapping and Validation

Work with technical teams to validate source-to-target data mappings.

Ensure data accuracy and completeness.

Validate migrated functionality against the legacy system.

Assist in identifying and documenting defects.

Testing and Modernization Support

Support System Integration Testing (SIT) and User Acceptance Testing (UAT).

Participate in requirements walkthroughs.

Participate in design reviews and modernization discussions.

Collaborate with business stakeholders, technical teams, and external vendors.

Working Conditions

Position requires 100% onsite work in Jackson, Mississippi.

The selected candidates must be available to work Monday through Friday, 8:00 AM to 5:00 PM.

Occasional local travel may be required.

Candidates must be available for a minimum two-year contractual commitment.

Standard background check is required.

The position does not require overtime.

There is no formal on-call requirement; however, candidates must be available to answer calls from staff when needed.

Supervisory Responsibilities

No supervisory responsibilities have been specified in the provided job description.

Ideal Candidate

The ideal candidate is an experienced Business Analyst with strong business process analysis, technical documentation, and SQL knowledge.

The candidate should be comfortable reviewing existing application functionality, understanding SQL queries and database relationships, documenting complex business rules, and translating legacy system requirements into clear functional specifications.

Candidates with experience in Oracle databases, PL/SQL, AWS migration, reporting platforms, and enterprise justice or offender management systems will be preferred.

The candidate must be comfortable working with business users, developers, technical teams, and external vendors.

Strong analytical skills, attention to detail, Microsoft Excel proficiency, and the ability to support system integration and user acceptance testing are essential.

The candidate must be willing to work 100% onsite in Jackson, Mississippi, and commit to the minimum two-year contract.

Similar jobs