Development Business Intelligence Analyst

Food Bank of the Rockies • Aurora, CO

7h • $35 - $40 • Hybrid

About The Position

The Development Business Intelligence Analyst (BI Analyst) plays a key strategic role on the Development and Database team, leading the use of analytics to support fundraising and engagement efforts at Food Bank of the Rockies. This position collaborates closely with both the Development and Database teams to ensure data integrity, accuracy, and confidentiality across systems. The BI Analyst designs, builds, and maintains dashboards and reports; conducts prospect and portfolio analysis; supports data QA and pipeline testing; and contributes to the documentation and delivery of high-quality data products that advance organizational goals. Working in close alignment with the Data Systems Engineer—who provides operational oversight and task delegation—the BI Analyst helps drive data-informed decision-making through proactive reporting and cross-functional collaboration. Food Bank’s team is dedicated to creating an efficient food distribution network to eliminate hunger. Staff is committed to embodying the organizational values and mission in all activities.

Requirements

• Bachelor’s degree or equivalent required; or equivalent professional experience
• 3–5 years of experience in business intelligence, data analytics, or nonprofit CRM systems
• Proficiency with Power BI, Tableau, or equivalent dashboarding platforms
• Advanced Excel skills; strong understanding of data modeling and visualization best practices
• Proficiency in at least one programming or scripting language (such as Python, VBA, etc.) and/or experience developing complex flows on low code platforms (Microsoft Power), used for automating data processes, custom reporting, or API-based integrations.
• Familiarity with CRM systems such as Raiser’s Edge, Engaging Networks, ResearchPoint, or similar
• Strong project management and cross-functional communication skills
• Background in data analysis, business intelligence, or systems administration preferred
• Strong self-direction and time management skills; planning and prioritizing work to accomplish all tasks in the time allotted; consistently meets deadlines

Nice To Haves

• Experience in nonprofit, fundraising, or mission-driven organizations is a plus
• Understanding of ETL/ELT concepts, APIs, and cloud-based data tools preferred

Responsibilities

• Design, build, and maintain dashboards and reports using tools such as Power BI, RENXT, and Excel.
• Provide scheduled and ad hoc analysis of donor, campaign, and engagement data to support fundraising strategy.
• Conduct segmentation, portfolio analysis, and translate data insights into actionable recommendations for non-technical audiences.
• Support ETL/ELT workflows and data quality processes in coordination with the Data Systems Engineer.
• Monitor and maintain data pipelines across CRM, marketing, and volunteer platforms and assist in addressing anomalies.
• Develop scripts (e.g., Python) to automate reporting processes, data transformations and integrations; document data schema and workflows.
• Assist with internal tool development, testing, rollout, and enhancement of enterprise applications.
• Identify manual reporting and data processes for automation and propose efficient technical solutions.
• Adhere to and support SOP generation related to data quality, access control, and security in conjunction with Database Manager.
• Conduct routine data quality audits and maintenance tasks; maintain documentation, calendars, and SOPs for audit processes.
• Ensure compliance with donor privacy standards, consent policies, and internal development protocols.
• Maintain templates, workflows, user profiles, and reports across platforms such as Raiser’s Edge, Omatic, Smartsheet, and ResearchPoint.
• Lead BI Projects including dashboard builds, report redesigns, and analytical requests.
• Support projects including data cleanups, infrastructure updates, and new system implementations.
• Coordinate with Development, Marketing, IT, and Finance departments on cross-functional data initiatives.
• Protect sensitive donor information and maintain confidentiality standards.
• Provide team coverage during peak periods or absences; perform related duties as assigned.
• Handle confidential information with discretion and care, ensuring the privacy and respect of employees, volunteers, partners, donors, or others.

Benefits

• Generous Paid Time Off: Flexible paid time off, including 10 paid holidays, sick leave, and opportunities for paid volunteer time.
• Robust Retirement Plan: A 401(k)-retirement plan with a 4.5% employer match, plus additional matching based on tenure for a total potential match of up to 8.5%, to support your long-term financial security.
• Comprehensive Health Coverage: Competitive health, dental, vision, and life insurance plans to support your meet your and your family’s needs.
• Medical and Parental Leave: Leave time is offered through the Colorado-funded FAMLI (Family and Medical Leave Insurance) Program.
• Bilingual Incentive: A monthly incentive for certified bilingual staff, recognizing and rewarding your valuable language skills.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level