Senior Technical Business Analyst – Legacy Modernization
$145,600–$166,400 year
On-siteBrooklyn, New York, United States
Job Summary
Conduct forensic-level analysis of the ACCIS legacy platform, including undocumented PowerBuilder code, embedded business rules, and historical payment calculations. Reconstruct implicit system behavior by analyzing source code, database schemas, triggers, and stored procedures to produce exhaustive functional and technical documentation. Independently create, modify, and debug SQL queries, database objects, and modernization components to ensure exact functional parity with legacy logic while translating regulatory requirements into system-enforceable rules. Design test scenarios and acceptance criteria to validate high-risk scenarios involving financial disbursements and eligibility recalculations, ensuring zero disruption to childcare subsidy payments. Balance competing directives to modernize functionality while maintaining backward compatibility and strict regulatory compliance.
Required Qualifications
- 100% on-site
- Minimum of 6+ years of hands-on experience specifically with PowerBuilder (client/server, object-oriented, event-driven), including direct source code modification and debugging
- Minimum of 6+ years of experience working with IBM Informix databases, including SQL optimization, schema analysis, stored procedures, triggers, and batch processing
- Demonstrated experience interpreting legacy financial, eligibility, and payment logic embedded directly in application code rather than configuration
- Minimum of 6+ years of specialized experience working with subsidized childcare systems or closely related public assistance programs at the municipal or state government level
- Direct experience with eligibility determination, provider payments, enrollment management, audits, and regulatory compliance
- Minimum of 5+ years of hands-on experience developing or modifying .NET Core services
- Minimum of 5+ years of experience with REST API design, documentation, and testing
- Minimum of 4+ years of experience with Angular and modern JavaScript frameworks
- Minimum of 4+ years of experience with IBM MQ and IBM Broker or equivalent enterprise messaging platforms
- Demonstrated experience documenting and validating asynchronous, event-driven integrations
- Minimum of 6+ years of experience using JIRA and Azure DevOps for requirements management, defect tracking, and release coordination
- Expert-level proficiency with Balsamiq, MS Visio, MS Excel, MS Word, and Adobe Pro
- Hands-on experience with API testing tools such as Postman
- Minimum of 6+ years of experience simultaneously performing business analysis, technical analysis, development support, testing coordination, and stakeholder management within the same role
- Proven ability to operate without clear role boundaries in high-risk, compliance-driven environments
- Minimum of 5+ years of experience designing data models, performing detailed data mapping from legacy systems, and creating functional and technical prototypes that accurately represent both current and future states
Desired Qualifications
- Prior experience working on the ACCIS system or an equivalent legacy childcare subsidy platform
- Demonstrated ability to operate with minimal documentation, limited SME availability, and incomplete historical records
- Proven success in environments with zero tolerance for payment errors, regulatory violations, or production outages
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.