MacArthur Foundation · 4 hours ago
Business Data Analyst, Fellows
Chicago, IL
Full-time
Hybrid
Mid, Senior Level
3+ years expThe John D. and Catherine T. MacArthur Foundation is one of the nation's largest independent foundations. The Business Data Analyst will manage and lead the optimization of the Foundation’s CRM systems, elicit business needs, and design new solutions while ensuring data integrity and providing training and support to staff.
Non ProfitSocial MediaCommunitiesSocial
Responsibilities
Work with the Fellows Program and Partnerships Team to elicit business needs and identify problems
Build a data architecture to enable us to store, enrich, and leverage our data
Identify opportunities for business process and data improvements
Partner with Foundation IT Staff to review and/or test functionality as needed
Perform necessary functional testing to ensure the success of upgrades and solutions
Deliver training and technical support for Staff; develop and maintain detailed written user guides and documentation for processes and data management and standards
Investigate and diagnose system issues and errors; work with Foundation IT Staff and support resources to resolve issues
Stay up to date on CRM updates/changes to determine potential impact on business processes
Create and update queries, reports, and data visualizations for Fellows Program, Staff and Partnerships Team as needed, including using Microsoft Power BI
Ensure integrity of Fellows Program data and Partnerships data, design best practices for data entry and tracking historical data, complete regular clean-up of data
Participate in ongoing relationships with business partners, including Foundation IT Staff, external support resources, and other Foundation departments
Coordinate project management support on continuous improvements and key initiatives
Create and/or update training materials and provide training as needed. Coordinate training material updates for cross-department functions
Perform other duties as assigned
Qualification
Required
A bachelor's degree or equivalent experience in a related field; advanced degree or certifications in a related field preferred
Minimum of three years of professional experience in data analysis, and at least five years of professional functional lead experience
Knowledge and professional experience with Slate CRM. Experience with Slate portals, Slate for Advancement functionality, and maintaining Slate forms and queries preferred. Salesforce experience is a plus
Experience working as liaison between end users and technical staff
Knowledge of SQL, Microsoft Power BI, and project management tools, such as Jira
Experience with maintaining data integrity, designing data collection best practices, and data analysis
Professional and effective written and oral communication skills
Able to effectively converse with, listen to, and collaborate with all levels of users to understand their environment and the impact of system changes
Self-starter with initiative who can manage multiple tasks and adapt and respond quickly to opportunities for increased and more effective services
Preferred
Advanced degree or certifications in a related field
Experience with Slate portals, Slate for Advancement functionality, and maintaining Slate forms and queries
Deep understanding of the cultural requirements within a Foundation for collegial and participative interaction
Benefits
A comprehensive benefits package to support your life, health, and well-being.
Company
MacArthur Foundation
MacArthur Foundation is a philanthropic organization that provides grants for climate action, social justice, and peacebuilding initiatives.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Punit Kohli
Chief Financial Officer
Brad Ballast
Chief Operating Officer, Lever for Change
Recent News
San Francisco Chronicle
2025-11-18
Company data provided by crunchbase