| Location | CO |
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
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 complex data conversion or modernization initiatives