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.
• Assist 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.
• Other duties as assigned.
• Collaborate with cross-functional teams to support campaign initiatives.

Requirements

• Bachelor's degree with one year of experience.
• Ability to work independently and meet overlapping deadlines.
• 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.
• Ability to format and organize large datasets in Excel while maintaining data integrity.
• 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

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

Benefits

• This is an exempt-level, benefited position. Learn more about UVA benefits.