Attention Current Lewis & Clark College Employees: In order to apply for posted positions, please apply internally in Workday in the Jobs Hub. Working at Lewis & Clark College The campus is located on 137 acres of beautifully landscaped grounds in Portland's southwest hills. Our strong commitment to sustainability is reinforced through recycling programs, energy conservation, alternative transportation options, and farm to fork initiatives. For benefit-eligible positions, we offer a competitive benefits package that includes options for health, dental, vision, tuition, life insurance, retirement and more. Lewis & Clark College is committed to achieving a diverse workforce. Candidates from diverse backgrounds are encouraged to apply. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, national origin, sex, gender identity, sexual orientation, marital status or age. Lewis & Clark College Support Staff Association This position is represented by the Lewis & Clark College Support Staff Association Local 4912 of the American Federation of Teachers. The current LCCSSA Bargaining Agreement can be found here: https://www.lclark.edu/unions/lccssa/ PRIMARY PURPOSE The Gifts Management & Database Specialist within the Advancement Services department reports directly to the Director of Advancement Services. This role is primarily responsible for gift processing, data entry, and report production to support the College's advancement initiatives. The ideal candidate will possess strong attention to detail, advanced experience with Microsoft Excel, and proficiency in database management. To be successful in this position, the individual must excel at accurate gift entries, ensuring compliance with IRS and CASE guidelines, and collaborating with College staff to enhance data integrity and reporting. This position is represented by the Lewis & Clark College Support Staff Association Local 4912 of the American Federation of LCCSSA Collective Bargaining Agreement. ESSENTIAL DUTIES Gift Management & Financial Reconciliation * Record gifts and pledges accurately and in a timely manner, ensuring proper designation and compliance with College policies. * Generate and distribute tax receipt letters in accordance with IRS regulations and CASE guidelines. * Reconcile financial transactions, including cash, checks, and credit card gifts, and transmit reports to the Business and Cashier Offices. * Manage and oversee the creation of new donor funds in alignment with College financial policies. * Provide financial documentation for audits and collaborate with the Business Office to ensure accurate reconciliation. Data Management & Reporting * Support the Director by addressing data needs, ensuring data integrity, and enhancing the structure of the database. * Generate donor and development reports using tools such as Slate and Microsoft Excel. * Update and maintain donor and constituent records within Slate and other relevant databases. * Assist in the development and implementation of gift management policies and procedures. Donor Stewardship & Relations * Support donor stewardship efforts, including preparing scholarship and annual reports. * Act as a resource for staff regarding gift processing, fund management, and data requests. * Collaborate with Advancement staff to enhance reporting, data requests, and provide necessary donor information. Travel Program Support * Maintain and track expense reports for College-hosted trips and events. * Generate trip registration reports and manage event records in Slate. * Import and reconcile registration and payment data from external partners to ensure accurate tracking. Other Duties as Assigned KNOWLEDGE, SKILLS, ABILITIES, & BEHAVIORS * Proficient in database management with a strong understanding of donor relationship management systems, including Slate and Microsoft Excel. * Excellent knowledge of accounting principles related to gift reconciliation, fund management, and financial reporting. * Superior understanding of IRS regulations for nonprofit organizations and CASE guidelines concerning tax receipts and donor reporting. * Excellent organizational skills with the ability to manage multiple tasks, prioritize effectively, and meet strict deadlines. * Superior technical skills in Microsoft Office Suite (Excel, Word, Outlook) and experience with relational databases. * Proficient in data analysis and reporting, generating accurate and insightful reports for various College departments. * Communicate effectively with diverse stakeholders, including donors, staff, and external partners, maintaining professionalism and confidentiality. * Demonstrate exceptional attention to detail when managing gift entries, tax receipts, and financial reconciliations. * Collaborate effectively with cross-functional teams, contributing to a cohesive work environment and supporting shared departmental goals. * Demonstrates a commitment to promoting inclusion in the workplace by fostering an environment of respect and collaboration among colleagues from diverse backgrounds. * Exhibits a proactive approach in identifying and addressing data integrity and system improvement opportunities. * Models integrity and transparency in managing donor information, ensuring accuracy, and adhering to confidentiality protocols. REQUIRED EDUCATION / EXPERIENCE * Bachelor's degree or equivalent combination of education and experience. * Minimum of two years of experience in gift processing, financial management, donor relations, or administrative support. * Strong knowledge of accounting principles, fund reconciliation, and financial reporting. PREFERRED EDUCATION / EXPERIENCE * Degree in a related field (e.g., Finance, Accounting, Nonprofit Management). * Experience in higher education, fundraising, or financial reconciliation. * Background in database management and familiarity with nonprofit regulations and guidelines. JOB CLASSIFICATION * Job Group Title: Gifts Management & Database Specialist * Working Title: Gifts Management & Database Specialist * Salary Grade: 15 * FLSA Status: Non-exempt * Department: Advancement Services * Reports To: Director of Advancement Services * Full-Time: Yes * Schedule: Full-time position, 37.5 hours per week; Hybrid work options may be available based on departmental needs. PHYSICAL REQUIREMENTS * General office environment * Prolonged periods of sitting at a desk and working on a computer * Ability to communicate effectively via phone, email, online meetings, and in person * Must be able to lift up to 15 pounds occasionally * Ability to handle repetitive tasks with attention to detail, including data entry and document management * Flexibility to adapt to varying workloads, especially during peak reporting and gift processing periods Directions for Cover Letter Please include a cover letter describing your interest in joining Lewis & Clark and the ways you can contribute to a culture of inclusion on our campus. Lewis & Clark College adheres to a nondiscriminatory policy with respect to educational programs, activities, employment, and admission. We do not discriminate on the basis of actual or perceived race, color, sex, religion, age, marital status, national origin, the presence of any physical or sensory disability, veteran status, sexual orientation, gender identity, gender expression, or any other basis prohibited by applicable federal, state, and local laws. The Associate Vice President of Human Resources has been designated to handle inquiries regarding employment- and disability-related non-discrimination policies. Title IX inquiries may be directed to the Title IX coordinator or deputy Title IX coordinators (https://www.lclark.edu/about/title_ix_compliance). Reasonable Accommodation Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job. Examples of reasonable accommodation include making a change to the application process or work procedures, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment. Background Check Lewis & Clark College will conduct a background check on the finalist, which will include a criminal record check. If a conviction is discovered, a determination will be made whether the conviction is related to the position for which the individual is applying or would present safety or security risks before an employment decision is made. A criminal conviction does not necessarily automatically bar an applicant from employment. Eligibility to Work In order to comply with US Homeland Security Department regulations, all employees must complete an I-9 form in Workday prior to or no later than the first day of work and bring originals (no photocopies) of their supporting documentation to Human Resources no later than the 3rd business day of employment. Failure to have a completed I-9 form on file with the College will result in immediate termination of employment.