Pivot Table Data Analysis Analyst

COOLSOFT

Jackson (MS)

On-site

USD 60,000 - 90,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

COOLSOFT in Jackson, MS is seeking two experienced Business Analysts to translate business requirements into data, reporting, automation, and cloud-based modernization solutions. The role focuses on gathering requirements, validating workflows, documenting rules, and supporting UAT as we migrate the legacy system to a cloud platform.

Responsibilities include reviewing Oracle SQL/PL/SQL, data mappings, SOPs, reports, and user stories; ensuring critical rules are represented; collaborating with

Qualifications

  • Translate business rules into data requirements and reports.
  • Review SQL code, reports, and data workflows.
  • Experience with cloud-based modernization is a plus.

Responsibilities

  • Review architecture, data models, workflows, and stored procedures.
  • Analyze legacy functionality and document business rules.
  • Validate source-to-target data mappings with technical teams.
  • Support SIT and UAT and document defects.
  • Participate in design reviews and modernization discussions.

Skills

Cloud Based Systems
SQL - Microsoft
Excel
Pivot Table Data Analysis

Job description

Pivot Table Data Analysis Analyst

(Jobs in Jackson, MS)

Requirement id 159568

Job title Analyst

Job location in Jackson, MS

Skills required Cloud Based Systems, SQL - Microsoft, Excel, Pivot Table Data Analysis

Open Date 16-Nov-2026

Close Date

Job type Contract

Duration 24 Months

Compensation DOE

Status requirement ---

Job interview type ---

Email Recruiter:coolsoft

Job Description Analyst: Cloud Based Systems, SQL - Microsoft, Excel, Pivot Table Data Analysis

Start date: 12/1/2026

End Date : At least 2 Years from projected start date

Submission deadline: 11/23/2026 3:00:00 PM

Client Info : MSDOC

*100% onsite required.

Description:

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, inc

Call502-379-4456 Ext 100for more details. Please provide Requirement id: 159568 while calling.

EOE Protected Veterans/Disability

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Analyst
Business Analyst

Lancesoft • Jackson (MS)

On-site
USD 76,000 - 90,000
Business Analyst
Business Analyst

Noblesoft Technologies • Jackson (MS)

On-site
USD 70,000 - 90,000
Business Analyst - Legacy Application Modernization - Need Locals to MS
Business Analyst - Legacy Application Modernization - Need Locals to MS

Brilliant Infotech Inc. • Jackson (MS)

On-site
USD 70,000 - 95,000
Business Analyst | Contract | Onsite | Jackson, MS
Business Analyst | Contract | Onsite | Jackson, MS

Info Origin Inc • Jackson (MS)

On-site
USD 55,000 - 83,000
Senior Business Analyst
Senior Business Analyst

Accord Technologies Inc • Jackson (MS)

On-site
USD 80,000 - 100,000
Business Analyst
Business Analyst

COGENT DATA SOLUTIONS LLC • Mississippi

On-site
USD 85,000 - 105,000
Business Analyst
Business Analyst

S R International Inc • Jackson (MS)

On-site
USD 70,000 - 90,000
Programmer Analyst (Local to MI)
Programmer Analyst (Local to MI)

American business solutions inc • Lansing (MI)

On-site
USD 60,000 - 100,000
Sr. Business Analyst
Sr. Business Analyst

American business solutions inc • Harrisburg

On-site
USD 55,000 - 96,000
Business Analyst (OnSite Jackson, MS)
Business Analyst (OnSite Jackson, MS)

Da Vinci Software, LLC. • Jackson (MS)

On-site
USD 65,000 - 90,000