Business Analyst – (SQL, Oracle PL/SQL & AWS) | Jackson, MS
Quick overview
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
- 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 - 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 - IN
Business AnalystRecently posted
Innosoul inc · Moss Point, MS · On-site · Posted 16 Nov 2026 🇺🇸
Microsoft ExcelData AnalysisOperations & Project ManagementSalary not listed - CI

Wealth Intelligence - Business Analyst - Assistant Vice President - Tampa - CitiRecently posted
Citi · Tampa, FL · On-site · Posted 17 Nov 2026 🇺🇸
ScrumAgileData AnalysisAdministrative$87.3k - $130.9k/yr - DE

Knowledge Management SpecialistRecently posted Auto Apply
Deltasands · Washington · On-site · Posted 16 Nov 2026 🇺🇸
Microsoft OfficeSharePointWindows ServerSalary not listed - MS

Senior Business Analyst (Local candidate within 50 miles and face to face interview)Recently posted
Metalight Solutions Inc · Austin, TX · On-site · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementBusiness AnalysisPMP+5Operations & Project ManagementSalary not listed - SI
Salesforce Technical Business AnalystRecently posted
SR International Inc. · Phoenix, AZ · On-site · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementScrumSalesforce+2TechnologySalary not listed