Business Intelligence Analyst

Responsibilities

• Work with program areas and project sponsors to gather business requirements and translate into technical specifications.
• Lead as Test Manager, creating test plans and test cases that integrate from Agile sprint cycles, epics and stories, as well as Waterfall project plans and all project artifacts.
• Translate complex data requests and operational requirements into clear, actionable queries for AI 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 get the data they need, ensuring fidelity and accuracy.
• Create a library of standardized prompts and query templates for common reporting needs.
• Extract, integrate, and analyze data from multiple complex internal and external sources to support program needs.
• Collaborate with end-users and performance analysts or IT internal leaders to create and validate reports, dashboards, and data visualizations for program monitoring and official reporting.
• Provide subject matter expertise on validating output from AI, particularly with respect to identifying and mitigating hallucinations.
• Ensure all data outputs adhere to agency reporting standards, data governance, and compliance regulations.
• Champion data literacy across the organization by developing and conducting AI training sessions for non-technical staff.
• Create clear, comprehensive documentation and tutorials on using AI tools for data synthesis.
• Promote a data-driven culture by enabling and empowering all employees to effectively utilize data and AI.
• Work closely with data engineering, IT, and Program teams to troubleshoot data-related issues and address inconsistencies and mitigation strategies.
• Provide expert guidance to program staff on interpreting data trends and answering complex data questions.
• Stay up to date on new AI and data analytics tools and techniques to continuously improve data access, data quality, and reporting.

Requirements

• 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 internal 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 (10 years required).
• Experience working in a health and human services or similarly regulated environment, with a strong understanding of program data and reporting requirements (5 years preferred).
• Experience with data governance and data quality principles (5 years preferred).
• Experience with creating AI prompt catalogs using tools such as Streamlit with Python (2 years preferred).
• Experience applying responsible AI practices and compliance with agency standards (2 years preferred).