Business Analyst and Test Support

Job Title: Business Analyst and Test Support Duration: 12 months with possible extensions Work Mode: Hybrid (3 days per week) Location: Sacramento, CA 95811 Interview: In-person Job Description The consultant will work with the Enterprise Solutions Development Division and undertake duties as an expert level business analyst and tester on critical system changes. The consultant will lead efforts for enhancing enterprise system(s)/sub-system(s) changes by performing detailed analysis, functional design, and testing activities and support for User Acceptance Testing (UAT) with the program Subject Matter Experts (SMEs). The work primarily involves facilitation and leading of Joint Application Requirements (JAR) and Joint Application Design (JAD) sessions with SMEs from program and technical teams to ensure their requirement needs are being met. This also includes the consultant developing an execution of functional test plans for change requests and defect fixes. The work of the business analyst/tester will also include status reporting, documenting, and maintaining as-is and to-be processes, creating and maintaining system functional documentation and business requirements documents. Responsibilities • Lead analysis and design efforts for enhancing various enterprise system(s) and sub-systems(s). • Facilitate and lead Joint Application Requirements (JAR) and Joint Application Development (JAD) sessions with customer representatives, developers, testers, and other technical staff to ensure the customer s needs are met. • Create and maintain business requirements document, design artifacts and requirements traceability matrix. • Build Power BI Dashboards to support data analysis and business decisions. • Assist test personnel with the development of test scenarios and scripts. • Execute test scenarios and scripts, track, and document defects. • Develop and provide test results for review. • Collaborate with various IT and program area staff to triage defects and issues. • Contractor will provide knowledge transfer of the change requests, associated design documentation and test scripts. • Knowledge transfer to occur via collaborative documentation, code commenting, cross training, and job shadowing. • Knowledge transfer to take place at Client via regular scheduled meetings and review of documentation. • Documentation to include best practices and lessons learned. Minimum Qualifications • Nine (9) years (within the last 12 years) in project work and technical writing to include: detailed analysis, development and maintenance of business requirements, technical requirements, use cases and design documents. • Nine (9) years experience (within the last 12 years) in project work in the Business Progress Reengineering (BPR) arena; at least five (5) years of said experience must have been mapping the current state of a business process and analyzing the business process to find gaps. • Nine (9) years (within the last 12 years) experience in project work in large volume data processing and analysis. • Must have a minimum of seven (7) years (within the last 10 years) of experience in Oracle 11g and 19c writing and troubleshooting SQL code to design back-end queries for data set-up and verification. • Five (5) years (within the last 10 years) experience performing regression test; writing scripts, executing scripts, creating test cases and test data, reviewing test results; also assisting with User Acceptance Testing (UAT). • Seven (7) years (within the last 10 years) experience with Business Intelligence (BI) dashboards and BI reports in Power BI Platform. • Experience with testing of software deployments/components in the cloud (Azure or AWS) • Experience working with public pension systems or experience with Governmental Retirement Benefits and Health Programs functions. Evaluation Criteria • Overall Expertise & Experience • Project Leadership, Decision Management, and Execution • Resource, Schedule, Budget, and Benefit Planning and Optimization • Stakeholder Engagement, Change Management, and Team Collaboration • Progress Communication and Transparency • Risk, Issue, and Progress Management • Innovation and Continuous Improvement