W2 Role || Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+11 more
Job description
The selected Business Analysts will be responsible for:
- Reviewing existing application architecture, data models and workflows.
- Analyzing legacy application functionality and documenting business rules.
- Reviewing Oracle SQL and PL/SQL code, including procedures, functions, triggers and packages.
- Reviewing Crystal Reports and documenting report calculations and data sources.
- Documenting core application modules, including:
- Offender records.
- Sentence computation.
- Classification.
- Programs and alerts.
- Movement and disciplinary.
- Grievances.
- Community Corrections accounting and supervision.
- Validating source-to-target data mapping.
- Preparing functional requirements, user stories and acceptance criteria.
- Supporting System Integration Testing (SIT) and User Acceptance Testing (UAT).
- Identifying defects and validating migrated functionality against the legacy system.
Requirements
-
7-10 years of overall IT experience.
-
At least 5 years of Business Analyst experience.
-
Strong Oracle SQL and PL/SQL expertise.
-
Experience with application modernization or legacy system migration.
-
Strong documentation, Excel and data validation skills.
-
Experience coordinating with technical teams and external vendors.
Three aspects are particularly important when identifying suitable candidates:
- Strong SQL/PLSQL background: Candidates should be comfortable reading and understanding existing Oracle code, stored procedures and database logic. Merely having experience gathering business requirements may not be sufficient.
- Legacy application migration experience: Experience in documenting existing functionality and translating it into requirements for a modern cloud-based application will be a significant advantage.
- On-site availability: The Mississippi residency requirement and two-year on-site commitment, This is a technically strong Business Analyst position, rather than a conventional functional BA role.
Skill Experience / Requirement Years of Experience
Business Analyst experience
5+ years
SQL knowledge
Working knowledge
Microsoft Excel
Strong skills, PivotTables, Pivot Charts
SQL/PLSQL programming and code review
7+ years
Oracle PL/SQL
5+ years
Advanced SQL
5+ years
AWS database and reporting services
Experience
Power BI / AWS QuickSight
Familiarity
Offender Management / Justice systems
Experience
Legacy DHTML applications
Familiarity
Vendor-led modernization projects
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦