Philanthropy Database Administrator

Villa Esperanza Services
Pasadena, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 50K

Job location

Pasadena, United States of America

Tech stack

Microsoft Word
Microsoft Excel
Adobe Acrobat
Google AdWords
Spreadsheets
Databases
Data Cleansing
Database Queries
Lookup Table
Mailing List
Microsoft Office
Conversion Tracking
Clover
Squarespace
Backend

Job description

The Philanthropy Database Coordinator serves as the primary administrator and expert for the DonorPerfect (DP) database, including the day-to-day management and maintenance to ensure the integrity, security, and quality of all data. In addition to the day-to-day management of the database, which includes daily implementation of gift/pledge processing and data entry activities for Villa Esperanza, this position is responsible for strengthening standard operating procedures for data entry and database usage to ensure consistency. The Database Coordinator provides high level administrative support to the team, including events, and works closely with the finance department with reconciliation of monies. The ideal candidate enjoys spreadsheets and data queries and will be looking for a heads-down, self-driven role running reports and maintaining clean records, while taking pride in making a difference in the community and being part of a team., * Serve as the primary administrator and expert for DonorPerfect (DP) database, including managing user access and system permissions.

  • Oversee the day-to-day management and regularly scheduled maintenance of the donor database to ensure the integrity, security, and quality of all data.
  • Manage data imports and exports from various sources, such as online donation platforms, event software, etc., ensuring seamless integration.
  • Work with IT to create an organization-wide work application and database for ease of outcome and program data collection.
  • Record and track all donor gifts/pledges weekly.
  • Improve the workflow related to the collection of demographic forms.
  • Improve workflow of grant expenditures between grant team, programs and finance.
  • Support Philanthropy team with data inquiries and reports (e.g., gift lists, donor lists, mailing lists, etc.).
  • Reconcile end of the month deposit batches and Capital Campaign tracking with finance.
  • Using DP, OneCause, and Clover, provide technical support to the team in preparation of events.
  • Manage registration, check-in, cashiering, auction platform and checkout for events.
  • Responsible for the maintenance and updates of the website; enhance SEO to boost performance.
  • Manage Google Ads and all back-end development for online review sites such as Yelp, Google, etc.
  • Versed in weekly processing of checks and donor acknowledgments (thank you letters), notifications, and pledge letters.
  • Other duties/special projects as assigned such as: administrative assistance, attend team staff meetings, maintain confidentiality of clients, families, donors, etc., handle other tasks as assigned.

Salary Range: $21.00 - $24.00/hour, DOE.

Schedule: Monday - Friday, 8:30 AM - 5:00 PM, 40 hours per week.

Requirements

Do you have experience in VLOOKUP function?, Do you have a Trade school?, * To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Associate degree (A. A.) or equivalent from a two-year college or technical school; or two years of related experience and/or training; or equivalent combination of education and experience.
  • Experience maintaining a database or CRM including data cleansing, back up and audits.
  • Familiarity with database query structure.
  • Proficiency in Microsoft Office, particularly Excel (VLOOKUP, XLOOKUP) and Word.
  • Proven ability to effectively manage multiple projects and meet deadlines.
  • Good written and verbal communication skills.
  • Detailed-oriented and organized.
  • Problem solver willing to help yourself and others overcome challenges and roadblocks.
  • Team player, willingness to work collaboratively with both internal and external stakeholders.
  • Ability to apply common sense understanding to conduct instructions furnished in written, oral, or diagram form.
  • High level of integrity, diplomacy and initiative.
  • Satisfactorily complete a background fingerprinting clearance from DOJ/FBI Community Care Licensing/Dept. of Social Services and California Department of Public Health.
  • Satisfactorily complete a physical and Tuberculosis (TB) screenings.

Preferred Skills

  • Experience with DonorPerfect
  • Experience with Squarespace
  • Familiarity with implementation of SEO strategies
  • Knowledge of Adobe Acrobat Professional
  • Previous customer service experience, * How many years of Database Administration do you have?
  • Are you able to meet the schedule of Monday - Friday 8:30 AM to 5:00 PM (40 hrs/week)?

Education:

  • Associate (Required)

Experience:

  • Microsoft Office: 2 years (Required)

Benefits & conditions

Pulled from the full job description

  • Referral program
  • 403(b) matching
  • 403(b)
  • Health insurance
  • Retirement plan
  • Paid time off
  • Vision insurance, * Medical, Dental, and Vision Insurance
  • Retirement plans
  • PTO Accrual
  • Sick Leave
  • Employee Referral Program

About our organization: Villa Esperanza Services is a nonprofit organization dedicated to empowering children, adults, and seniors with special needs. Our mission is to provide love, care, and hope for individuals with intellectual/developmental disabilities (I/DD) and their families. We create a transformative environment to empower neurodivergent individuals to reach their fullest potential and lead fulfilling lives.

At Villa, we are passionate advocates working to forge pathways to a lifetime of independence and hope for people with I/DD. Villa offers a wide range of programs for individuals with I/DD in Los Angeles and Ventura Counties. Our range of services for children includes The Villa School, the Hjelte-Phillips Speech and Language Center, an Occupational Therapy Clinic, and a Behavioral Therapy Center. For adults, we offer "Person-Centered" services, including Adult Day Programs, a Community Integration Program, Employment Services, and our Residential Program, which encompasses group homes and an Independent Living Skills Program.

Job Type: Full-time

Pay: $21.00 - $24.00 per hour

Benefits:

  • 403(b)
  • 403(b) matching
  • Dental insurance
  • Flexible spending account
  • Health insurance
  • Life insurance
  • Paid time off
  • Referral program
  • Retirement plan
  • Vision insurance

Apply for this position