Database Analyst

*See full posting on IWU website and follow application instructions as outlined. For full consideration, an IWU application must be submitted.

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:

• Bachelor’s degree required; experience in database management and maintenance may substitute for required education
• 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 . 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:

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.

Job Type: Full-time

Pay: $54,000.00 - $59,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday
• Weekends as needed

Application Question(s):

• Have you already completed and emailed an IWU employment application to hr@iwu.edu? For full consideration you must complete this.

Education:

• Bachelor's (Preferred)

Experience:

• Database management: 3 years (Required)
• database maintenance: 3 years (Required)
• Slate: 1 year (Preferred)
• Oracle: 1 year (Preferred)

Work Location: In person

Salary : $54,000 - $59,000