Business Intelligence Analyst Specialist

Key Responsibilities

• Gather business, technical, and data requirements from stakeholders.
• Translate business requirements into technical specifications and SQL queries.
• Lead testing efforts, including test plans, test cases, traceability matrices, and user acceptance testing (UAT).
• Analyze large and complex datasets using SQL.
• Create and validate reports, dashboards, and visualizations using Power BI or Tableau.
• Support Medicaid reporting and data curation initiatives.
• Create AI prompts and reusable prompt libraries for reporting and analytics.
• Validate AI-generated outputs and identify inaccuracies or hallucinations.
• Develop documentation, user guides, and training materials.
• Train non-technical users on AI-assisted data analysis and reporting.
• Collaborate with data engineers, developers, business teams, and program stakeholders.
• Ensure compliance with data governance, reporting standards, and regulatory requirements.

Required Qualifications

• 10+ years of Business Intelligence, Business Systems Analysis, or Data Analysis experience.
• 10+ years of experience gathering business and technical requirements.
• 10+ years of experience writing and optimizing SQL queries for data extraction and analysis.
• 10+ years of experience translating complex business requirements into technical solutions.
• 10+ years of experience creating reports, dashboards, and data visualizations.
• Strong experience with Power BI and/or Tableau.
• Experience leading testing activities, including test plans, test cases, and requirements traceability.
• Excellent communication, presentation, and stakeholder management skills.
• Ability to explain technical concepts to non-technical audiences.

Preferred Qualifications

• Experience with Business Intelligence/Data Warehouse environments.
• Experience in healthcare, Medicaid, Health & Human Services, or another highly regulated environment.
• Knowledge of data governance and data quality principles.
• Experience developing and delivering training for non-technical users.
• Experience mentoring users with varying levels of data literacy.
• Experience creating AI prompt libraries using Streamlit and Python.
• Understanding of Responsible AI principles and AI governance.