Business Analyst

Role: Business Analyst

Duration: long term contract (possible 1 year)

REMOTE: Yes

Must have experience in Court Case Management System.

Job Description

Client is seeking 1 Technical Business Analysts to support the migration of the legacy CATS Case Management System to a new target environment. This role requires a strong mix of business analysis, legacy application analysis, database analysis, technical documentation, SQL/querying, and data migration support.

The ideal candidate will be able to understand both the business functionality and the underlying technical/data model of the existing system. This person must be comfortable working with legacy technologies, analyzing Oracle database structures, and documenting business rules, application behavior, dependencies, and migration requirements with minimal training or direction.

The Technical BA will support the project across all phases, including discovery, analysis, requirements definition, migration, development, testing, validation, and implementation.

Key Responsibilities

Legacy Application Analysis

• Analyze the existing CATS case management application to understand both functional and technical architecture

• Trace business functionality from the user interface through application logic and database processing

• Identify dependencies across:

• application modules

• programs

• screens

• database objects

• batch processes

• reports

• Document assumptions, gaps, risks, constraints, unresolved business issues, and technical issues

• Work effectively in an environment involving legacy/obsolete technologies, including COBOL, Oracle, and related systems

Business Process & Requirements Analysis

• Partner with Court SMEs and stakeholders to understand current business processes supporting:

• Family Law

• Adoptions

• Juvenile Dependency

• Document current-state ("As-Is") processes and system functionality

• Translate legacy system behavior and business rules into clear, testable requirements

• Help define future-state ("To-Be") business processes and requirements

• Ensure requirements are detailed enough to support:

• development

• configuration

• data migration

• integration

• testing

• Create process flows and visual requirements documentation

• Write test cases and support validation efforts

Database Analysis & Data Migration Support

• Analyze the existing Oracle database supporting the CATS application

• Review and document:

• tables

• columns

• relationships

• database objects

• business entity definitions

• Identify data dependencies between system functionality and database structures

• Develop and maintain source-to-target mapping documentation from Oracle to Microsoft SQL Server 2025

• Identify and document:

• data transformation requirements

• cleansing requirements

• conversion rules

• derivation logic

• data quality issues

• migration risks

• Support data reconciliation, validation, and migration acceptance criteria

• Use strong RDBMS querying skills, ideally with MS SQL Server

Agile / Jira Support

• Work within an Agile delivery model
• Translate business and technical requirements into user stories
• Help prioritize backlog items
• Participate in sprint planning and related Agile ceremonies
• Use Jira to track requirements, stories, tasks, and project progress

Required Qualifications

• Approximately 5+ years of experience as a Technical Business Analyst

• Strong experience with:

• legacy application analysis

• business requirements gathering

• technical documentation

• data analysis

• data migration projects

• Solid RDBMS/database querying skills

• Experience analyzing Oracle databases

• Ability to understand and document legacy systems with minimal onboarding

• Strong analytical and critical thinking skills

• Ability to capture requirements visually and clearly

• Experience writing test cases

• Strong communication skills and ability to work directly with SMEs and stakeholders

• Comfortable working independently with limited direction

• Flexible and responsive, including occasional after-hours support if needed

Preferred Qualifications

• Experience with MS SQL Server
• Experience supporting or analyzing COBOL applications
• Experience supporting or analyzing PowerBuilder applications
• Experience in court, justice, government, or case management environments

Experience with complex data conversion or modernization initiatives