Database Research and Maintenance Clerk 4

Case Western Reserve University; Cleveland (OH); Hybrid; USD 22,000 - 31,000; Full time

Benefits offered by this job

Healthcare

Retirement plans

Tuition assistance

Paid time off

Winter recess

Job summary

Case Western Reserve University seeks a meticulous database clerk to enter and maintain donor and biographical data in the Advance system. You will apply university policies to ensure accurate gift and pledge coding for campaign tracking and reporting.

Responsibilities include updating alumni records, verifying degrees, and supporting management with data-driven reports. The role favors accuracy, discretion, and collaboration within Advancement Services.

Qualifications

• High school diploma required; Bachelor's degree preferred.
• Experience with computerized records management and non-profit fundraising data.
• Microsoft Excel proficiency and ability to learn new systems.
• Ability to handle confidential information with discretion.

Responsibilities

• Process donations and code entries in the Advance system per university guidelines.
• Maintain Alumni Development database records and ensure data accuracy.
• Verify degrees and biographical data using sources and reports.
• Support reporting and data management needs of management.

Skills

Excel proficiency

Database entry accuracy

Attention to detail

Team player

Confidentiality

Discretion

Typing accuracy

Communication skills

Education

High school diploma required

Bachelor's degree preferred

Tools

Ellucian Advance system

Microsoft Office

Windows OS

Job description

Case Western Reserve University is committed to providing a transparent estimate of the salary for this position at the time of its posting. The starting wage rate is $19.32 per hour, depending on qualifications, experience, department budgets, and industry data.

Employees receive more than just a paycheck. University employees enjoy a comprehensive benefits package that includes excellent healthcare, retirement plans, tuition assistance, paid time off, and a winter recess.

POSITION OBJECTIVE

Working independently, the database research and maintenance clerk 4 is responsible for the accurate and timely coding, input, and verification of charitable gifts, grants, and pledges to the Case Western Reserve University alumni/development database system. This position is also responsible for the entry and maintenance of all biographical records including alumni, friends, corporations, foundations and others in the database system. The incumbent will be expected to apply the policies, principals, and fundamentals of the University Relations and Development division to the process of entering and maintaining its system for tracking charitable donations.

Essential Functions

• Using guidelines, policies, and procedures established by the Office of Advancement Services, process charitable donations received by the university. If donor designation is unclear, research the donation using available resources and/or advice of the proper development officers for accurate coding and entry. Code gift and pledge entries using established guidelines for campaign tracking, solicitation tracking, acknowledgment tracking, appeal tracking, program and purpose tracking, etc. (40%)
• Research, maintain, and update the Alumni Development database for all biographical records stored in the Advance system. Review and research changes and corrections received by the Advancement Services Office in many forms from many sources. Enter new data, modifications, and changes into the Advance system. Interpret and apply biographical policies and procedures when maintaining data in the Advance system. Review additions/changes for accuracy prior to database update. Assist associate director with reporting as necessary. Devise procedures and make recommendations for the processing involved in maintaining complex record-keeping and or filing systems. (20%)
• Participate in handling special procedures: degree verification: when any question arises regarding the accuracy of degrees awarded by Case Western Reserve University, review commencement materials housed in Advancement Services or contact the University Registrar's Office by phone or in person. Graduates: using commencement programs and school lists, verify all new graduates once they are added electronically to the Alumni Development database. Lost: for an individual whose mail is returned with no forwarding address, institute and carry out a search for information from among all possible sources including use of the resources available via the World Wide Web. Deceased: research and verify the demise of individuals using resources such as the World Wide Web, and complete the process for deceasing entities in the Advance system. Tracers: complete and send tracers on alumni for whom information is missing or to verify new addresses. Process returned alumni surveys through the database. Research and verify information to insure accurate additions and modifications to the database. Perform routine research using standard reference materials and the World Wide Web to obtain data, verify data, and collect related data for database input. Verify data that is data loaded into the Advance system from third party vendors and other sources such as NCOA data, data from the student calling system, HEP data, alumni surveys, etc. Work with department managers in identifying needs as they relate to attaining reports and information needed by management. (20%)

Nonessential Functions

• Process matching gift forms and claims as they are received from the donor. As matching gift forms are received, verify business data and employment data and enter or correct as necessary in the Advance system. Fill out the matching gift form and submit to the associate director of advancement services for signature. Maintain files of matching gift forms for those gifts for which application has been made. Process gifts against outstanding matching claims as procedures dictate. (5%)
• Process credit card transactions using the appropriate credit card online processing system. (5%)
• Process electronic funds transfer donations and payroll deduction transactions using procedures established by the Office of Advancement Services. (5%)
• Perform all standard balancing and verification procedures for all cash and checks received. Balance and verify non-cash donations following standard procedures. Prepare checks received for bank deposit on daily basis. (5%)

Perform other duties and responsibilities as assigned.

CONTACTS

Department: Contact with all Advancement Services and University Relations and Development staff on as required to perform essential functions.

University: Periodic contact with the Controller's Office, Grants Accounting, Research Administration, and occasional contact with University Relations staff as required to perform essential functions.

External: Periodic contact with donors as required to perform essential functions.

Students: Contact with seasonal student employees within the department as required to perform essential functions.

SUPERVISORY RESPONSIBILITY

No direct supervisory responsibility.

Qualifications

Experience: 4 or more years professional work experience required.

Education: High school education required; Bachelor's degree preferred.

Required Skills

• Although Ellucian Advance system training will be provided by the University, keyboard skills and experience in a Windows operating environment is mandatory. Computer proficiency including Microsoft Office (specifically Excel) and the ability to learn new programs.
• Prior experience in computerized records management is mandatory. Preference is given to database management in a non-profit fund-raising environment.
• Working knowledge of standard research references, including the World Wide Web, is preferred.
• Must be able to work well with people and be a team player. Must be highly motivated and a self-starter, able to work with minimal supervision.
• Ability to judge quality of information received and to act on own judgment.
• Ability to maintain logical and meticulous attention to detail at all times under all conditions. Love of detail work is mandatory.
• Strong proof-reading skills are mandatory.
• Ability to communicate well with university staff members on all levels is mandatory.
• Must understand and adhere to confidentiality.
• Must possess a high level of discretion, maturity, and motivation.
• Must be able to set priorities, exercise initiative and work effectively without close supervision.
• Absolute accuracy in typing and spelling is mandatory. Ability to type quickly and accurately.
• Ability to demonstrate history of successful support, education, and advocacy for all students, aligned with the values, mission, and messaging of the university, while adhering to the staff policy on conflict of commitment and interest.
• Ability to interact with colleagues, supervisors, and customers face to face.
• Ability to meet consistent attendance.
• Willingness to learn and work with artificial intelligence (AI) tools and technologies.

WORKING CONDITIONS

General office working environment.

This position is eligible for hybrid work arrangement up to two remote days per week at the discretion of the department. New employees may begin a hybrid schedule upon approval from the supervisor, successful completion of an orientation period and signing the remote work checklist certification form.

Case Western Reserve University is an equal opportunity employer. All applicants are protected under federal and state laws and university policy from discrimination based on race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, protected veteran status, disability, age and genetic information.

Case Western Reserve University complies with the Americans with Disabilities Act regarding reasonable accommodations for applicants with disabilities. Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the CWRU Office of Equity at 216-368-3066 to request a reasonable accommodation. Determinations as to granting reasonable accommodations for any applicants will be made on a case-by-case basis.