Senior Business Intelligence Analyst / Test Manager

Total Required Experience in Years: 1215 Years

Mode of Work: 100% Onsite, Austin, Texas

Job Description

Seeking an experienced Senior Business Intelligence Analyst / Test Manager to support enterprise Performance Management, Analytics, and reporting initiatives. The ideal candidate will serve as a senior business/systems analyst responsible for gathering business, technical, and data requirements while leading testing activities for business intelligence and reporting solutions.

The consultant will collaborate closely with business users, IT leadership, data engineers, and analytics teams to develop reporting solutions, validate dashboards, perform complex data analysis, and ensure data quality. This role also requires experience with AI-assisted analytics, responsible AI practices, and mentoring business users on data and AI technologies.

Key Responsibilities

• Gather, analyze, and document business, technical, and data requirements.
• Translate business needs into functional specifications, acceptance criteria, and test plans.
• Develop and execute test strategies, test scenarios, and test cases.
• Perform complex SQL data extraction, validation, and analysis.
• Design, validate, and support Power BI and Tableau dashboards.
• Collaborate with business stakeholders, developers, and data engineers.
• Validate reports, dashboards, KPIs, and operational metrics.
• Perform business intelligence and data warehouse analysis.
• Communicate technical findings and data limitations to non-technical stakeholders.
• Lead User Acceptance Testing (UAT) and reporting validation activities.
• Support data governance and data quality initiatives.
• Develop AI prompts and query strategies for business analytics.
• Validate AI-generated outputs and ensure responsible AI usage.
• Conduct training sessions and mentor users on BI tools, analytics, and AI capabilities.
• Produce technical documentation and reporting artifacts.
  
  

Required Skills

• Business Intelligence
• Business Analysis
• Systems Analysis
• Requirements Gathering
• Test Management
• Test Planning
• Test Case Development
• User Acceptance Testing (UAT)
• SQL
• Advanced SQL
• Data Analysis
• Data Validation
• Power BI
• Tableau
• Dashboard Development
• Dashboard Validation
• Data Visualization
• Reporting Solutions
• Communication Skills
• Stakeholder Management
  
  

Preferred Skills

• Data Warehousing
• Business Intelligence Platforms
• Healthcare Analytics
• Health & Human Services
• Data Governance
• Data Quality
• AI Prompt Engineering
• Streamlit
• Python
• Responsible AI
• Data Literacy Training
• Staff Mentoring
  
  

Required Qualifications

• Minimum 1215 years of overall IT experience.
• Minimum 10 years of experience gathering business requirements and translating complex data requests into actionable solutions.
• Minimum 10 years of experience performing complex data analysis as a Business Intelligence Analyst, Senior Business Analyst, Systems Analyst, or Data Liaison.
• Minimum 10 years of advanced SQL experience.
• Minimum 10 years of experience creating and validating reports, dashboards, and data visualizations.
• Minimum 10 years of experience using Power BI and/or Tableau.
• Excellent communication, presentation, and stakeholder management skills.
• Strong analytical and problem-solving abilities.
  
  

Preferred Qualifications

• Minimum 5 years of experience in Business Intelligence and Data Warehouse environments.
• Minimum 5 years of experience supporting healthcare or similarly regulated industries.
• Minimum 5 years of experience with data governance and data quality initiatives.
• Experience developing and delivering data literacy training for non-technical users.
• Experience mentoring business and technical teams.
• Experience creating AI prompt catalogs using Streamlit and Python.
• Experience implementing Responsible AI practices and governance standards.
  
  

Deliverables

• Business Requirements Documents (BRD)
• Functional Specifications
• Acceptance Criteria
• Test Plans
• Test Scenarios
• Test Cases
• SQL Validation Scripts
• Dashboard Validation Reports
• Power BI & Tableau Reports
• Data Quality Reports
• AI Prompt Catalogs
• Training Materials
• User Documentation
• Status Reports
• Knowledge Transfer Documentation
  
  

Education

• Bachelor's Degree in Computer Science, Information Systems, Business Administration, Data Analytics, or a related field (or equivalent work experience).