Location: Jackson, Mississippi — 100% On-site
Experience: 7+ years
About the Opportunity
Cogent Data Solutions LLC is seeking two experienced Business Analysts to support the modernization of a legacy Offender Management System to a new cloud-based platform.
The ideal candidates will have strong business analysis skills, experience analyzing legacy applications, and the ability to translate existing business rules, workflows, reports, and technical logic into clear functional requirements for a modernized system.
You will work closely with business stakeholders, technical teams, and third-party vendors to ensure that existing application functionality is accurately understood, documented, validated, and represented in the new system.
Key Responsibilities
- Review and document existing application architecture, data models, workflows, business rules, and stored procedures.
- Analyze legacy application functionality to identify business logic, dependencies, gaps, and inconsistencies.
- Review Oracle SQL/PL/SQL code, including packages, procedures, functions, triggers, and views, to understand existing application logic.
- Analyze existing Crystal Reports and document report logic, calculations, data sources, and business rules to support migration to a modern reporting platform.
- Document core application modules, including offender records, classification, sentence computation, programs, alerts, movement, disciplinary actions, grievances, and community corrections.
- Work with technical teams to validate source-to-target data mappings and ensure data accuracy and completeness.
- Translate business needs and existing system functionality into functional requirements, user stories, acceptance criteria, and process documentation.
- Identify gaps between legacy functionality and the redesigned application and ensure critical business rules are accurately represented.
- Support System Integration Testing (SIT) and User Acceptance Testing (UAT).
- Validate migrated functionality against the legacy system, identify defects, and coordinate their resolution.
- Participate in requirements walkthroughs, design reviews, and system modernization discussions.
- Collaborate with business users, technical teams, and third-party vendors to support successful system migration.
Required Qualifications
Candidates must demonstrate experience in the following areas:
- Business Analysis: Gathering, analyzing, validating, and documenting business and functional requirements.
- Legacy System Analysis: Reviewing existing application functionality, business rules, workflows, technical documentation, and Standard Operating Procedures (SOPs).
- SQL: Working knowledge of SQL queries, joins, data relationships, and stored procedure logic.
- Microsoft Excel: Strong skills in PivotTables, Pivot Charts, data analysis, and data validation.
- Functional Documentation: Preparing functional requirements, user stories, acceptance criteria, process documentation, and business rules.
- Data Analysis and Validation: Reviewing data relationships, validating source-to-target mappings, and ensuring data accuracy and completeness.
- Testing and Validation: Supporting SIT, UAT, functional validation, and defect identification and documentation.
- Analytical Problem-Solving: Identifying gaps, inconsistencies, dependencies, and opportunities to improve existing application functionality.
- Communication and Collaboration: Working effectively with business stakeholders, technical teams, and external vendors to translate business needs into technical solutions.
Preferred Qualifications
Experience in one or more of the following areas is preferred:
- Oracle PL/SQL: Familiarity with procedures, functions, triggers, packages, and views.
- AWS: Experience with AWS database services and cloud-based reporting solutions.
- Reporting Tools: Experience with Crystal Reports, Microsoft Power BI, or AWS QuickSight.
- Offender Management Systems: Experience with corrections, offender management, criminal justice, or enterprise justice applications.
- Legacy Technologies: Familiarity with DHTML-based applications and legacy web technologies.
- Data Migration and Modernization: Experience supporting legacy application migration, data mapping, and functional validation.
- Vendor Coordination: Experience collaborating with third-party vendors on enterprise application modernization projects.