Business Analyst 2 - HHSC

Working Title: Business Analyst 2 Title/Level: Business Analyst 2 Category: Applications / Software Development Location Austin, Texas (Remote) visa - citizen, GC, EAD H1B need local address proof ________________________________________ I. DESCRIPTION OF SERVICES The Texas Health and Human Services Commission (HHSC) requires the services of one (1) Business Analyst 2 to support the Compliance and Quality Control (CQC) Division in the transformation of the Solicitation Review System (SRS). This position involves analyzing, documenting, and validating business and technical requirements for the migration of the current system—built on Microsoft Forms, PowerAutomate, Excel, and PowerBI—into a redesigned solution using Jotform. The selected candidate will work under limited supervision with considerable latitude for initiative and independent judgment and will collaborate closely with the Senior Systems Advisor and business stakeholders. Note: All deliverables are considered "works made for hire" and remain the property of HHSC. ________________________________________ II. PROJECT OVERVIEW The project focuses on modernizing the existing Solicitation Review System by: • Migrating workflows from Microsoft Forms & PowerAutomate → Jotform • Transitioning Excel-based data storage to structured data models • Supporting redesign of PowerBI reporting dashboards • Ensuring seamless integration of legacy and new data for analytics • Enhancing workflow automation, reporting, and data quality ________________________________________ III. JOB SUMMARY The Business Analyst 2 will: • Lead requirements gathering and stakeholder engagement • Perform gap analysis between current and future system states • Document functional and technical requirements • Support testing, validation, and implementation activities • Ensure alignment between business needs and technical solutions ________________________________________ IV. KEY RESPONSIBILITIES 1. Requirements Gathering & Documentation (40%) • Conduct and lead stakeholder meetings and workshops • Elicit, analyze, and document business and system requirements • Create detailed functional specifications and process documentation 2. Gap Analysis (20%) • Analyze current system workflows, data structures, and reporting • Identify gaps between existing and target systems • Recommend improvements and solutions 3. Collaboration & Testing (30%) • Work closely with Senior Systems Advisor on implementation • Develop and maintain requirements traceability matrix • Support system testing, UAT, and validation activities 4. Reporting & Communication (10%) • Provide weekly status updates to leadership • Track risks, issues, and project progress ________________________________________ V. REQUIRED SKILLS & EXPERIENCE Minimum Requirements • 7+ years of Business Analysis experience • Strong experience in: o Requirements elicitation & documentation o Gap analysis o Testing and validation • Government/Public sector experience (MANDATORY) • Experience working on similar system transformation projects Preferred Skills • Microsoft Excel (Advanced) • PowerBI (5+ years) • PowerAutomate (5+ years) • Jotform (1+ year) • Experience with workflow automation and reporting systems ________________________________________ VI. KNOWLEDGE, SKILLS & ABILITIES • Knowledge of BABOK principles and SDLC methodologies • Strong understanding of business process reengineering • Expertise in requirement gathering techniques (interviews, workshops, surveys) • Ability to translate regulatory and policy requirements into system solutions • Strong analytical, problem-solving, and communication skills • Ability to build consensus across technical and business teams ________________________________________ VII. KEY DELIVERABLES 1. Requirements Documentation Package • Current-state analysis (process maps, data inventory, workflows) • Future-state functional requirements • Reporting and data mapping specifications 2. Gap Analysis & Recommendations • Identification of workflow, data, and reporting gaps • Proposed solutions and risk analysis 3. Implementation Support • Requirements change log • Weekly collaboration artifacts • User manuals 4. Testing & Validation • Master test plan • Test cases and scripts • Test execution reports 5. Weekly Status Reports • Progress updates • Risks and mitigation plans XI. CANDIDATE QUALIFICATIONS SUMMARY Skill Years Required Priority Business Analysis 7 Required Microsoft Excel 7 Preferred PowerBI 5 Preferred PowerAutomate 5 Preferred Jotform 1 Preferred