Database Research

2 weeks ago


Cleveland, United States Case Western Reserve University Full time

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; Bachelors degree preferred.


REQUIRED SKILLS

  1. 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.
  2. Prior experience in computerized records management is mandatory. Preference is given to database management in a non-profit fund-raising environment.
  3. Working knowledge of standard research references, including the World Wide Web, is preferred.
  4. 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.
  5. Ability to judge quality of information received and to act on own judgment.
  6. Ability to maintain logical and meticulous attention to detail at all times under all conditions. Love of detail work is mandatory.
  7. Strong proof-reading skills are mandatory.
  8. Ability to communicate well with university staff members on all levels is mandatory.
  9. Must understand and adhere to confidentiality.
  10. Must possess a high level of discretion, maturity, and motivation.
  11. Must be able to set priorities, exercise initiative and work effectively without close supervision.
  12. Absolute accuracy in typing and spelling is mandatory. Ability to type quickly and accurately.
  13. Ability to interact with colleagues, supervisors, and customers face to face
  14. Ability to meet consistent attendance.


WORKING CONDITIONS

  • General office working environment. This position is eligible for the staff hybrid work program.


BENEFITS

  • Over two weeks of paid vacation, paid sick days, 12 paid holidays (not including closing between 12/26 and 12/31), and summer hours (end at 3 pm on Fridays)
  • Tuition Waiver
  • Free gym access and counseling services


  • Cleveland, United States The Sherwin-Williams Company Full time

    The Sherwin-Williams Company Senior Database Developer Cleveland , Ohio Apply Now The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch...


  • Cleveland, United States NESCO Inc Full time

    Job Description: Senior Database Developer Responsibilities: Strategy & Planning: Collaborate with business units to elicit and analyze project requirements. Assess technical requirements and conduct feasibility and cost/benefit analyses. Plan and coordinate tasks, reporting progress, and liaising with development teams. Identify, design, and implement...


  • Cleveland, United States Emerald Resource Group Full time

    Job Description: Senior Database Developer Location: Cleveland, OH, United States Schedule: Hybrid Position Overview: The Senior Database Developer plays a pivotal role in the design, development, implementation, and maintenance of database solutions supporting web applications. Focused on Oracle database applications development, batch processing, and...


  • Cleveland, United States Fortune 500 companies Full time

    The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following...


  • Cleveland, United States Integrated Talent Strategies Full time

    Integrated Talent Strategies (ITS) is seeking a Senior Database Developer to work in the Cleveland, OH area. This is a direct hire position that offers a variety of great benefits, including health insurance, 401(k), and paid time off. JOB DESCRIPTION The Senior Database Developer position is responsible for the design, development, documentation,...


  • Cleveland, United States Fortune 500 Companies Full time

    The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following...


  • Cleveland, United States Fortune 500 Companies Full time

    The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following...


  • Cleveland, United States Fortune 500 Companies Full time

    The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following...


  • Cleveland, United States The Sherwin-Williams Company Full time

    The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following...


  • Cleveland, United States Fortune 500 companies Full time

    The Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot existing applications following...


  • Cleveland, United States Integrated Talent Strategies Full time

    Integrated Talent Strategies (ITS) is seeking a Senior Database Developer to work in the Cleveland, OH area.  This is a direct hire position that offers a variety of great benefits, including health insurance, 401(k), and paid time off.   JOB DESCRIPTION The Senior Database Developer position is responsible for the design, development, documentation,...


  • CLEVELAND, United States MetroHealth Full time

    **Location:** **METROHEALTH MEDICAL CENTER** **Biweekly Hours:** **80.00** **Shift:** **8-4:30** **The MetroHealth System is redefining health care by going beyond medical treatment to improve the foundations of community health and well-being: affordable housing, a cleaner environment, economic opportunity and access to fresh food, convenient...


  • CLEVELAND, United States MetroHealth Full time

    **Location:** **METROHEALTH MEDICAL CENTER** **Biweekly Hours:** **80.00** **Shift:** **M-F, 8-5:00pm** **The MetroHealth System is redefining health care by going beyond medical treatment to improve the foundations of community health and well-being: affordable housing, a cleaner environment, economic opportunity and access to fresh food,...


  • CLEVELAND, United States MetroHealth Full time

    **Location:** **METROHEALTH MEDICAL CENTER** **Biweekly Hours:** **80.00** **Shift:** **8-4:30** **The MetroHealth System is redefining health care by going beyond medical treatment to improve the foundations of community health and well-being: affordable housing, a cleaner environment, economic opportunity and access to fresh food, convenient...

  • Research Associate I

    2 weeks ago


    Cleveland, United States Case Western Reserve University Full time

    Research Associate I (Laboratory Research) Case Western Reserve University: SCHOOL OF MEDICINE: School of Medicine - Main Campus: Nutrition Location: BRB 9th Floor Open Date: Mar 18, 2024 Description: Date: March 2024 Department: Nutrition School: Medicine Location: Biomedical Research Building (BRB) Supervisor Name and Title: Peder Lund, PhD, Assistant...

  • Product Designer

    5 days ago


    Cleveland, United States Flexjet Full time

    Current job opportunities are posted here as they become available. Flexjet is on a mission to redefine the aviation industry through meaningful and user-centered technology, and we are in search of a Product Designer & Researcher ready to join this challenge. The ideal candidate has experience as a usability practitioner conducting user research, which...

  • Product Designer

    1 month ago


    Cleveland, United States Flexjet Full time

    Job DescriptionJob DescriptionThe Role:Flexjet is on a mission to redefine the aviation industry through meaningful and user-centered technology, and we are in search of a Product Designer & Researcher ready to join this challenge. The ideal candidate has experience as a usability practitioner conducting user research, which includes developing user personas...


  • Cleveland, United States Cleveland Clinic Full time

    Join the Cleveland Clinic team, where you will work alongside passionate caregivers and provide patient-first healthcare. Cleveland Clinic is recognized as one of the top hospitals in the nation. At Cleveland Clinic, you will work alongside passionate and dedicated caregivers, receive endless support and appreciation, and build a rewarding career with one of...


  • Cleveland, United States Suncap Technology Full time

    Location : Cleveland , OH, HybridThe Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot...


  • Cleveland, United States Suncap Technology Full time

    Location : Cleveland , OH, HybridThe Senior Database Developer position is responsible for the design, development, documentation, implementation, and maintenance of database development in support of web applications for Sher-link projects, with a focus on Oracle database applications development, batch processing and reporting. Maintain and troubleshoot...