The salary range for this position is $75,000 to $90,000 (that range was not a choice in the form.)

Title:               Data and Grants Manager 

Reports To:   Executive Director

Status:           Salaried, full-time, exempt

Location:       Chicago, hybrid 3 days/week in office

WHO WE ARE

The Coleman Foundation, Inc. is a private grant-making foundation, listed as 17th on Crain’s Chicago Business’ 2024 Largest Foundations in Chicago, with a current endowment of approximately $180 million. Since 1951 we have proudly invested in local nonprofits, neighborhood-based organizations and institutions working to improve the lives of people in the greater Chicago region.

Supported by our community-minded board of directors, our small, collaborative staff is committed to ensuring that our grantee partners are equipped to meet the unprecedented challenges of 2025 and beyond.  This year the foundation is implementing new strategies for our three program areas: Entrepreneurship, Health, and Intellectual & Developmental Disabilities, and making approximately 100 grants totaling $9 million. 

Learn more: www.ColemanFoundation.org.

OUR MISSION

The Coleman Foundation invests in the efforts of community-based organizations and local institutions to preserve and strengthen the physical health and the economic and emotional well-being of people living in the greater Chicago region.

VALUES

1. Respect for Community
2. Responsiveness
3. Empathy
4. Responsible Stewardship

THE OPPORTUNITY

The Data and Grants Manager (DGM) is a pivotal new hire that will partner with Foundation leadership to modernize grantmaking systems. Leading Fluxx administration and cross-functional integrations (finance, operations, and program), the role builds end-to-end processes that make data reliable, accessible, and actionable across the foundation. The DGM will operationalize new leadership priorities— by streamlining compliance, strengthening grantee experience, and creating a durable, data-driven backbone for current and future strategies.

ABOUT THE ROLE

The Data and Grants Manager will be instrumental in shaping, executing, and overseeing The Coleman Foundation’s grantmaking policies, systems, and processes. This role ensures seamless management of the entire grant lifecycle—from application intake and data oversight to reporting and stakeholder engagement.

In addition to operational responsibilities, the Data and Grants Manager will spearhead initiatives that enhance and modernize the foundation’s grantmaking approach, playing a vital role in advancing its long-term mission and impact. To be effective in this position, the Data and Grants Manager will work collaboratively across multiple internal and external constituents, demonstrating a deep understanding of the needs of applicants, grantees, Foundation leadership and other stakeholders - ensuring that those perspectives are incorporated in the grant-making process.

PRIMARY DUTIES AND RESPONSIBILITIES 

Grants Management

1. Manage and continuously work to improve the Foundation’s Fluxx grants management system (GMS), processes, and capabilities for greater efficiency and efficacy.
2. Proactively design and conduct training for Foundation staff, board, consultants and grantees to support shared understanding of the Foundation’s grantmaking policies and processes. Ensure the team is updated on new functionalities including AI and other integrations.
3. Lead the Foundation’s grant cycle work of award management, funding, payment, and reporting.
4. Serve as an expert resource on industry grantmaking best practices through participation in professional development opportunities through Fluxx, PEAK Grantmaking, etc.

Systems Management

1. Ensure seamless integration of the Fluxx grants management software with the Foundation’s accounting (QuickBooks Online, Bill.com) and operating systems.
2. Serve as lead for Fluxx technical support; escalating issues to Fluxx Helpdesk as needed.
3. Coordinate and conduct functionality testing of system upgrades and updated configurations; track and resolve system issues with Fluxx.
4. Ensure and evaluate the integrity of grants-related data and systems, and systems records.
5. Process grantee audit and nonprofit status confirmations.

Financial & Legal Compliance

1. Prepare, send, and track award letters, grant agreements and related documents, confirming compliance with IRS regulations and Foundation requirements.
2. Work closely with the CFO to process, track, and record grant payments. Manage process to ensure grant budget allocation is consistent and accurate.
3. With the CFO, ensure compliance with tax laws governing the Foundation’s grants and source of funding.
4. Remain up to date on foundation and nonprofit best practices, grant-making guidelines and regulations, and manage and recommend changes for new and existing grant-making policies, including the incorporation of new tax and charitable contribution laws. 

Grantee Relations

1. Serve as the primary contact for past, current, and prospective grantee inquiries about the grants process (including eligibility, application, approval, grant agreements, payments, and reporting).
2. Troubleshoot grantee issues, manage the proper workflow of grant cycle milestones and tasks.
3. Serve as primary Fluxx and technical support for grantees throughout the grantmaking process.
4. Maintain accuracy of grantee records, including organizational, financial, banking and contact information, grant status, coding, reporting, and payments. 

Data Management and Support

1. Design process to embed foundation evaluation framework into Fluxx and grant reporting process.  
2. Work closely with staff to produce and assemble board book materials and visualizations for quarterly and ad-hoc board meetings, including grant dockets, presentations, reports and related documents.
3. Manage, maintain, and deliver grant-related reporting to internal and external stakeholders as needed. 
4. Prepare and present reports during Board Meetings that provide strategic insights related to grantee and grantmaking trends.
5. Assist Program team with due diligence, including reviewing financial statements and other research.
6. Maintain and provide data for internal operational purposes, e.g., regular payment releases and cash flow reporting, program budgeting, website grants listing, 990-PF schedules, annual audit.

QUALIFICATIONS

1. Minimum 5 years using and managing a grants management system or database. Preference given to candidates with experience utilizing Fluxx grants management systems.
2. Requires a bachelor’s degree or equivalent experience in a field related to the nonprofit sector.
3. Demonstrated knowledge of budgeting, analysis, reporting and grants management.
4. Deep understanding of grants management policies, processes, and systems that have been gained by working at a ...