Business Intelligence Analyst

Business Intelligence Analyst Hybrid • Washington, DC 20017 Apply Overview Salary Range $64,800.00 - $83,300.00 Salary Position Type Full Time Job Shift Day Category Professional Services Apply Description About the Organization: It is an exciting time at the Capital Area Food Bank (CAFB) as we continue to undertake our mission. We know that creating long term solutions to food security requires more than meals. It requires education, training, and collaboration. We are seeking people with strong ideas and a passion to come together to address the complex interrelated issues of food security, poverty, and equity. We are expanding in multiple ways: providing food for today and addressing the root causes of hunger by partnering with organizations that provide critical services like job training programs, health care and education. Food has the power to transform lives and move everyone forward. Find out how on our website at capitalareafoodbank.org. 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. Qualifications 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 GIS (preferred): Working knowledge of ArcGIS or similar platforms for spatial analysis and mapping; multiple years of experience preferred 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 Experience with NetSuite, Salesforce, or similar enterprise systems is preferred Other Skills, Abilities: 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. Understanding of program evaluation, monitoring, and impact assessment preferred. Familiarity with the fields of food banking, hunger alleviation, or food security preferred. Physical Demands & Working Conditions: Work is performed in an office environment and requires the ability to operate standard office equipment and keyboards. Required to speak and listen effectively, both in person and over the phone. Reporting : Senior Director, Insights and Analytics Application Process: Interested applicants must submit a cover letter and resume. Applications will be reviewed on a rolling basis. Please Note: We do not accept walk-in applications or in-person status updates for any positions. All applicants must apply online. We kindly ask that applicants do not call/email/or show up in person to inquire about application status. To check the status of your application, please log in to your personal Paycom application account. Our HR team will contact you directly if you are selected for the next step in the hiring process. Compensation : $64,800 – $83,300 / year Schedule : Hybrid schedule available; 3 days in office at our DC location and 2 days remote. Regular work hours are Monday through Friday from 9am to 5:00pm.