Business Analyst ETL background- HHSC, Austin

Working Title:

Business Analyst 2

State Agency:
Texas Health and Human Services Commission

Location:

4601 W. Guadalupe Street Austin, TX 78701
Solicitation Reference Number:
Title/Level: Business Analyst 2
Category:
Applications/Software Development
Telework Policy:
The primary work location will be 4601 W. Guadalupe Street Austin, TX 78701 . Position will be remote. Program will allow candidates who are within the state (Any location within the State of Texas).

• 7 years, Required - Business analysis experience, including requirements elicitation and documentation, gap analysis, and testing.
• 7 years, Preferred - Microsoft Excel
• 5 years, Preferred - PowerBI
• 5 years, Preferred - Power Automate
• 1 years, Preferred - Jotform

4-7 years of experience in the field or in a related area as a senior Business Analyst (Technical). Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. A certain degree of creativity and latitude is required. Works under limited supervision with considerable latitude for the use of initiative and independent judgment.

2+ years of experience as a data analyst analyzing raw data using Excel, Tableau, etc.

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.

** Candidate must have government experience. Candidate must have experience in similar projects as reflected in their job details or project descriptions on their resume.**

** Candidate must be available for in-person interview in Austin, TX.**

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 Power Automate, Microsoft Forms, Excel-based data storage, and Power

BI 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.

• Microsoft Forms for data entry
• Power Automate for workflow automation, email generation, and PDF creation
• Excel files as the underlying data store
• Power
  
  BI dashboards for data visualization

The system must be migrated to Jotform, which will replace Microsoft Forms and Power Automate 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 Power

BI 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…