Direct Marketing Data Assistant

Position Summary

The Direct Marketing Data Assistant is responsible for helping with the coordination and execution of data sets for the University Annual Giving & Stewardship Direct Marketing team. The incumbent will work independently to pull donor data to generate audience lists for multi-channel appeals.

Responsibilities

• Create accurate and complex data lists (approximately 350 per year) for multi-channel marketing efforts.
• Build and maintain audience segmentation queries in Snowflake for direct mail, email, social media, and text campaigns.
• Execute data requests on time to ensure that Direct Marketing appeals drop on schedule.
• Aid in data validation for campaigns, including verifying donor records within Salesforce Ascend and the legacy system Ellucian Advance.
• Investigate and troubleshoot data issues by analyzing query logic and applying problem-solving skills.
• Document query logic and maintain clear workflows for repeatable processes.
• Ensure that information security and privacy standards are met, and that data governance standards are upheld.
• Participate in the Office of Engagement, University Annual Giving & Stewardship, Operations, and External Relations meetings as needed.

Minimum Qualifications

• Bachelor's degree with one year of experience.
• Solid understanding of relational database concepts and ability to write SQL queries involving joins, CTEs, and conditional filtering.
• Comfortable troubleshooting query results and explaining logic clearly.
• Strong attention to detail and ability to manage multiple tasks independently.
• Proficient in computer applications, strong working knowledge of constituent databases (CRM) and software programs, especially SQL.

Preferred Qualifications

• Experience with SQL, Oracle Database, Snowflake, Excel, Salesforce CRM, Ellucian Advance.