Data Management Analyst

About This Role

This role manages the Salesforce database and related applications for Institutional Advancement, ensuring data integrity, security, and processing gifts. The Data Management Analyst provides critical information to college and foundation stakeholders, supporting data-driven decision-making for increased engagement and fundraising.

Responsibilities

• Record and process all gifts and donations to the Elgin Community College Foundation, including online donations, pledge payments, in-kind contributions, and event registrations
• Ensure the accuracy and reconciliation of gift records and allocations in conjunction with the Finance Department, particularly for compliance with IRS regulations and annual audit requirements
• Maintain and update donor, alumni, and other constituent records in the Salesforce CRM to ensure accurate tracking of relationships
• Collaborate with the IT team to ensure the smooth implementation and maintenance of systems; lead and execute data cleanup and similar projects as assigned
• Create and code new accounting database objects (e.g., scholarship and program funds) in coordination with the Finance Department
• Coordinate and communicate with Advancement leadership and staff regarding data requests and reporting
• Create, analyze, and maintain standard and custom reports, graphs, charts, lists, and other outputs for Institutional Advancement staff, college departments, and Foundation Board/committees
• Export and work with data in a variety of file types, including Excel, CSV, and PowerPoint
• Generate reports upon request or on a regular schedule, depending on the report type
• Produce complex data segments within reports for donor identification, cultivation, and solicitation, including segments used within Salesforce Marketing Cloud
• Serve as the administrator for the credit card payment processor, ensuring proper connections to giving forms and related platforms
• Maintain strong, collaborative relationships with departmental leaders and representatives across campus
• Develop expertise to train and cross-train Advancement and Foundation staff on CRM software usage and best practices

Requirements

• Bachelor’s degree in Data Science, Information Systems, Business Analytics, or a related field; or an equivalent combination of training and experience
• Four or more years of proven experience in data analysis, reporting, and database management
• Proficiency in fundraising CRM software, preference for Salesforce Non-Profit Success Pack, or similar (e.g. Blackbaud Raiser’s Edge NXT)
• Proficiency in Microsoft Office Suite products, including Outlook, Teams, Word, and advanced proficiency in Excel
• Ability to independently manage and prioritize multiple projects and to meet deadlines
• Demonstrated experience presenting and discussing statistical analysis and research findings to a wide variety of audiences
• Excellent oral communication

Qualifications

• Bachelor’s degree in Data Science, Information Systems, Business Analytics, or a related field
• Four or more years of proven experience in data analysis, reporting, and database management, preferably in a non-profit, higher-education, or fundraising environment

Nice to Have

• Familiarity with non-profit accounting standards and best practices
• Familiarity with student information systems, e.g., Ellucian Colleague
• API/backend coding experience
• Familiarity with Salesforce Marketing Cloud or similar digital marketing automation and analytics platforms

Skills

* Required skills

Benefits