Business Intelligence Analyst Specialist

Description Of Services

The Specialist position is rarely selected and should only be considered after all other levels have been exhausted. The Specialist position is considered an expert position that has a comprehensive and authoritative knowledge of or unique skillset in a particular area. The Business Intelligence Analyst uses data to figure out market and business trends for companies to increase profits and efficiency. They may work directly for a company or as a consultant. They are able to extract, integrate, and analyze data from multiple complex internal and external sources.

Responsibilities

• Work with program areas and project sponsors to gather business requirements and translate them into technical specifications.
• Lead as Test Manager creating test plans and test cases that integrate Agile sprint cycles, epics, user stories, Waterfall project plans, and project artifacts.
• Translate complex data requests and operational requirements into clear, actionable AI queries against complex analytics data sources.
• Explain technical findings and data limitations in simple, non-technical language to end users.
• Develop and refine effective AI prompts and query strategies to retrieve and synthesize data accurately from complex datasets.
• Guide non-technical users in crafting precise prompts to retrieve accurate data.
• Develop a library of standardized prompts and query templates for common reporting needs.
• Extract, integrate, and analyze data from multiple complex internal and external sources.
• Collaborate with end users and performance analysts or IT leaders to create and validate reports, dashboards, and data visualizations.
• Validate AI-generated outputs and identify hallucinations.
• Ensure compliance with agency reporting standards, governance, and regulatory requirements.
• Champion data literacy by developing and conducting AI training sessions.
• Create documentation and tutorials for AI tools.
• Promote a data-driven culture across the organization.
• Work closely with Data Engineering, IT, and Program teams to resolve data issues.
• Provide expert guidance on interpreting data trends and analytics.
• Stay current on AI and analytics technologies to improve reporting and data quality.

Requirements

• 10 years Required – Experience gathering business requirements and translating complex data requests and operational requirements into clear, actionable queries for complex analytics data sources.
• 10 years Required – Experience explaining technical findings and data limitations in simple, non-technical language to end users.
• 10 years Required – Experience in a complex data analysis, senior business/systems analyst, and/or data liaison role.
• 10 years Required – Strong experience with SQL for data extraction and manipulation.
• 10 years Required – Experience collaborating with end users and performance analysts or IT leaders to create and validate reports, dashboards, and data visualizations for program monitoring and official reporting.
• 10 years Required – Excellent communication, presentation, and interpersonal skills.
• 10 years Required – Experience with data visualization tools such as Power BI and/or Tableau.
• 5 years Preferred – Experience with Business Intelligence/Data Warehouse.
• 5 years Preferred – Experience working in Health and Human Services or another regulated environment with program data and reporting requirements.
• 5 years Preferred – Experience with data governance and data quality principles.
• 2 years Preferred – Experience championing data literacy through organizational training.
• 2 years Preferred – Experience training and mentoring staff with varying levels of data literacy.
• 1 year Preferred – Experience creating AI prompt catalogs using tools such as Streamlit with Python.
• 1 year Preferred – Experience applying responsible AI practices and compliance with agency standards.