Senior Business Intelligence Analyst Specialist

Job Title: Business Intelligence Analyst Specialist

Location: Austin, TX

Local Candidates Only – Must currently reside in Texas

The project involves a targeted data curation initiative within the Performance Management & Analytics System (PMAS) to support Medicaid Reporting for Medicaid Personal Care Services.

This project follows an Agile development methodology.

The selected candidate will serve as a Senior Business/Systems Analyst and Test Lead, responsible for gathering business and technical requirements, documenting business rules, acceptance criteria, and translating requirements into comprehensive test plans, test scenarios, test cases, and a full requirements traceability matrix. The consultant will also facilitate the integration of technical data sources while supporting AI-enabled data access, reporting, and analytics initiatives.

Key Responsibilities

Business Analysis & Testing

• Gather business and technical requirements from program stakeholders and project sponsors.

• Translate business requirements into technical specifications.

• Lead testing activities by creating test plans, test cases, and test scenarios across Agile sprint cycles, epics, user stories, and Waterfall projects.

• Develop and maintain complete requirements traceability matrices.

• Translate complex data requests and operational requirements into actionable AI queries against enterprise analytics data sources.

• Communicate technical findings and data limitations in clear, non-technical language to business users.

AI Prompting & Data Synthesis

• Develop and refine AI prompts and query strategies for accurate data retrieval and synthesis.

• Guide non-technical users in creating effective AI prompts.

• Build and maintain standardized AI prompt libraries and reusable query templates.

• Validate AI-generated outputs and identify potential hallucinations or inaccuracies.

Data Reporting & Visualization

• Extract, integrate, and analyze data from multiple complex internal and external data sources.

• Collaborate with business users, performance analysts, and IT teams to develop reports, dashboards, and data visualizations.

• Ensure all reporting complies with agency standards, governance policies, and regulatory requirements.

• Support official reporting and strategic decision-making initiatives.

Data Literacy & Training

• Promote data literacy throughout the organization.

• Develop and deliver AI and data analytics training sessions for non-technical users.

• Create user guides, documentation, and tutorials for AI-assisted reporting.

• Encourage a data-driven culture by enabling effective use of enterprise data and AI tools.

Collaboration & Problem Solving

• Partner with Data Engineering, IT, and Program teams to resolve data quality issues and inconsistencies.

• Provide expert guidance on interpreting complex data and reporting results.

• Stay current with emerging AI technologies, analytics tools, and best practices.

Required Skills & Qualifications

• 10+ years of experience gathering business requirements and translating complex data requests into actionable technical solutions.

• 10+ years of experience explaining technical concepts and data limitations to non-technical stakeholders.

• 10+ years of experience as a Senior Business Analyst, Systems Analyst, Data Analyst, or Data Liaison.

• 10+ years of strong SQL experience for data extraction and manipulation.

• 10+ years of experience developing and validating reports, dashboards, and data visualizations.

• 10+ years of experience working with Power BI and/or Tableau.

• Excellent communication, presentation, analytical, and interpersonal skills.

Preferred Qualifications

• 5+ years of Business Intelligence/Data Warehouse experience.

• 5+ years of experience within Health & Human Services or another highly regulated environment.

• 5+ years of experience with data governance and data quality principles.

• 2+ years of experience developing and delivering data literacy or AI training for non-technical users.

• 2+ years of experience mentoring staff with varying levels of data literacy.

• 1+ year of experience creating AI prompt catalogs using Streamlit with Python.

• 1+ year of experience applying Responsible AI practices and ensuring compliance with agency standards.