Database Analyst

The Advancement Database Analyst oversees database maintenance for the Office of Advancement at Illinois Wesleyan University, ensuring data integrity, accuracy, and adherence to standards through audits, cleanup projects, and training. They help fulfill data requests by creating and maintaining queries that support fundraising, stewardship, and alumni engagement. They assist with pledge and gift processing, standardizing procedures, and providing backup for gift entry and donor acknowledgments. This role plays a key part in maintaining a reliable advancement database to support strategic decision-making and donor relations at IWU. This a full time, benefits-eligible, on-campus position. Generous benefits include health, retirement, considerable time off and tuition assistance.

Responsibilities :

• Oversee database maintenance and standards; responsible for standardizing all record updates and ensuring adherence to standards through documentation and training to ensure long-term sustainability; conduct regular data audits to identify and resolve data inconsistencies or errors; execute data entry and data cleanup projects to upkeep database structure, functionality, and accuracy of records

In partnership with our Systems Analyst, fulfill data requests from the Office of Advancement and University partners; create and maintain custom queries for various teams; ensure data requests align with best practices for data integrity, security, and efficiency

In partnership with our Gifts and Records Coordinator, assist with entering pledges and gifts to the University; act as a backup for the Gifts and Records Coordinator to enter any gifts in the form of cash, checks, credit cards, stock transfers, IRA transfers, or other valuables as gifts-in-kind; assist with standardizing and documenting gift entry procedures; provide backup for acknowledgment letters and donor inquiries

Attend meetings and trainings to stay current on Advancement Operations and Slate for Advancement best practices; attend Advancement events and meetings as necessary to support the overall goals of the department; perform other tasks, duties, projects as assigned

Requirements :

Minimum of three years related experience; demonstrated understanding and experience with technical systems, relational databases, data warehouses, data mining and data analysis techniques

Understanding of fundamental Database Management System (DBMS) concepts and exposure to at least one relational DBMS; Slate for Advancement, Oracle, SQL Server, DB2, MySQL

Application Information :

Please download the application at www.iwu.edu / human-resources / job-openings / .  Feel free to include a cover letter, resume and contact information for three professional references. Review of applications will begin immediately and the position is open until filled.

Email :   hr@iwu.edu

Illinois Wesleyan University

Human Resources, Holmes 209

1312 N. Park Street

Bloomington, IL  61701

Fax :   309-556-1710

Salary $54-$59k, based on experience

The final candidate will pass a pre-employment background investigation.

An overview of IWU benefits can be found here . Illinois Wesleyan University does not sponsor work visas at the time of hire or anytime during employment for this position. All persons hired will be required to verify identity and eligibility to work in the United States and maintain work authorization throughout the employment term.

Illinois Wesleyan University is committed to recruiting, supporting, and fostering a diverse, inclusive, and civil community of outstanding faculty, staff, and students. We seek candidates who have a demonstrated commitment to supporting and further building our community in these dimensions. Illinois Wesleyan University is an EEO Employer.  Illinois Wesleyan University’s sexual misconduct policy may be accessed at  www.iwu.edu / human-resources / SexualMisconductPolicy.html .  Illinois Wesleyan University is an equal opportunity employer committed to diversity and inclusive excellence; details at www.iwu.edu / diversity .

Salary : $54,000 - $59,000