Business Data Analyst

Resolve Tech Solutions

Jackson (MS)

On-site

USD 60,000 - 80,000

Full time

1 hour ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Resolve Tech Solutions is seeking analysts to gather and validate business requirements for modernizing the Offender Management System. You will review rules, SOPs, reports, and SQL code to ensure functionality translates accurately to a cloud-based platform.

You will support SIT/UAT, validate migrated functionality, and collaborate with internal stakeholders and a third-party vendor to deliver a robust solution. On-site commitment of two years is required.

Qualifications

  • Experience translating legacy business rules into clear functional requirements.
  • Experience reviewing business rules, SOPs, reports, user stories, and requirements documents.
  • Ability to read and understand SQL queries, joins, data relationships, and stored procedure logic.
  • Strong Excel skills including PivotTables, PivotCharts, data analysis and validation.

Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy functionality to identify underlying business rules and dependencies.
  • Review Oracle PL/SQL packages, procedures, functions, triggers, and views to support migration to the cloud.
  • Identify gaps, inconsistencies, and potential improvements in business processes and functionality.
  • Review Crystal Reports and document report logic, calculations, data sources, and rules for migration to AWS-compatible platform.
  • Analyze and document core modules such as records, classification, and sentence computation.
  • Validate source-to-target data mappings and data accuracy with technical teams.
  • Translate system functionality into functional requirements, user stories, acceptance criteria, and process docs.
  • Ensure legacy critical rules are represented in redesigned app.
  • Support SIT and UAT and validate migrated functionality against the legacy system.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.

Skills

Business analysis
Requirements gathering
UAT support
SQL reading
Data modeling
Excel
Documentation
Stakeholder communication

Tools

Oracle PL/SQL
Crystal Reports
Power BI
AWS

Job description

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.

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 Skills
  • 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 Skills
  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Analyst with Offender Management
Business Analyst with Offender Management

System Soft Technologies • Jackson (MS)

On-site
USD 55,000 - 90,000
Senior Oracle Programmer Analyst (AWS Modernization)
Senior Oracle Programmer Analyst (AWS Modernization)

Skywalk Global • Jackson (MS)

On-site
USD 80,000 - 100,000
Onsite Business Analyst - Offender Management & Cloud Data
Onsite Business Analyst - Offender Management & Cloud Data

System Soft Technologies • Jackson (MS)

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

Diversified Systems.com • Jackson (MS)

On-site
USD 60,000 - 86,000
Programmer Analyst (hybrid-remote)
Programmer Analyst (hybrid-remote)

Nanosoft Consulting Talent Page • Lansing (MI)

Hybrid
USD 90,000 - 120,000
Senior Business Analyst – Court Case Management System
Senior Business Analyst – Court Case Management System

ESG Consulting • Atlanta (GA)

On-site
USD 60,000 - 65,000
Senior Database Analyst/Administrator
Senior Database Analyst/Administrator

General Dynamics IT • Virginia

On-site
USD 110,000 - 150,000
Senior Business Systems Analyst
Senior Business Systems Analyst

Compunnel Inc. • San Francisco (CA)

On-site
USD 90,000 - 120,000
Data Analyst
Data Analyst

Mi-Case • United States

On-site
USD 70,000 - 110,000
Lead Business Analyst
Lead Business Analyst

AHU Technologies Inc • Washington

On-site
USD 110,000 - 135,000