Business Intelligence Analyst

CAPITAL AREA FOOD BANK•Washington, DC

4d•$64,800 - $83,300•Hybrid

About The Position

The Capital Area Food Bank (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.

Requirements

2-3 years of experience in data analysis, business intelligence, or related field
Bachelor's degree in a related field, or equivalent experience in analytic reporting, information systems, or business intelligence
Power BI: 2+ years of demonstrated expertise creating complex, visual-heavy dashboards, data modeling, DAX, Power Query, and Power BI best practices
Microsoft Fabric: Working knowledge of Microsoft Fabric, particularly the Gold layer for production-ready analytics; understanding of the medallion architecture (Bronze, Silver, Gold) is essential
Excel: Advanced proficiency with Excel and Microsoft Office Suite, including high-level confidence analyzing and presenting data
SQL: Ability to write queries and understand database architecture; experience with data warehousing concepts is a plus
JIRA or similar ticketing systems: Experience managing and prioritizing work requests
Demonstrated ability to train non-technical users and communicate complex data concepts clearly and effectively
Quick learner; high aptitude for learning new programs and systems.
Self-starter; ability to take initiative and independently recommend new directions for analysis and improvements to data processes.
Time management; ability to effectively and proactively prioritize a large and varied workload with competing deadlines, particularly when managing multiple JIRA tickets and dashboard requests simultaneously.
Project management; confident leader and effective communicator, able to keep cross-departmental teams on track and goal-oriented.
Excellent communication skills; ability to work across departments on a variety of projects and communicate data results clearly and succinctly to both technical and non-technical audiences.
Business requirements gathering; ability to translate user needs into actionable technical requirements and work with IT teams to implement solutions.
Attention to detail; thoroughness in accomplishing a task through concern for all the areas involved, no matter how small.
Change management; comfort with supporting change management and communication as technical requirements are translated into new processes that change the daily workflow for staff.

Nice To Haves

GIS (preferred): Working knowledge of ArcGIS or similar platforms for spatial analysis and mapping; multiple years of experience preferred
Experience with NetSuite, Salesforce, or similar enterprise systems is preferred
Understanding of program evaluation, monitoring, and impact assessment preferred.
Familiarity with the fields of food banking, hunger alleviation, or food security preferred.

Responsibilities

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.
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.
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.