Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Business Analyst With Sql Plsql Coding

  • Business Analyst With Sql Plsql Coding job type Posted on: Nov 16, 2026
  • Business Analyst With Sql Plsql Coding experience level Cleo Consulting
  • Business Analyst With Sql Plsql Coding employment type Jksn, Mississippi
  • Business Analyst With Sql Plsql Coding employment type Onsite
  • Business Analyst With Sql Plsql Coding salary CTC

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for Business Analyst With Sql Plsql Coding roles in Mississippi.

View Salary Guide →

Job Title :

Business Analyst With Sql Plsql Coding

Job Type :

Contract

Job Location :

Jksn Mississippi United States

Remote :

No

Jobcon Logo Job Description :

Client: State of MS
Agency: The Mississippi Department of Corrections (MSDOC)
Job ID: 168151
Job Title: Business Analyst - Business Analyst - MS - MSDOC
Job Location: Hinds County MDOC Central Office 301 N Lamar St, Jackson, MS 39201
Projected Start Date : 12/01/2026
Projected End Date/Duration: At least 2 Years from projected start date with possible extension based on performance and business needs
100% onsite required. Two openings, two bids per vendor. Must commit to at least two years but likely extension.

The following are required for bid submission:

  • Resume
  • R2R
  • Cover Letter
  • Meets Work Location

Scoring Method - Must equal 100%

  • Directly Related Experience - 75
  • Certifications - 25

Position Summary

  • We are seeking two (2) experienced Business Analysts with strong skills in translating business requirements into data, reporting, automation, and cloud-based modernization solutions.
  • The ideal candidates will have experience gathering and validating business requirements, analyzing existing application workflows, documenting business rules, supporting User Acceptance Testing (UAT), and collaborating with business users and technical teams to deliver effective system modernization solutions.
  • These analysts will play a critical role in the migration of the legacy Offender Management System to a new cloud-based platform. Responsibilities will include reviewing existing business rules, policies, Standard Operating Procedures (SOPs), reports, user stories, requirements verification documents, and Oracle SQL/PL/SQL code to ensure that existing functionality and business logic are accurately represented in the new system.
  • The role requires a thorough understanding of legacy application functionality, the ability to translate complex business processes into clear functional requirements, and close collaboration with internal stakeholders and a third-party vendor. They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system.
  • Selected candidates must be available to work on-site under a contractual agreement for a minimum commitment of two (2) years.

Key Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy application functionality and identify the underlying business rules and dependencies
  • Review Oracle PL/SQL packages, procedures, functions, triggers, and views to understand existing application logic and support migration to the cloud environment.
  • Identify gaps, inconsistencies, and potential improvements in existing business processes and application functionality.
  • Review existing 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 core logic modules such as sentence computation, offender records, offender programs, alerts, movement, classification, offender disciplinary, offender grievances, 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 clear functional requirements, user stories, acceptance criteria, and process documentation.
  • Ensure that critical business rules and functionality from the legacy system 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 assist in identifying and documenting defects.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.

Required Technical Skills

  • Experience in performing detailed analysis and preparing documentation that translates and supports business rules from the legacy system to the new cloud-based system.
  • Experience reviewing technical documentation, business rules, workflows, reports, and SQL code.
  • Working knowledge of SQL, with 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

Preferred Qualifications

  • 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 (procedures, functions, triggers, packages, 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.

REQUIRED SKILLS/EXPERIENCE

Experience (in years)

Year in which last used

Programmer

7+ years

Business Analyst

5-7 years

ORACLE

5-7 years

SQL

5-7 years

Jobcon Logo Position Details

Posted:

Nov 16, 2026

Reference Number:

8480-22658

Employment:

CTC

City:

Jksn

Job Origin:

CIEPAL_ORGANIC_FEED

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Business Analyst With Sql Plsql Coding    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Client: State of MS
Agency: The Mississippi Department of Corrections (MSDOC)
Job ID: 168151
Job Title: Business Analyst - Business Analyst - MS - MSDOC
Job Location: Hinds County MDOC Central Office 301 N Lamar St, Jackson, MS 39201
Projected Start Date : 12/01/2026
Projected End Date/Duration: At least 2 Years from projected start date with possible extension based on performance and business needs
100% onsite required. Two openings, two bids per vendor. Must commit to at least two years but likely extension.

The following are required for bid submission:

  • Resume
  • R2R
  • Cover Letter
  • Meets Work Location

Scoring Method - Must equal 100%

  • Directly Related Experience - 75
  • Certifications - 25

Position Summary

  • We are seeking two (2) experienced Business Analysts with strong skills in translating business requirements into data, reporting, automation, and cloud-based modernization solutions.
  • The ideal candidates will have experience gathering and validating business requirements, analyzing existing application workflows, documenting business rules, supporting User Acceptance Testing (UAT), and collaborating with business users and technical teams to deliver effective system modernization solutions.
  • These analysts will play a critical role in the migration of the legacy Offender Management System to a new cloud-based platform. Responsibilities will include reviewing existing business rules, policies, Standard Operating Procedures (SOPs), reports, user stories, requirements verification documents, and Oracle SQL/PL/SQL code to ensure that existing functionality and business logic are accurately represented in the new system.
  • The role requires a thorough understanding of legacy application functionality, the ability to translate complex business processes into clear functional requirements, and close collaboration with internal stakeholders and a third-party vendor. They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system.
  • Selected candidates must be available to work on-site under a contractual agreement for a minimum commitment of two (2) years.

Key Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy application functionality and identify the underlying business rules and dependencies
  • Review Oracle PL/SQL packages, procedures, functions, triggers, and views to understand existing application logic and support migration to the cloud environment.
  • Identify gaps, inconsistencies, and potential improvements in existing business processes and application functionality.
  • Review existing 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 core logic modules such as sentence computation, offender records, offender programs, alerts, movement, classification, offender disciplinary, offender grievances, 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 clear functional requirements, user stories, acceptance criteria, and process documentation.
  • Ensure that critical business rules and functionality from the legacy system 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 assist in identifying and documenting defects.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.

Required Technical Skills

  • Experience in performing detailed analysis and preparing documentation that translates and supports business rules from the legacy system to the new cloud-based system.
  • Experience reviewing technical documentation, business rules, workflows, reports, and SQL code.
  • Working knowledge of SQL, with 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

Preferred Qualifications

  • 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 (procedures, functions, triggers, packages, 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.

REQUIRED SKILLS/EXPERIENCE

Experience (in years)

Year in which last used

Programmer

7+ years

Business Analyst

5-7 years

ORACLE

5-7 years

SQL

5-7 years

Loading
Please wait..!!