Elgin Community College · 6 hours ago
Data Management Analyst
Elgin, IL
Full-time
Onsite
Mid Level
$65K/yr - $87K/yr
4+ years expElgin Community College serves over 9,000 students, and they are seeking a Data Management Analyst to manage the Institutional Advancement Salesforce database and related applications. This role focuses on ensuring data integrity and security, processing gifts, and collaborating with various stakeholders to support fundraising efforts for the college and foundation.
Higher Education
Responsibilities
Records and processes all gifts and donations to the Elgin Community College Foundation, including online donations, pledge payments, in‑kind contributions, and event registrations
Ensures 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, on both a monthly and annual basis
Maintains and updates donor, alumni, and other constituent records in the Salesforce CRM to ensure accurate tracking of relationships. Updates are completed both on an individual‑record basis and at scale through large data imports (e.g., annual uploads of new graduate alumni records)
Collaborates with the IT team to ensure the smooth implementation and maintenance of systems; leads and executes data cleanup and similar projects as assigned
Creates and codes new accounting database objects (e.g., scholarship and program funds) in coordination with the Finance Department
Coordinates and communicates with Advancement leadership and staff regarding data requests and reporting
Creates, analyzes, and maintains standard and custom reports, graphs, charts, lists, and other outputs for Institutional Advancement staff, college departments, and Foundation Board/committees, ensuring all items are properly cleaned and formatted
Exports and works with data in a variety of file types, including Excel, CSV, and PowerPoint
Generates reports upon request or on a regular schedule, depending on the report type (e.g., monthly fundraising report)
Produces complex data segments within reports for donor identification, cultivation, and solicitation, including segments used within Salesforce Marketing Cloud
Serves as the administrator for the credit card payment processor, ensuring proper connections to giving forms and related platforms, including event registration pages
Maintains strong, collaborative relationships with departmental leaders and representatives across campus
Serves on appointed college committees and groups, representing the Advancement office as needed
Attends workshops and meetings—particularly those involving the IT department—to support transitions to new software or technologies
Develops expertise to train and cross‑train Advancement and Foundation staff on CRM software usage and best practices
Maintains required training, licensure and/or certifications
Maintains confidentiality of privileged information and adheres to applicable privacy laws
Demonstrates sensitivity, understanding and respect of diverse populations within the workplace
Maintains an understanding of the work of colleagues to effectively provide backup and/or support for co-workers during times when the division is short-staffed or experiencing an increased volume of work
Adheres to department guidelines for attendance and punctuality
Qualification
Required
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, preferably in a non‑profit, higher‑education, or fundraising environment
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, and 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 with varying levels of statistical understanding
Ability to produce and communicate written information and oral presentations in a professional manner to a variety of audiences
Excellent oral communication
Must be available to work a flexible schedule, including evenings and weekends when required by the department's needs
Preferred
Familiarity with student information systems, e.g., Ellucian Colleague
API/backend coding experience
Familiarity with non‑profit accounting standards and best practices
Familiarity with Salesforce Marketing Cloud or similar digital marketing automation and analytics platforms
Benefits
Medical, Dental, Vision Insurance
Life and Long-Term Disability Insurance
Flexible Spending Account (FSA, DCA, Commuter)
Retirement Plans (Pension, 457b, 403b)
Time Off with Pay
Professional Development/Expense
Tuition Reimbursement
Employee Assistance Program (EAP)
Sick Banks
Company
Elgin Community College
Elgin Community College is a school in Elgin.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Anthony Ramos, Ed.D.
Chief Equity, Diversity, Inclusion & Belonging Officer
Elissa Kojzarek, MPA
Director of Strategic Partnerships and Experiential Learning (SPEL)
Recent News
Business Wire
2025-11-03
Company data provided by crunchbase