PROJECT SUMMARY

The Donor Data Management Intern will collaborate with and support the development services team with a project that will standardize the organization’s member and donor data. The outcome of this project impacts the ability for our partners in the Development and Marketing teams to pull accurate reports and better connect with and steward our top donors and members.

This internship provides an opportunity to someone with a data mindset, who enjoys working with spreadsheets, and an aptitude to learn best practices in database management.

National Trust internships are temporary experiential learning opportunities with no expectation of employment at the conclusion of the internship.

For this internship, the National Trust is offering a stipend of $4,000 to help offset expenses. The period of the internship would be from approximately June 10 – August 2, for approximately 28 hours per week (some flexibility of schedule available).

(Based on candidate availability and skill sets, this project may be combined with our Planned Giving Internship to provide a broader exposure within our Development division.)

DUTIES

• Help manage a project that will improve donor communications by updating fund descriptions and fund source codes in the CRM.
• The funds in the system will be re-categorized according to nomenclature that will allow leadership to more readily identify key information about the funds in our reports. The intern will assist in filtering through an Excel document with all of the transactions and will create a new field that will summarize gifts according to the program and spending account they belong to.
• Support update and data migration of historical gift records and agreements into the CRM, posting historical gift documentation to the top 200 donors' records so that fundraisers can view the history directly from the CRM versus having to search other files for the information.

EDUCATIONAL VALUE TO THE INTERN

The intern will gain experience under the mentorship of respected business professionals and non-profit database managers in an educational setting at one of the nation’s leading arts & cultural and non-profit advocacy organizations. The intern will also have the opportunity to participate in educational programming offered via the National Trust for Historic Preservation’s organization-wide internship program. Students may also be eligible for college or graduate school academic credit at the discretion of their institution.

Specifically, the intern will gain knowledge in the following areas:

• CRM Database processes : Data extraction, hygiene and imports
• Intermediate Microsoft Excel formulas and functions (VLOOKUP, Pivot Tables, etc.)

At the end of the project the intern will have produced a project plan and data cleaning project which can be added to their professional portfolio in support of their future career pursuits.

QUALIFICATIONS

• Proficiency with Microsoft Office, Word and Excel
• Minimum of 20 hours per week
• Basic analytical and problem-solving skills, including issue identification and prioritization. Basic project-organization skills.
• Excellent attention to detail.
• Ability to collaborate and achieve results with supervision, including ability to interact professionally with key internal and external stakeholders as needed. Public contact and ability to work successfully near others required.
• Strong organizational skills required, with ability to prioritize, multi-task efficiently, and meet deadlines in a timely fashion
• Ability to adapt and be flexible in a dynamic work environment. Ability to work effectively with frequent interruptions required. Able to handle frequently changing and/or unscheduled tasks with accuracy.
• Strong verbal and written communication skills. Friendly and professional demeanor on the phone and in writing, with ability to speak and write clearly in English. Bi- lingual language skills a plus.
• Ability to work effectively with culturally diverse colleagues; connections to or experience helping to engage culturally diverse audiences and partners a plus. Bi- lingual language skills (especially English/Spanish) a plus.
• Proficiency with Microsoft Office products required, including Outlook, Word and Excel. Familiarity with other software a plus.
• Ability work effectively in a remote environment, maintaining productivity and communications to meet deadlines and goals, is required.
• Bachelor’s level studies (or equivalent years of experience) required; current or rising juniors, seniors or graduate students preferred. Studies or demonstrated interest in related subject matter preferred. Preference given to those pursuing degrees in business administration, finance, data science, economics or psychology.

NOTE: If applying to multiple internships, please do not delete previous resumes or cover letters, simply click Add to upload new/additional versions for each application.

https://www.idealist.org/en/nonprofit-internship/4be3ee52e19c466382d845375f02c2c4-donor-data-management-internship-national-trust-for-historic-preservation-washington?utm_source=symplicity&utm_medium=feed&utm_campaign=listings-api