Assyst is seeking a Senior Business Intelligence Analyst to support a client in delivering enterprise Business Intelligence and Data Warehouse solutions within a complex, regulated environment.

Requirements

gathering, SQL, data analytics, testing, and reporting, along with emerging AI-driven data analysis capabilities.

, develop test strategies, create reports and dashboards, and leverage AI-powered data synthesis techniques. The role also requires expertise in data governance, business intelligence, data visualization, and training end users on AI-enabled analytics tools. This is a 100% onsite position.

Only local candidates currently residing in Texas will be considered.

, including business rules and acceptance criteria.

into technical specifications, test plans, test scenarios, test cases, and maintain a comprehensive

Traceability Matrix (RTM). Lead testing activities across Agile and Waterfall projects, ensuring quality throughout the software development lifecycle. Develop complex SQL queries to extract, manipulate, validate, and analyze data from multiple internal and external data sources.

Translate complex operational and data requests into actionable AI prompts and query strategies for analytics and reporting. Design, refine, and maintain standardized AI prompt libraries and reusable query templates for common reporting needs. Collaborate with business users, analysts, and technical teams to create, validate, and enhance reports, dashboards, and data visualizations using Power BI and/or Tableau.

Validate AI-generated outputs, identify potential inaccuracies or hallucinations, and ensure reporting accuracy and compliance. Ensure all reporting solutions adhere to established data governance, data quality, and regulatory compliance standards. Conduct AI and data literacy training sessions for business users with varying levels of technical expertise.

Develop user guides, documentation, tutorials, and best practices for AI-assisted data analysis and reporting. Work closely with data engineering, IT, and business teams to troubleshoot data quality issues and resolve reporting inconsistencies. Provide subject matter expertise in interpreting complex data trends and supporting strategic business decision-making.

Stay current with emerging AI technologies, business intelligence tools, and data analytics best practices to continuously improve reporting capabilities.

and translating them into technical solutions. 12+ years of strong experience as a Senior Business Analyst, Business Systems Analyst, Data Analyst, or Data Liaison in complex enterprise environments. 10+ years of expertise in SQL for complex data extraction, analysis, validation, and manipulation.

10+ years of experience developing test plans, test cases, test scenarios, and supporting Agile and Waterfall testing methodologies. 5+ years of strong background in Business Intelligence and Data Warehouse (BI/DW) environments. 5+ years of hands-on experience with Power BI, Tableau, or similar data visualization platforms.

Experience creating reports, dashboards, and analytical solutions for business and operational reporting. Strong understanding of data governance, data quality, and regulatory compliance principles. Experience working in healthcare, health and human services, or other highly regulated industries.

Experience developing AI prompt catalogs and reusable prompt libraries using tools such as Streamlit with Python.

Responsibilities

Gather, analyze, and document business, technical, and data

Senior Business Intelligence Analyst (AI, Data Warehouse & Healthcare Analytics)