Philanthropy Business Analyst

The Art Institute of Chicago; Chicago (IL); On-site; USD 60,000 - 75,000; Full time

Job summary

The Art Institute of Chicago seeks a Philanthropy Business Analyst to provide analytic support and strategic insights across the Philanthropy department. You will translate goals into clear reporting, visualizations, and tools to guide decision-making and fundraising projections.

You will develop analytics, data visualizations, and reports to help the department work more efficiently and strategically, partnering with leadership to set and track objectives.

Qualifications

• 1+ years of analytics experience required.
• Non-profit, museum, or higher education backgrounds preferred.
• Experience with data visualization software (Tableau) and ETL tools (Alteryx).
• Proficiency with SQL, CRM systems (Salesforce, KindSight Ascend), and reporting tools.
• Ability to translate goals into meaningful reports and dashboards.
• Strong organizational, interpersonal, and communication skills.

Responsibilities

• Envision and lead a philanthropy reporting ecosystem with dashboards and data warehouses.
• Extract datasets to support business analysis and efficiency gains.
• Collaborate with leadership to set and track goals and progress.
• Support CRM testing, conversion, and ongoing processes.
• Design, execute, and evaluate real-world experiments.
• Perform additional tasks as needed.

Skills

Analytical thinking

Communication

Cross-functional collaboration

Tools

Tableau

Alteryx

SQL

Salesforce

KindSight Ascend

Job description

The Art Institute of Chicago shares its singular collections with our city and the world. We collect, care for, and interpret works of art across time, cultures, geographies, and identities. We are a place of gathering and learning, committed to fostering an inclusive understanding of human creativity.

About the Department

The Enterprise Software and Analytics team supports the institution by guiding the strategy, implementation, and maintenance of its enterprise applications. The team leads the data and analytics functions, helping departments make informed, mission-aligned decisions. They also consult to ensure systems work together effectively, supporting smooth functionality, thoughtful integration, and a strong foundation for future growth.

Position Summary

The Philanthropy Business Analyst provides analytic support and strategic insights for the Philanthropy department. You work across teams to help colleagues understand and use data effectively, translating departmental goals into clear reporting, visualizations, and tools that support decision-making. Your work guides goal setting, progress measurement, prospect management, pipeline development, and fundraising projections. You also develop and maintain analytic tools, data visualizations, and reports that help the department work more efficiently and strategically.

Responsibilities

• Strategically envisions and leads a holistic philanthropy reporting ecosystem, including systemized reports, data visualizations, and internally developed data warehouses. Topics include business processes, KPI tracking, and relationship management.
• Supports the Philanthropy department by extracting specialized datasets that contribute to business analysis and efficiency gains.
• Works with Philanthropy leadership to set team and officer goals, visualize those goals, and track progress through completion.
• Partners with Philanthropy on CRM system testing, conversion, and ongoing processes.
• Supports the design, execution, and evaluation of real-world experiments.
• Performs additional tasks as needed.

Qualifications

• 1+ years of analytics experience required.
• Background in non-profit, museum, or higher education environments preferred .
• Experience with data visualization software (such as Tableau), ETL tools (such as Alteryx), SQL, CRM systems (such as Salesforce and Kindsight Ascend), and report-writing tools.
• Strong understanding of data structure concepts and theory.
• Ability to translate departmental goals and strategies into meaningful reports, analytics, and data visualizations.
• Strong organizational, interpersonal, and communication skills.
• Natural curiosity and willingness to learn.
• Ability to work cross-functionally and partner effectively with department leadership.

Please click on the links below to view our competitive, comprehensive benefits package:

• Hiring Range:$60,000-$75,000

The expected hiring range is an estimated amount for positions based on the grade. Final offers are based on various factors, including skill set, experience, qualifications and other job-related reasons.

Accessibility

If you are a job seeker with a disability and require a reasonable accommodation to apply for one of our jobs, you will find the contact information to request the appropriate accommodation by visiting the following page:

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.