NEW JOB OPENING
SENIOR TECHNICAL BUSINESS ANALYST ORACLE SQL/PLSQL & CLOUD MODERNIZATION
IN JACKSON, MS, USA!

 

Date Posted: 11/17/2026
Hiring Organization: Rose International
Position Number: 510891
Industry: Government/Staffing
Job Title: Senior Technical Business Analyst Oracle SQL/PLSQL & Cloud Modernization
Job Location: Jackson, MS, USA, 39211
Work Model: Onsite
Shift: 8:00AM-5:00PM, Mon-Fri
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 26
Min Hourly Rate($): 60.00
Max Hourly Rate($): 65.00
Must Have Skills/Attributes: Data Analysis, Documentation, Microsoft Excel, SQL
Experience Desired:
Experience in performing detailed analysis and preparing documentation that translates, supports business rules from legacy (5 yrs),
Experience reviewing technical documentation, business rules, workflows, reports, and SQL code (5 yrs),
Working knowledge of SQL, with the ability to read and understand queries, joins, data relationships, and stored procedure (5 yrs),
Strong Microsoft Excel skills, including PivotTables, Pivot Charts, data analysis, and data Validation (5 yrs),
Experience with AWS database and reporting services (5 yrs),
Familiarity with business intelligence and reporting platforms such as Microsoft Power BI or AWS QuickSight (5 yrs),
Knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views) (5 yrs)
Required Minimum Education: Bachelor’s Degree

**C2C is not available**

 

Job Description

REQUIRED EDUCATION:
• Professional Degree

REQUIRED SKILLS/ EXPERIENCE:
• 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 SKILLS/ 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 (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

POSITION DESCRIPTION: The client is seeking experienced Business Analysts with strong skills in translating business requirements into data, reporting, automation, and cloud-based modernization solutions.

ABOUT THE ROLE: 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.

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


  • **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

  • **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

 

Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.

California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).

 

Apply Now

 

About Rose

  • Founded in 1993
  • Office Locations Across the U.S.
  • 150+ Clients: Corporations and Government Agencies
  • Employee Oriented Company
  • Challenging Assignments Across the U.S.
  • Continuous Professional Development

Rose International was not only attentive and responsive, but they were very professional and helpful whenever I called or needed any assistance.

Diane, Consultant

I have been very pleased with my experience with Rose International. Everyone that I encountered was very helpful and courteous.

Stephanie, Consultant

Rose is an assembly of people grounded in honesty, truth and dignity for all of its employees and contractors.

Samba, Consultant

Rose International maintained good communication during assignments and are very informative through email and phone calls.

Sade, Consultant

I had a very positive experience working for Rose. The entire process is very efficient and easy.

Joanne, Consultant

EMPLOYEE COMMENTS

  • We want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.