Philanthropy Associate Data Marketing Specialist Annual Giving Program

Responsibilities

• Data Segmentation
• Query donor database to segment audiences for targeted appeals.
• Pull complex donor and patient lists for mailing and digital marketing campaigns, ensuring that all inclusions and exclusions are appropriately applied.
• Perform complex data clean up using Excel and our CRM to support the annual giving direct response program with their solicitations and stewardship (direct mail, email, phone) communications.
• Ensure accuracy in donor records, maintaining database security, particularly around patient data, and implementing data cleaning protocols.
• Maintain and update donor information in the database to ensure data accuracy and integrity.
• Regularly audit database records and reconcile discrepancies to uphold data quality.
• Incorporate data hygiene feedback to ensure mailing lists are of highest quality.
• Sanitize, refine, and validate large datasets (25K-500K+ rows) in Excel utilizing advanced data cleaning skills, including vlookups, text manipulation formulas, and if statements.
• Balance work for multiple concurrent projects ensuring all get completed in a timely, accurate manner.