Business Analyst

Leakesville, MS, US β€’ Posted 1 day ago β€’ Updated 1 day ago
Contract W2
Contract Independent
24 Months
Travel Required
Able to Sponsor
On-site
Depends on Experience
Fitment

Dice Job Match Scoreβ„’

πŸ”’ Crunching numbers...

Job Details

Skills

  • Business Intelligence
  • Amazon Web Services
  • Cloud Computing
  • Database
  • PL/SQL
  • Microsoft Power BI
  • Performance Management
  • DHTML
  • Microsoft Excel

Summary

Business Analyst

The Business Analyst will play a crucial role in supporting the migration of the legacy Offender Management System to a new cloud-based platform. This role involves reviewing existing business rules, policies, standard operating procedures, reports, user stories, and Oracle SQL / PL/SQL code to ensure current functionality and business logic are accurately carried over. The analyst will work closely with internal stakeholders and a third-party vendor on core modules such as records, classification, and sentence computation.

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 cloud migration.
  • Identify gaps, inconsistencies, and improvement opportunities in existing processes.
  • Review Crystal Reports and document report logic, calculations, and data sources for migration to an AWS-compatible reporting platform.
  • Analyze and document core modules: sentence computation, offender records, programs, alerts, movement, classification, disciplinary, grievances, and Community Corrections accounting and supervision.
  • Work with technical teams to validate source-to-target data mappings for accuracy and completeness.
  • Translate legacy functionality into functional requirements, user stories, acceptance criteria, and process documentation.
  • Confirm critical business rules are accurately represented in the redesigned application.
  • Support SIT and UAT; validate migrated functionality against legacy system and document defects.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.

Requirements

<>Required Skills:
  • Detailed analysis and documentation translating legacy business rules to a new cloud-based system.
  • Business Analyst experience reviewing code, business rules, end-user requirements, user stories, workflows, reports, SQL code, and documentation β€” 5+ years.
  • Working knowledge of SQL (queries, joins, data relationships, stored procedure logic).
  • Strong Microsoft Excel skills (PivotTables, Pivot Charts, data analysis, data validation).
<>Preferred Skills:
  • Programming: able to write and review SQL and PL/SQL code β€” 7+ years.
  • Oracle PL/SQL (procedures, functions, triggers, packages, views) β€” 5+ years.
  • Advanced SQL β€” 5+ years.
  • Experience with AWS database and reporting services.
  • Familiarity with BI / reporting platforms such as Microsoft Power BI or AWS QuickSight.
  • 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.
Employers have access to artificial intelligence language tools (β€œAI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: PTPsKqM7ClTvwYO
  • Position Id: 9143829
  • Posted 1 day ago
Contact the job poster
SL

Shubham Lovevanshi

Recruiter @ Universal Consulting Partners Inc.

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.