Business Intelligence Analyst

Overview

JOB TITLE: Business Intelligence Analyst

CAYUSE COMPANY: Cayuse Civil Services, LLC

LOCATION: Austin, TX - HYBRID

PAY RATE: $45.00-$64.00 per hour

EMPLOYEE TYPE: Temporary Full-Time Hourly Non-Exempt

Employment in this role is conditional upon successful execution of the contract by the client.

The current period of performance is scheduled to end on August 31, 2027; however, the client retains the unilateral right to extend the contract beyond this date by exercising one or more option periods, subject to the terms, conditions, and funding provisions of the awarded contract.

The Work

The Business Intelligence Analyst is responsible for gathering and documenting business and technical requirements, including detailed data requirements, business rules, acceptance criteria, and non‑visualization business needs. The Analyst will translate these requirements into comprehensive test plans, test scenarios, and test cases, ensuring full requirements traceability across the solution lifecycle.

This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables.

Key Responsibilities

• Lead requirements elicitation sessions with program areas, business owners, and project sponsors to gather, analyze, and document business, functional, and technical requirements.
• Translate complex business and operational needs into detailed technical specifications and data requirements suitable for BI, data warehouse, and analytics solutions.
• Define and document data requirements, data mappings, transformation rules, and business rules necessary to support reporting and analytics use cases.
• Develop and maintain comprehensive acceptance criteria, including non‑visualization requirements (e.g., data quality thresholds, performance criteria, security and access requirements).
• Serve as Test Manager for BI and analytics initiatives, creating and maintaining test plans, test scenarios, and test cases that provide full coverage of requirements.
• Ensure test assets are traceable to requirements, epics, user stories, and project artifacts, supporting a full Requirements Traceability Matrix (RTM) across Agile and Waterfall methodologies.
• Coordinate and execute system, integration, regression, and user acceptance testing (UAT) for reporting and analytics solutions, documenting results and tracking defects to resolution.
• Partner with project managers and technical teams to integrate testing activities into Agile sprints, epics, and stories, as well as traditional Waterfall project plans.
• Design, develop, and refine effective AI prompts and query strategies to retrieve, synthesize, and summarize data accurately from complex, multi‑source datasets.
• Translate complex data requests and operational questions into clear, structured prompts and queries that AI tools and advanced analytics platforms can interpret effectively.
• Guide non‑technical users in crafting precise AI prompts and queries to obtain accurate, relevant data for their reporting and decision‑making needs.
• Develop and maintain a catalog/library of standardized prompts, query templates, and usage patterns for common reporting and analytic scenarios.
• Collaborate with data science, AI, and engineering teams to improve models, prompts, and workflows that support responsible AI‑enabled analytics.
• Extract, integrate, and analyze data from diverse internal and external sources to support program operations, performance monitoring, and strategic initiatives.
• Work closely with end‑users, performance analysts, and IT leadership to design, validate, and optimize reports, dashboards, and visualizations for program monitoring, compliance, and official reporting.
• Apply advanced SQL and BI tool capabilities to develop complex queries, calculations, and metrics that align with program policies and business rules.
• Provide subject matter expertise in reviewing and validating AI‑generated output, including identifying and mitigating AI hallucinations, inaccuracies, and misinterpretations.
• Ensure all reporting and…