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

Company Overview RESPEC is 100% employee‑owned, taking ownership of every challenge. Since 1969, we’ve tackled complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability. Job Description 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 serves as the vital bridge between complex Medicaid program operations and technical data solutions. The analyst will ensure that the Performance Management & Analytics System (PMAS) provides the insights necessary for strategic decision‑making and assist the agency in navigating the emerging landscape of AI‑enabled reporting. Responsibilities Lead the lifecycle of reporting and analytics initiatives, 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 Agile and Waterfall environments, creating comprehensive test plans 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 for executive leadership. Develop reusable AI prompt libraries, validate AI‑generated outputs, and support responsible AI practices. Mentor business users to improve data literacy and present technical findings to non‑technical audiences. Required Technical Experience 10+ years of experience gathering business requirements and translating complex operational requests into technical specifications. Experience 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. Collaboration with business users and developers to create enterprise‑level reports, dashboards, and visualizations. Proficiency in modern BI tools, specifically Power BI and/or Tableau. Technical communication, with a proven track record of presenting data findings to executive stakeholders. Preferred Qualifications 5+ years in business intelligence/data warehouse environments within healthcare, Medicaid, or health and human services. Experience implementing data quality standards and governance frameworks. Experience developing and delivering technical training or mentoring staff on data literacy. Hands‑on experience building AI prompt catalogs and applying responsible AI practices in a government or enterprise setting. Work Model Location: 4601 W. Guadalupe Street, Austin, Texas 78751. Schedule: Monday through Friday, 8:00 AM – 5:00 PM CT. Client policy: Agency may occasionally authorize 100% remote work at their discretion; candidates must be local to Texas and available to work on‑site as required. EEO Statement All your information will be kept confidential according to EEO guidelines. #J-18808-Ljbffr RESPEC