Business Intelligence Analyst

About the Organization:

The Capital Area Food Bank works to address hunger today and create brighter futures tomorrow for more than a million people across the region experiencing food insecurity. As the anchor in the area’s hunger relief infrastructure, the food bank provided more than 60 million meals to people in need last year, by supplying food to hundreds of nonprofit organizations as well as directly to the community. Creating long-term solutions to food security requires more than just food: it includes addressing the root causes of food insecurity by partnering with organizations that provide critical services like job training programs, health care, and education. To learn more, visit Food Bank for the Washington, DC, Region | Capital Area Food Bank.

Description:

The CAFB is seeking an innovative and data-driven Business Intelligence Analyst to support the Analytics team in maximizing the use of data and information systems to inform and drive programmatic and strategic decision-making. This role will work directly with departments across the organization to understand business priorities and KPIs, conducting analysis and developing impactful dashboards and reports that effectively communicate insights to diverse audiences.

As a lead developer for Power BI, the Business Intelligence Analyst will create visual-heavy dashboards while training staff to become more self-sufficient in data access and analysis. They will leverage Microsoft Fabric and Power BI as primary platforms while also working across CAFB’s broader data ecosystem to meet analytical needs.

This position will manage the JIRA ticketing center, reviewing and triaging requests to ensure they are assigned to the appropriate team member while managing SLAs. The Business Intelligence Analyst will support the ad hoc analytical and reporting needs of the organization while working to align departmental data practices with CAFB’s Fabric and Power BI infrastructure. They will also help define business requirements for enhancements to systems in our technology stack and will dedicate a portion of their time to GIS work supporting the analytical and data needs of the food bank — a growth area for the organization.

The Business Intelligence Analyst will become intimately familiar with the Food Bank’s data ecosystem, including Microsoft Fabric, Power BI, NetSuite, Salesforce, ArcGIS, and other systems. Working alongside the Data Engineer who manages Fabric administration, this role requires an ambitious and mission-driven individual who can think critically, creatively problem-solve, and bridge the gap between technical data infrastructure and business user needs.

Essential Functions:

Business Intelligence & Data Visualization

• Serve as a lead Power BI developer for the Analytics team, creating sophisticated, visual-heavy dashboards that effectively communicate complex data insights to diverse audiences across the organization.
• Work directly with departments to understand their business priorities, KPIs, and data needs, translating requirements into effective Power BI solutions, semantic models, and optimized DAX calculations.
• Work primarily with data from the Fabric Gold layer to create production-ready reports and dashboards while maintaining understanding of the full medallion architecture (Bronze, Silver, Gold).
• Establish and maintain Power BI best practices and standards for the organization, including dashboard design principles, data modeling approaches, and performance optimization techniques.
• Contribute to the development and maintenance of organizational and departmental reports, dashboards, and data tools to measure the accomplishment of CAFB's strategic objectives.
• Track Power BI adoption metrics and dashboard usage to understand how data tools are being utilized across the organization and identify opportunities for improvement.

User Support & Enablement

• Manage the JIRA ticketing center, reviewing and triaging ad hoc data requests, reporting needs, and analytical support requests from staff across the organization, ensuring tickets are assigned to the appropriate team member and SLAs are maintained.
• Train and empower staff to become more self-sufficient in Power BI, data access, and analysis through one-on-one coaching, documentation, and group training sessions.
• Align departmental data practices with CAFB's Microsoft Fabric and Power BI infrastructure, serving as a bridge between business users and technical data architecture.
• Define business requirements for enhancements to systems within CAFB's technology stack, working with IT and vendor partners to translate user needs into technical specifications.
• Collaborate with the Data Engineer on data quality issues, reporting requirements, and opportunities to improve data processes and workflows.
• Contribute to data governance efforts including the establishment of data standards, naming conventions, documentation practices, and support for managing Power BI workspace permissions and access controls.
• Support the Senior Director of Insights and Analytics as an in-house subject matter expert on data analysis and reporting, presenting findings to leadership and facilitating data-driven decision-making sessions to help the organization understand, utilize, and reflect on data.

GIS & Strategic Analytics

• Perform GIS work to support the analytical and data needs of the food bank, including spatial analysis to better understand organizational impact, service coverage, and food insecurity patterns across the service area to inform strategic planning.
• Support the development and maintenance of web-based GIS tools such as the Hunger Heat Map and Get Help Map, utilized by both CAFB staff and the public to visualize the complex landscape of food insecurity and food relief.
• Make recommendations that will drive process improvements related to data collection, processing, analysis, business operations, and decision-making processes.