Senior Business Systems Analyst - AI, Data Analytics & BI/DW

The Worker will serve as a Senior Business/Systems Analyst gathering business and technical requirements, data requirements, business rules, acceptance criteria, including non-visualization business requirements, and then translating them into test plans, test scenarios, and test cases for a full requirements traceability matrix. The Worker will facilitate integration of technical data sources across departments and agencies. This role empowers staff to effectively develop complex queries, often using AI prompting techniques to access, synthesize, and report accurate data for official reporting and strategic decision-making. The ideal candidate has strong analytical skills, a deep understanding of enterprise programs and data, a strong history of BI/DW development, and exceptional communication abilities to bridge the gap between technical data systems and operational users in the emerging context of AI. Responsibilities Requirements and Testing

• Work with program areas and project sponsor to gather business requirements and translate them into technical specifications.
• Lead as Test Manager by creating test plans and test cases that integrate Agile sprint cycles, epics, and user stories, as well as Waterfall project plans and 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.

AI Prompting and Data Synthesis

• 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 obtain accurate and reliable data.
• Develop a library of standardized prompts and query templates for common reporting needs.

Data Reporting and Visualization

• Extract, integrate, and analyze data from multiple complex internal and external sources to support program needs.
• Collaborate with end users, performance analysts, and IT leaders to create and validate reports, dashboards, and data visualizations for program monitoring and official reporting.
• Provide subject matter expertise on validating AI-generated output, particularly with respect to identifying and mitigating hallucinations.
• Ensure all data outputs adhere to reporting standards, data governance, and compliance regulations.

Data Literacy and Training

• 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 employees to effectively utilize data and AI.

Collaboration and Problem-Solving

• Work closely with Data Engineering, IT, and Program teams to troubleshoot data-related issues, address inconsistencies, and develop 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.

• 10+ years of experience gathering business requirements and translating complex data requests and operational requirements into clear, actionable queries for complex analytics data sources.
• 10+ years of experience explaining technical findings and data limitations in simple, non-technical language to end users.
• 10+ years of experience in complex data analysis, Senior Business/Systems Analyst, and/or Data Liaison roles.
• 10+ years of strong experience with SQL for data extraction and manipulation.
• 10+ years of experience collaborating with end users, performance analysts, and IT leaders to create and validate reports, dashboards, and data visualizations for program monitoring and official reporting.
• 10+ years of excellent communication, presentation, and interpersonal skills.
• 10+ years of experience using data visualization tools such as Power BI and/or Tableau., * 5+ years of experience with Business Intelligence (BI) and Data Warehouse (DW) environments.
• 5+ years of experience working in a healthcare, health and human services, or similarly regulated environment with a strong understanding of program data and reporting requirements.
• 5+ years of experience with data governance and data quality principles.
• 2+ years of experience championing data literacy across the organization by developing and conducting training sessions for non-technical staff.
• 2+ years of experience training and mentoring staff with varying levels of data literacy.
• 1+ year of experience creating AI prompt catalogs using tools such as Streamlit with Python.
• 1+ year of experience applying responsible AI practices and ensuring compliance with organizational or agency standards.