Note: The job is a remote job and is open to candidates in USA. The University of Virginia is seeking a highly qualified candidate for the role of Direct Marketing Data Assistant. This role involves coordinating and executing data sets for the University Annual Giving & Stewardship Direct Marketing team, focusing on pulling donor data and generating audience lists for various marketing 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
• 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

Skills

• 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
• Experience with SQL, Oracle Database, Snowflake, Excel, Salesforce CRM, Ellucian Advance

Benefits

• This is an exempt-level, benefited position.
• UVA External Relations offers a flexible and hybrid workplace.
• All team members must have access to and maintain a secure home office environment with high-speed internet service and work collaboratively with others using various technologies and tools.
• This position may work from anywhere in the United States, with the expectation of being in Charlottesville, VA a minimum of four times a year at UVA’s expense.

Company Overview