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%)
• nalyze 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)
• bility to translate regulatory and policy requirements into system solutions
• Strong analytical, problem-solving, and communication skills
• bility 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