Senior Business Intelligence Analyst / Test Manager

About the role

The Senior Business Intelligence Analyst / Test Manager will 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.

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.
• 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.

Requirements

• Minimum 12–15 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 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
• Mentoring

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

Qualifications

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