Philanthropy Associate Data Marketing Specialist Annual Giving Program at Northwestern Memorial Healthcare | Chicago, IL | $33/hr – $48/hr

Philanthropy Associate Data Marketing Specialist Annual Giving Program

Chicago, IL (On-site)

$33/hr – $48/hrMid Level3+ years expFull time

Posted 6 weeks ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Own data segmentation and audience targeting for annual giving while maintaining HIPAA compliant donor records and high data hygiene across large databases.

Data Hygiene & Segmentation: sanitize large datasets, run audits, and maintain accurate donor lists for mailings and digital campaigns.
Email Journey Building: design automated welcome, renewal, and patient acquisition flows with bounce and sender-reputation monitoring.
Cross-Team Data Stewardship: collaborate with Annual Giving and Donor Communications to meet deadlines and improve segmentation standards.

Job Description

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.
Data Integrity & Hygiene:
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.
Adhere to Northwestern Medicine privacy, communication, and data policies to ensure HIPAA compliance and data integrity.

Email Journey Building & Automation:
Develop, manage, and optimize automated email workflows, including welcome sequences, renewal, and patient acquisition campaigns.
Monitor and process hard bounces, soft bounces, and spam complaints to maintain a high sender reputation.

Project Management
Collaborate with Program Manager, Annual Giving Program to ensure deadlines are met, clarify quality expectations, and share opportunities for improvement.
Balance work for multiple concurrent projects ensuring all get completed in a timely, accurate manner.
Collaborate closely with the Annual Giving and Donor Communications teams, providing data expertise.
Proactively engage in problem-solving and seek assistance as needed.
Establish and implement standards to streamline processes and minimize errors and cultivate a sound understanding of NMF’s annual giving program and industry standards for donor segmentation best practices.,Receive performance feedback openly, translating critiques into immediate operational improvements.