Senior Business Analyst - Data/Database Administration (Contractor) 529701745

RE/SPEC Inc. • Austin, TX

22h • Onsite

About The Position

RESPEC is seeking a highly experienced Business Intelligence Analyst Specialist to support the Texas Health and Human Services Commission (HHSC) on a large-scale enterprise analytics initiative. This role acts as the vital bridge between complex Medicaid program operations and technical data solutions. You will be responsible for ensuring that the Performance Management & Analytics System (PMAS) provides the insights necessary for strategic decision-making while helping the agency navigate the emerging landscape of AI-enabled reporting.

Requirements

• 10+ Years of Professional Experience in: Gathering business requirements and translating complex operational and data requests into technical solution specifications.
• Serving as a Senior Business Analyst, Systems Analyst, or Data Liaison in large-scale enterprise environments.
• Advanced SQL development, including complex data extraction, validation, and manipulation.
• Collaborating directly with business users and developers to create enterprise-level reports, dashboards, and visualizations.
• Utilizing modern BI tools, specifically Power BI and/or Tableau.
• Technical communication, with a proven track record of presenting data findings to executive-level stakeholders.

Nice To Haves

• 5+ years in Business Intelligence/Data Warehouse environments within Healthcare, Medicaid, or Health and Human Services.
• Experience implementing data quality standards and governance frameworks.
• 2+ years of experience developing and delivering technical training or mentoring staff on data literacy.
• Hands-on experience building AI prompt catalogs (using Streamlit/Python) and applying Responsible AI practices in a government or enterprise setting.

Responsibilities

• Lead the lifecycle of reporting and analytics initiatives by serving as the primary liaison between business stakeholders and technical development teams.
• Gather and document functional and technical requirements; translate operational needs into technical specifications and data models.
• Lead testing activities in both Agile and Waterfall environments, including the creation of comprehensive test plans, scenarios, and requirements traceability matrices.
• Write and validate complex SQL queries to extract, manipulate, and analyze data from multiple enterprise sources.
• Design, develop, and validate high-impact reports and dashboards that provide actionable insights to executive leadership.
• Develop reusable AI prompt libraries, validate AI-generated outputs for accuracy, and support the implementation of responsible AI practices.
• Mentor business users to improve organizational data literacy and present technical findings to non-technical audiences in a clear, engaging manner.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed