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.
• 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 to support HHS 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.

Qualifications

• 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 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.
• 5 years preferred experience in a complex data analysis, senior business/systems analyst, and/or data liaison role.
• 5 years preferred 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.
• 2 years preferred Experience championing data literacy across the organization by developing and conducting training sessions for non-technical staff.
• 2 years preferred Experience training and mentoring staff with varying levels of data literacy.
• 1 year preferred Experience with creating AI prompt catalogs using tools such as Streamlit with Python.
• 1 year preferred Experience applying responsible AI practices and compliance with agency standards.