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.