Business Analyst - HHSC, Austin
Pedigo Staffing Services
•
Austin, TX
0
0
0
0
Not Applicable
Posted March 26, 2026
Job link
Thinking about this job
Responsibilities
Commitments
Responsibilities
- Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc.
- The contractor will serve as the Business Analyst, providing structured requirements gathering, documentation, gap analysis, validation, and testing support.
- The contractor will be responsible for coordinating and leading any requirements gathering meetings with CQC staff.
- The project involves collaboration with the Senior Systems Advisor, who will be responsible for system design and development.
- Data structures will change, requiring a strategy for blending historical Excel based data with new Jotform-based data.
- A redesigned PowerBI dashboard will be built by the Senior Systems Advisor.
- The project includes redesigning forms, restructuring workflow logic, supporting reporting redesign, and ensuring legacy and new data can coexist for unified analytics.
- The Business Analyst (BA) performs business analysis work to support the Compliance and Quality Control Division’s Solicitation Review System’s re-write project.
- This role partners with business owners throughout product planning, requirements definition, and delivery cycles.
- Responsibilities include analyzing complex technical and business processes, identifying efficiencies, and prioritizing needs.
- The BA coordinates the gathering, development, documentation, and verification (testing) of requirements and works under limited supervision with considerable latitude for initiative and independent judgment.
- Elicit and document business requirements for the existing Solicitation Review System, ensuring accuracy and effective communication with stakeholders and the development team.
- Responsible for coordinating, scheduling, and leading all requirements-gathering meetings. (40%)
- Conduct gap analysis of existing system functionality against desired system functionality for the Solicitation Review System, including workflows and reporting through PowerBI. (20%)
- Collaborate daily with the Senior Systems Advisor to track the development and implementation of requirements and test new and existing system functionality for adherence to business requirements for the Solicitation Review System.
- Update and maintain requirements documentation throughout the life of the project. (30%)
- Report weekly to the Director of Contract Compliance Unit regarding progress, potential issues, and overall status. (10%)
- Requirements Documentation Package – Solicitation Review System (SRS)
- A comprehensive set of documents capturing the current state, future-state needs, functional specifications, and reporting requirements for the new Jotform based Solicitation Review System.
- The documentation must be sharing with the Senior Systems Advisor as it is being developed.
- The Senior Systems Advisor will work on development as the requirements are gathered to ensure timeliness of the project.
- This package must include the following Deliverables:
- Process maps of existing workflows (from Microsoft Forms to PowerAutomate to Excel to PowerBI).
- Field inventory documenting all data fields used across Forms, Excel files, PowerAutomate flows, email templates, and PDF outputs.
- User roles and permissions, including who submits, reviews, approves, and receives communications.
- Catalog of notifications, triggers, and automated actions in the current PowerAutomate setup.
- E-mail Templates used for automated system e-mails.
- Draft shared throughout development of Deliverable, completed version due 22 Business Days following Contract Execution.
- PDF generation requirements (content, formatting, data fields, branding).
- Data capture requirements, including revised field definitions.
- Requirements traceability matrix, which must link business needs to functional requirements to test cases.
- Updated e-mail templates for automated system e-mails.
- Draft shared throughout development of Deliverable, completed version due 15 Business Days following completion of Deliverable 1.1.
- 1.3 Reporting Requirements, which must include a clear definition of:
- Required metrics, KPIs, filters, and drill-downs.
- Required alignment rules between legacy Excel data and new Jotform submissions.
- Data transformation and mapping specifications.
- Data quality rules and business logic.
- Draft shared throughout development of Deliverable, completed version due 5 Business Days following completion of Deliverable 1.2
- Gap Analysis & Recommendation Report
- A structured analysis comparing current vs. future needs and identifying what must be changed or built.
- 2.1 Gap Identification, Which Must Include
- Workflow discrepancies (e.g., PowerAutomate actions that must be replicated or redesigned in Jotform).
- Reporting gaps between current and desired PowerBI capabilities.
- Due 5 Business Days following completion of Deliverable 1.2.
- 2.2 Recommendations, Which Must Include
- Suggested workflow improvements.
- Recommended approach for combining legacy AND new data in PowerBI.
- Due 5 Business Days following completion of Deliverable 1.2.
- These deliverables are required to support the Senior Systems Advisor during development:
- Submitted weekly, and immediately following any updates, to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2.
- 3.2 Weekly Collaboration Artifacts, Which Must Include
Commitments
Guadalupe Street Austin, Texas 78701
Telework Policy: telework, but may go to the office from time-to-time
Duration: On-going, no ending date
Draft shared throughout development of Deliverable, completed version due 15 Business Days following completion of Deliverable 1.1.
Draft shared throughout development of Deliverable, completed version due 5 Business Days following completion of Deliverable 1.2
Process pain points identified during interviews.
Due 5 Business Days following completion of Deliverable 1.2.
2.2 Recommendations, Which Must Include
Required form modifications.
Suggested workflow improvements.
Due 5 Business Days following completion of Deliverable 1.2.
These deliverables are required to support the Senior Systems Advisor during development:
3.1 Requirements Change Log, which is a running, version-controlled log that must document:
Modified requirements
Requirements removed or deferred
Stakeholder approvals
Submitted weekly, and immediately following any updates, to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2.
3.2 Weekly Collaboration Artifacts, Which Must Include
Meeting summaries
Submitted weekly to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2 until Contract termination.
Submitted to the Director of Contract Compliance and Senior Systems Advisor 5 Business Days prior to Contract termination.
Testing Assets & Validation Deliverables
4.1 Master Test Plan, which must define the approach for validating both systems, including:
Due 20 Business Days following completion of Deliverable 2.1 & 2.2
4.2 Test Cases & Scripts, which must validate all requirements including:
Not Met Priorities
What still needs stronger evidence
Requirements
- Visa: Must be US Citizen, Green Card, EAD.
- No H1B
- Reviews, analyzes, and evaluates business systems and user needs.
- Formulates systems to parallel overall business strategies.
- Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective.
- Familiar with industry standard business process mapping, and reengineering.
- Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc.
- Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.
- Microsoft Forms for data entry
- Excel files as the underlying data store
- PowerBI dashboards for data visualization
- Knowledge of BABOK Guide principles, including elicitation, requirements analysis, and validation.
- Knowledge of gap analysis methodologies—comparing current state vs. desired state and identifying missing capabilities.
- Knowledge of the capabilities and limitations of computer systems or management information systems.
- Knowledge of process or systems analysis and design work.
- Knowledge of the Software Development Lifecycle (SDLC)
- Skill in defining all types of requirements, functional specifications, and other deliverables.
- Skill in policy interpretation and translating regulations into system requirements.
- Skill in requirements elicitation techniques such as techniques such as interviews, workshops, document analysis, observation, and surveys.
- Skill in working collaboratively and cooperatively with colleagues and in building consensus.
- Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel in governmental entities.
- Skill in troubleshooting, performance tuning, and problem-solving.
- Skill in verbal, written, and presentation communication.
- Skill in Microsoft Excel.
- Ability to create clear, complete, and actionable requirements documentation.
- Ability to build consensus across multiple teams.
- Ability to ensure accuracy in documenting system functionality and regulatory requirements.
- Ability to identify compliance gaps and propose feasible solutions.
- Ability to adapt effectively to evolving regulations and system complexities.
- Ability to build trust and maintain relationships across technical and business teams.
- Process maps of existing workflows (from Microsoft Forms to PowerAutomate to Excel to PowerBI).
- Required form logic, branching, validation, and conditional workflow steps.
- PDF generation requirements (content, formatting, data fields, branding).
- Data capture requirements, including revised field definitions.
- Requirements traceability matrix, which must link business needs to functional requirements to test cases.
- Required alignment rules between legacy Excel data and new Jotform submissions.
- Data transformation and mapping specifications.
Preferred Skills
- PowerBI dashboards for data visualization
Working Title: Business Analyst/Consultant
Agency: Texas Health and Human Services Commission
Solicitation Reference Number:529601612
Location: 4601 W. Guadalupe Street Austin, Texas 78701
Telework Policy: telework, but may go to the office from time-to-time
Duration: On-going, no ending date
Visa: Must be US Citizen, Green Card, EAD. No H1B
Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. Familiar with industry standard business process mapping, and reengineering. Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc. Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.
The Compliance and Quality Control (CQC) Division is undertaking a project involving transforming the existing Solicitation Review System from its current architecture—built using Microsoft PowerAutomate, Microsoft Forms, Excel-based data storage, and PowerBI visualizations—into a redesigned workflow and data management system built on Jotform.
The contractor will serve as the Business Analyst, providing structured requirements gathering, documentation, gap analysis, validation, and testing support. The contractor will be responsible for coordinating and leading any requirements gathering meetings with CQC staff. The project involves collaboration with the Senior Systems Advisor, who will be responsible for system design and development.
The Current Solicitation Review System Uses
Microsoft Forms for data entry
PowerAutomate for workflow automation, email generation, and PDF creation
Excel files as the underlying data store
PowerBI dashboards for data visualization
The system must be migrated to Jotform, which will replace Microsoft Forms and PowerAutomate as the workflow, email, and PDF generation platform. Data structures will change, requiring a strategy for blending historical Excel based data with new Jotform-based data. A redesigned PowerBI dashboard will be built by the Senior Systems Advisor.
The project includes redesigning forms, restructuring workflow logic, supporting reporting redesign, and ensuring legacy and new data can coexist for unified analytics.
Job Description
The Business Analyst (BA) performs business analysis work to support the Compliance and Quality Control Division’s Solicitation Review System’s re-write project. This role partners with business owners throughout product planning, requirements definition, and delivery cycles. Responsibilities include analyzing complex technical and business processes, identifying efficiencies, and prioritizing needs. The BA coordinates the gathering, development, documentation, and verification (testing) of requirements and works under limited supervision with considerable latitude for initiative and independent judgment.
Essential Job Functions
Elicit and document business requirements for the existing Solicitation Review System, ensuring accuracy and effective communication with stakeholders and the development team. Responsible for coordinating, scheduling, and leading all requirements-gathering meetings. (40%)
Conduct gap analysis of existing system functionality against desired system functionality for the Solicitation Review System, including workflows and reporting through PowerBI. (20%)
Collaborate daily with the Senior Systems Advisor to track the development and implementation of requirements and test new and existing system functionality for adherence to business requirements for the Solicitation Review System. Update and maintain requirements documentation throughout the life of the project. (30%)
Report weekly to the Director of Contract Compliance Unit regarding progress, potential issues, and overall status. (10%)
KNOWLEDGE, SKILLS And ABILITIES
Knowledge of BABOK Guide principles, including elicitation, requirements analysis, and validation.
Knowledge of gap analysis methodologies—comparing current state vs. desired state and identifying missing capabilities.
Knowledge of the capabilities and limitations of computer systems or management information systems.
Knowledge of process or systems analysis and design work.
Knowledge of the Software Development Lifecycle (SDLC)
Skill in defining all types of requirements, functional specifications, and other deliverables.
Skill in policy interpretation and translating regulations into system requirements.
Skill in requirements elicitation techniques such as techniques such as interviews, workshops, document analysis, observation, and surveys.
Skill in working collaboratively and cooperatively with colleagues and in building consensus.
Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel in governmental entities.
Skill in troubleshooting, performance tuning, and problem-solving.
Skill in verbal, written, and presentation communication.
Skill in Microsoft Excel.
Ability to create clear, complete, and actionable requirements documentation.
Ability to build consensus across multiple teams.
Ability to ensure accuracy in documenting system functionality and regulatory requirements.
Ability to identify compliance gaps and propose feasible solutions.
Ability to adapt effectively to evolving regulations and system complexities.
Ability to build trust and maintain relationships across technical and business teams.
DELIVERABLE REQUIREMENTS
Requirements Documentation Package – Solicitation Review System (SRS)
1.1 Current-State Documentation, Including
A comprehensive set of documents capturing the current state, future-state needs, functional specifications, and reporting requirements for the new Jotform based Solicitation Review System. The documentation must be sharing with the Senior Systems Advisor as it is being developed. The Senior Systems Advisor will work on development as the requirements are gathered to ensure timeliness of the project. This package must include the following Deliverables:
Process maps of existing workflows (from Microsoft Forms to PowerAutomate to Excel to PowerBI).
Field inventory documenting all data fields used across Forms, Excel files, PowerAutomate flows, email templates, and PDF outputs.
User roles and permissions, including who submits, reviews, approves, and receives communications.
Catalog of notifications, triggers, and automated actions in the current PowerAutomate setup.
E-mail Templates used for automated system e-mails.
Draft shared throughout development of Deliverable, completed version due 22 Business Days following Contract Execution.
1.2 Future-State Requirements
Functional Requirements Document, which must include:
Step-by-step workflow description for each stage of the Solicitation Review process.
Required form logic, branching, validation, and conditional workflow steps.
Email triggers, recipients, templates, timing, and conditions.
PDF generation requirements (content, formatting, data fields, branding).
Data capture requirements, including revised field definitions.
Requirements traceability matrix, which must link business needs to functional requirements to test cases.
Updated e-mail templates for automated system e-mails.
Draft shared throughout development of Deliverable, completed version due 15 Business Days following completion of Deliverable 1.1.
1.3 Reporting Requirements, which must include a clear definition of:
Required metrics, KPIs, filters, and drill-downs.
Required alignment rules between legacy Excel data and new Jotform submissions.
Data transformation and mapping specifications.
Data quality rules and business logic.
Draft shared throughout development of Deliverable, completed version due 5 Business Days following completion of Deliverable 1.2
Gap Analysis & Recommendation Report
A structured analysis comparing current vs. future needs and identifying what must be changed or built. This report includes:
2.1 Gap Identification, Which Must Include
Workflow discrepancies (e.g., PowerAutomate actions that must be replicated or redesigned in Jotform).
Data field gaps between old Excel model and new Jotform model.
Reporting gaps between current and desired PowerBI capabilities.
Process pain points identified during interviews.
Due 5 Business Days following completion of Deliverable 1.2.
2.2 Recommendations, Which Must Include
Proposed solutions for each gap.
Required form modifications.
Suggested workflow improvements.
Risks, assumptions, and dependencies.
Recommended approach for combining legacy AND new data in PowerBI.
Due 5 Business Days following completion of Deliverable 1.2.
Implementation Support & Collaboration Deliverables
These deliverables are required to support the Senior Systems Advisor during development:
3.1 Requirements Change Log, which is a running, version-controlled log that must document:
New requirements
Modified requirements
Requirements removed or deferred
Stakeholder approvals
Submitted weekly, and immediately following any updates, to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2.
3.2 Weekly Collaboration Artifacts, Which Must Include
Meeting summaries
Action items
Clarifications to technical requirements
Submitted weekly to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2 until Contract termination.
3.3 User manual covering the new system for all user roles. Submitted to the Director of Contract Compliance and Senior Systems Advisor 5 Business Days prior to Contract termination.
Testing Assets & Validation Deliverables
4.1 Master Test Plan, which must define the approach for validating both systems, including:
Testing scope
Test methodology
User acceptance testing (UAT) roles
Environments and prerequisites
Due 20 Business Days following completion of Deliverable 2.1 & 2.2
4.2 Test Cases & Scripts, which must validate all requirements including:
Jotform workflow paths
Form field validation
Email triggers and PDF output checks
Data exports
PowerBI logic and metrics
Integration of legacy and new data
Due 20 Business Days following completion of Deliverable 2.1 & 2.2
4.3 Test Execution Results, which is a documented summary that must contain:
Pass/fail results
Issues and severity ratings
Retest outcomes
Verified alignment to requirements
Shared with the Senior Systems Advisor and Director of Contract Compliance, and updated daily, following completion of Deliverable 4.1 & 4.2
Weekly Status Reporting Package, which is a brief, weekly update delivered to the Director via e-mail, and must include:
5.1 Status Summary, Including
Progress on planned milestones
Work completed this week
Work planned for next week
5.2 Issues & Risks Log, Including
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years Required/Preferred Experience
5 Required Business analysis experience, including requirements elicitation and documentation, gap analysis, and testing.
7 Preferred Microsoft Excel
3 Preferred Microsoft PowerBI
3 Preferred Microsoft PowerAutomate
1 Preferred Jotform
III. TERMS OF SERVICE
Services are expected to start 03/02/2026 and are expected to complete by 06/26/2026. Total estimated hours per Candidate shall not exceed 640 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.
IV. WORK HOURS AND LOCATION
Services shall be provided during normal business hours unless otherwise coordinated through the Texas Health and Human Services Commission. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed.
The primary work location(s) will be at 4601 W. Guadalupe Street Austin, Texas 78701. The working position is Telework. Any and all travel, per diem, parking, and/or living expenses shall be at the Candidate's and/or Vendor's expense. Texas Health and Human Services Commission will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts.
The Candidate(s) may be required to work outside the normal business hours on weekends, evenings and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through Texas Health and Human Services Commission.
Debbie Pedigo
CEO / Senior Staffing Consultant
DebbieP@PedigoStaffing.com
512.256.5434
210.401.4501
Pedigo Staffing Services
PedigoStaffing.com
https://www.linkedin.com/company/2735943
Awarded Cooperative Contracts
DIR ITSAC (Department of Information), IT Staffing #DIR-CPO-5738
TIPS (Texas Interlocal Purchasing System), Staffing #230703
TIPS (Texas Interlocal Purchasing System), Technology Services #240101
BuyBoard, Temporary Staffing #774-25
State of Louisiana, IT Staffing #4400029273CW8873
State of Oklahoma, IT Staffing #SW1025
State of Oklahoma, Staffing #0132
Agency: Texas Health and Human Services Commission
Solicitation Reference Number:529601612
Location: 4601 W. Guadalupe Street Austin, Texas 78701
Telework Policy: telework, but may go to the office from time-to-time
Duration: On-going, no ending date
Visa: Must be US Citizen, Green Card, EAD. No H1B
Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. Familiar with industry standard business process mapping, and reengineering. Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc. Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.
The Compliance and Quality Control (CQC) Division is undertaking a project involving transforming the existing Solicitation Review System from its current architecture—built using Microsoft PowerAutomate, Microsoft Forms, Excel-based data storage, and PowerBI visualizations—into a redesigned workflow and data management system built on Jotform.
The contractor will serve as the Business Analyst, providing structured requirements gathering, documentation, gap analysis, validation, and testing support. The contractor will be responsible for coordinating and leading any requirements gathering meetings with CQC staff. The project involves collaboration with the Senior Systems Advisor, who will be responsible for system design and development.
The Current Solicitation Review System Uses
Microsoft Forms for data entry
PowerAutomate for workflow automation, email generation, and PDF creation
Excel files as the underlying data store
PowerBI dashboards for data visualization
The system must be migrated to Jotform, which will replace Microsoft Forms and PowerAutomate as the workflow, email, and PDF generation platform. Data structures will change, requiring a strategy for blending historical Excel based data with new Jotform-based data. A redesigned PowerBI dashboard will be built by the Senior Systems Advisor.
The project includes redesigning forms, restructuring workflow logic, supporting reporting redesign, and ensuring legacy and new data can coexist for unified analytics.
Job Description
The Business Analyst (BA) performs business analysis work to support the Compliance and Quality Control Division’s Solicitation Review System’s re-write project. This role partners with business owners throughout product planning, requirements definition, and delivery cycles. Responsibilities include analyzing complex technical and business processes, identifying efficiencies, and prioritizing needs. The BA coordinates the gathering, development, documentation, and verification (testing) of requirements and works under limited supervision with considerable latitude for initiative and independent judgment.
Essential Job Functions
Elicit and document business requirements for the existing Solicitation Review System, ensuring accuracy and effective communication with stakeholders and the development team. Responsible for coordinating, scheduling, and leading all requirements-gathering meetings. (40%)
Conduct gap analysis of existing system functionality against desired system functionality for the Solicitation Review System, including workflows and reporting through PowerBI. (20%)
Collaborate daily with the Senior Systems Advisor to track the development and implementation of requirements and test new and existing system functionality for adherence to business requirements for the Solicitation Review System. Update and maintain requirements documentation throughout the life of the project. (30%)
Report weekly to the Director of Contract Compliance Unit regarding progress, potential issues, and overall status. (10%)
KNOWLEDGE, SKILLS And ABILITIES
Knowledge of BABOK Guide principles, including elicitation, requirements analysis, and validation.
Knowledge of gap analysis methodologies—comparing current state vs. desired state and identifying missing capabilities.
Knowledge of the capabilities and limitations of computer systems or management information systems.
Knowledge of process or systems analysis and design work.
Knowledge of the Software Development Lifecycle (SDLC)
Skill in defining all types of requirements, functional specifications, and other deliverables.
Skill in policy interpretation and translating regulations into system requirements.
Skill in requirements elicitation techniques such as techniques such as interviews, workshops, document analysis, observation, and surveys.
Skill in working collaboratively and cooperatively with colleagues and in building consensus.
Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel in governmental entities.
Skill in troubleshooting, performance tuning, and problem-solving.
Skill in verbal, written, and presentation communication.
Skill in Microsoft Excel.
Ability to create clear, complete, and actionable requirements documentation.
Ability to build consensus across multiple teams.
Ability to ensure accuracy in documenting system functionality and regulatory requirements.
Ability to identify compliance gaps and propose feasible solutions.
Ability to adapt effectively to evolving regulations and system complexities.
Ability to build trust and maintain relationships across technical and business teams.
DELIVERABLE REQUIREMENTS
Requirements Documentation Package – Solicitation Review System (SRS)
1.1 Current-State Documentation, Including
A comprehensive set of documents capturing the current state, future-state needs, functional specifications, and reporting requirements for the new Jotform based Solicitation Review System. The documentation must be sharing with the Senior Systems Advisor as it is being developed. The Senior Systems Advisor will work on development as the requirements are gathered to ensure timeliness of the project. This package must include the following Deliverables:
Process maps of existing workflows (from Microsoft Forms to PowerAutomate to Excel to PowerBI).
Field inventory documenting all data fields used across Forms, Excel files, PowerAutomate flows, email templates, and PDF outputs.
User roles and permissions, including who submits, reviews, approves, and receives communications.
Catalog of notifications, triggers, and automated actions in the current PowerAutomate setup.
E-mail Templates used for automated system e-mails.
Draft shared throughout development of Deliverable, completed version due 22 Business Days following Contract Execution.
1.2 Future-State Requirements
Functional Requirements Document, which must include:
Step-by-step workflow description for each stage of the Solicitation Review process.
Required form logic, branching, validation, and conditional workflow steps.
Email triggers, recipients, templates, timing, and conditions.
PDF generation requirements (content, formatting, data fields, branding).
Data capture requirements, including revised field definitions.
Requirements traceability matrix, which must link business needs to functional requirements to test cases.
Updated e-mail templates for automated system e-mails.
Draft shared throughout development of Deliverable, completed version due 15 Business Days following completion of Deliverable 1.1.
1.3 Reporting Requirements, which must include a clear definition of:
Required metrics, KPIs, filters, and drill-downs.
Required alignment rules between legacy Excel data and new Jotform submissions.
Data transformation and mapping specifications.
Data quality rules and business logic.
Draft shared throughout development of Deliverable, completed version due 5 Business Days following completion of Deliverable 1.2
Gap Analysis & Recommendation Report
A structured analysis comparing current vs. future needs and identifying what must be changed or built. This report includes:
2.1 Gap Identification, Which Must Include
Workflow discrepancies (e.g., PowerAutomate actions that must be replicated or redesigned in Jotform).
Data field gaps between old Excel model and new Jotform model.
Reporting gaps between current and desired PowerBI capabilities.
Process pain points identified during interviews.
Due 5 Business Days following completion of Deliverable 1.2.
2.2 Recommendations, Which Must Include
Proposed solutions for each gap.
Required form modifications.
Suggested workflow improvements.
Risks, assumptions, and dependencies.
Recommended approach for combining legacy AND new data in PowerBI.
Due 5 Business Days following completion of Deliverable 1.2.
Implementation Support & Collaboration Deliverables
These deliverables are required to support the Senior Systems Advisor during development:
3.1 Requirements Change Log, which is a running, version-controlled log that must document:
New requirements
Modified requirements
Requirements removed or deferred
Stakeholder approvals
Submitted weekly, and immediately following any updates, to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2.
3.2 Weekly Collaboration Artifacts, Which Must Include
Meeting summaries
Action items
Clarifications to technical requirements
Submitted weekly to Senior Systems Advisor following completion of Deliverable 2.1 & 2.2 until Contract termination.
3.3 User manual covering the new system for all user roles. Submitted to the Director of Contract Compliance and Senior Systems Advisor 5 Business Days prior to Contract termination.
Testing Assets & Validation Deliverables
4.1 Master Test Plan, which must define the approach for validating both systems, including:
Testing scope
Test methodology
User acceptance testing (UAT) roles
Environments and prerequisites
Due 20 Business Days following completion of Deliverable 2.1 & 2.2
4.2 Test Cases & Scripts, which must validate all requirements including:
Jotform workflow paths
Form field validation
Email triggers and PDF output checks
Data exports
PowerBI logic and metrics
Integration of legacy and new data
Due 20 Business Days following completion of Deliverable 2.1 & 2.2
4.3 Test Execution Results, which is a documented summary that must contain:
Pass/fail results
Issues and severity ratings
Retest outcomes
Verified alignment to requirements
Shared with the Senior Systems Advisor and Director of Contract Compliance, and updated daily, following completion of Deliverable 4.1 & 4.2
Weekly Status Reporting Package, which is a brief, weekly update delivered to the Director via e-mail, and must include:
5.1 Status Summary, Including
Progress on planned milestones
Work completed this week
Work planned for next week
5.2 Issues & Risks Log, Including
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years Required/Preferred Experience
5 Required Business analysis experience, including requirements elicitation and documentation, gap analysis, and testing.
7 Preferred Microsoft Excel
3 Preferred Microsoft PowerBI
3 Preferred Microsoft PowerAutomate
1 Preferred Jotform
III. TERMS OF SERVICE
Services are expected to start 03/02/2026 and are expected to complete by 06/26/2026. Total estimated hours per Candidate shall not exceed 640 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.
IV. WORK HOURS AND LOCATION
Services shall be provided during normal business hours unless otherwise coordinated through the Texas Health and Human Services Commission. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed.
The primary work location(s) will be at 4601 W. Guadalupe Street Austin, Texas 78701. The working position is Telework. Any and all travel, per diem, parking, and/or living expenses shall be at the Candidate's and/or Vendor's expense. Texas Health and Human Services Commission will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts.
The Candidate(s) may be required to work outside the normal business hours on weekends, evenings and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through Texas Health and Human Services Commission.
Debbie Pedigo
CEO / Senior Staffing Consultant
DebbieP@PedigoStaffing.com
512.256.5434
210.401.4501
Pedigo Staffing Services
PedigoStaffing.com
https://www.linkedin.com/company/2735943
Awarded Cooperative Contracts
DIR ITSAC (Department of Information), IT Staffing #DIR-CPO-5738
TIPS (Texas Interlocal Purchasing System), Staffing #230703
TIPS (Texas Interlocal Purchasing System), Technology Services #240101
BuyBoard, Temporary Staffing #774-25
State of Louisiana, IT Staffing #4400029273CW8873
State of Oklahoma, IT Staffing #SW1025
State of Oklahoma, Staffing #0132