Serve as technical lead and liaison between IT and program staff to gather requirements, build complex SQL queries, develop AI prompts, integrate and validate data, and produce reports and dashboards for HHS monitoring and official reporting. Provide data governance, training, and oversight of AI outputs within an agile team to support agency decision-making.
The Business Intelligence Analyst will support the Texas Health and Human Services Commission (HHSC) on the Performance Management & Analytics System (PMAS) project. This role serves as a technical lead and critical liaison between IT and non-technical program staff, working with complex data sources across Health and Human Services departments and agencies. The analyst will empower HHS staff to develop complex queries, leverage AI prompting techniques, and produce accurate data for official agency reporting and strategic decision-making. The position operates within an agile development team and contributes to the continued development of the HHS data integration hub. All work products resulting from this engagement are considered works made for hire and are the property of HHSC.
Responsibilities
- Gather business requirements from program areas and project sponsors and translate them into technical specifications and actionable data queries.
- Serve as the primary point of contact for program staff with data needs related to federal, state, and internal reporting.
- Develop and refine AI prompts and query strategies to accurately retrieve and synthesize data from complex analytics data sources.
- Guide non-technical users in crafting precise prompts and establish a standardized library of prompt templates for common reporting needs.
- Extract, integrate, and analyze data from multiple internal and external sources to support HHS program monitoring and reporting requirements.
- Collaborate with end-users, performance analysts, and IT leaders to create and validate reports, dashboards, and data visualizations.
- Provide subject matter expertise on validating AI-generated outputs, including identifying and mitigating data hallucinations.
- Ensure all data outputs adhere to agency reporting standards, data governance policies, and compliance regulations.
- Champion data literacy across the organization by developing and conducting AI and data training sessions for non-technical staff.
- Stay current on emerging AI and data analytics tools and techniques to continuously improve data access, quality, and reporting practices.
Requirements
Minimum Qualifications - Candidates must meet ALL minimum qualifications
- 10 years of experience gathering business requirements and translating complex data requests and operational requirements into clear, actionable queries for complex analytics data sources.
- 10 years of experience explaining technical findings and data limitations in simple, non-technical language to end-users.
- 10 years of experience in a complex data analysis, senior business/systems analyst, and/or data liaison role.
- 10 years of strong experience with SQL for data extraction and manipulation.
- 10 years of experience collaborating with end-users and performance analysts or IT internal leaders to create and validate reports, dashboards, and data visualizations for program monitoring and official reporting.
- 10 years of demonstrated excellence in communication, presentation, and interpersonal skills.
- 10 years of experience with data visualization tools such as Power BI and/or Tableau.
Preferred Qualifications
- 5 years of experience leading as a technical project manager creating hybrid Agile sprint cycles, epics and stories, as well as Waterfall project plans and project artifacts.
- 5 years of experience with Business Intelligence and/or Data Warehouse development.
- 5 years of experience acting as the primary point of contact for program staff with data needs for federal, state, and internal reporting.
- 5 years of experience working in a health and human services or similarly regulated environment, with a strong understanding of program data and reporting requirements.
- 5 years of experience applying data governance and data quality principles.
- 2 years of experience championing data literacy across the organization by developing and conducting training sessions for non-technical staff.
- 2 years of experience training and mentoring staff with varying levels of data literacy.
- 1 year of experience creating AI prompt catalogs using tools such as Streamlit with Python.
- 1 year of experience applying responsible AI practices and compliance with agency standards.
Additional Requirements
- Candidates must currently reside within 50 miles of the Austin, Texas work location. Out-of-state candidates or those planning to relocate will not be considered.
- Criminal background check as authorized by Texas law.
- Total estimated hours shall not exceed 2,008 hours for the contract period.
- This engagement may be amended, renewed, and/or extended if both parties agree in writing.
Work Location and Schedule
Location: 4601 W Guadalupe Street, Austin, Texas 78751
Schedule: Monday through Friday, 8:00 AM to 5:00 PM, excluding Texas state holidays
Work Arrangement: Onsite only; no remote work permitted
Similar Jobs
Insurance
Lead gathering complex business requirements and design/implement BI solutions including ETL pipelines, data visualization, and analytics infrastructure. Collaborate with IT on data engineering, enforce governance and standards, prototype dashboards/reports, champion Agile practices, mentor BI team members, and act as a trusted advisor to stakeholders to identify and mitigate data-related risks and deliver actionable insights.
Top Skills:
ETLJIRAMs ProjectMs Sql ServerMySQLPostgresPower BIPythonSsisSsrsTableau
Artificial Intelligence • Semiconductor • Manufacturing
Design, develop, and maintain BI metrics, reports, cubes, and dashboards; extract and analyze financial and operational data; support data warehouse development; ensure report accuracy and confidentiality; train and support end users; assess reporting needs and deliver BI solutions to drive business decisions.
AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
The Senior Data Analyst oversees performance reporting tools, automates data pipelines, conducts quantitative analyses, and communicates findings to various stakeholders.
Top Skills:
Google BigqueryGoogle SuiteMS OfficePythonSQL
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
