Business Analysis Documentation Move Payroll PL/SQL SQL
About the role
CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.Job SummaryAs the Business Analyst - Rules Verification, you will verify civil service rules and write the test oracles (expected-result sets) for key initiatives supporting a state government client.Job DescriptionCAI is hiring! We are looking for a Business Analyst - Rules Verification for a full-time, long-term contract opportunity that is hybrid (3 days/week onsite) in Trenton, NJ. The selected candidate will verify civil service rules and write the test oracles (expected-result sets) for key initiatives supporting the New Jersey Department of Children and Families, including the agency's HR Modernization initiative. You will extract business rules from legacy source code and documentation, trace each rule to its origin, and build expected-result sets from production output that show the new system behaves correctly.Only work authorizations not requiring sponsorship now or in the future will be considered. Local candidates only, please.
Responsibilities
- Civil Service Rule Verification
- Identify and verify the civil service rules that govern titles, eligibility, appointments, promotions, seniority, and personnel actions
- Verify extracted rules against applicable civil service regulations and DCF policy
- Resolve conflicts between legacy code, documentation, and current practice with business owners, and record the outcomes
- Legacy Business Rule Extraction
- Extract business rules from legacy source code, such as stored procedures and batch logic, and from legacy documentation
- Record every rule with traceability to its origin, such as source file, procedure, or document section
- Flag undocumented, conflicting, or obsolete logic for review and decision
- Test Oracle Authorship
- Build expected-result sets from production output to serve as the test oracle for the new system
- Define input and expected-output pairs for standard, boundary, and exception scenarios
- Partner with QA and test automation staff to load expected results into the reconciliation harness
- Write extracted rules in a specification format suitable for machine ingestion
- Maintain the requirements traceability matrix, linking each rule to its origin, specification, and test
- Manage changes to rules through the program's change control process
Requirements
- Required:
- Bachelor's degree from an accredited college or university
- 5+ years of experience in business analysis, including business rule extraction
- Demonstrated ability to extract business rules from legacy source code and legacy documentation, with traceability from each rule to its origin
- Ability to read legacy source code such as SQL, PL/SQL, or comparable languages
- Experience building expected-result sets from production output
- Experience maintaining a requirements traceability matrix
- Ability to write extracted rules in a specification format suitable for machine ingestion
- Working knowledge of SQL for data querying and analysis
- Strong analytical rigor and attention to detail
- Exceptional written and verbal communication skills
- Preferred:
- Experience with civil service, public sector HR, or payroll rules
- Experience with parallel-run or dual-run validation on a modernization effort
- ISTQB or comparable testing certification
- Experience supporting State of New Jersey agencies
- Experience within Human Services, Child Welfare, Public Health, or Social Services programs
- Physical Demands
- Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
- Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
- #LI-JM1
- Reasonable accommodation statement
- If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 - 8111.
- EEO Statement
- It is the policy of Computer Aid, Inc.(CAI) not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or
Health insurance
Additional Information
Business Analyst - Rules VerificationReq number:R8805Employment type:Full timeWorksite flexibility:Hybrid
Your Match
How well this role fits your profile.
Confirmed H-1B sponsor. The Department of Labor record shows filings under COMPUTER AID, INC. .
Filings 420
Approved 91.4%
Avg wage $53K
From public Department of Labor LCA disclosures. Sponsorship history is a signal about the employer, not a commitment on this role.