Federal Work Study - Direct Marketing Data Assistant (Student Wage)

University of Virginia•Charlottesville, VA

13d•Remote

About The Position

University Annual Giving in the Office of Engagement is seeking a detail-oriented and motivated work study student employee to join our Direct Marketing team. This role is ideal for someone with strong, practical Excel skills, including formulas, pivot tables, and data cleanup, and an interest in supporting initiatives that enhance donor engagement and campaign performance. We offer a congenial, remote-first learning environment and welcome the opportunity to employ talented University of Virginia students who want to learn more about data-driven marketing strategies within the fundraising and higher education sectors. Perform specialized office support functions or services that require some training, skill, or experience. Duties include providing customer service and specific information, data entry and use of standard office software programs & systems, work within established guidelines and policies. Limited supervision is provided; ability to perform a wide range of duties.

Requirements

Currently pursuing a degree in Data Science, Business Analytics, Information Systems, Computer Science, or related field.
Strong, hands-on Excel skills, including formulas, pivot tables, lookup functions, and data formatting for large datasets.
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.
Applicants must be a current UVA undergraduate or graduate student eligible for student employment and work study.
Federal Work-Study eligible
Resume and one academic reference required.

Responsibilities

Build, clean, and maintain large donor and campaign datasets in Excel, including use of pivot tables, VLOOKUP/XLOOKUP, conditional formatting, and formulas to organize audience segments for direct mail, email, social media, and text campaigns.
Set up and manage Excel-based A/B testing worksheets, including splitting audience lists, tracking test variables, and summarizing results for campaign review.
Build and maintain audience segmentation queries in Snowflake for direct mail, email, social media, and text campaigns.
Assist in data validation for campaigns, including verifying donor records within Salesforce Ascend.
Investigate and troubleshoot data issues by analyzing query logic and applying problem-solving skills.
Document query logic and maintain clear workflows for repeatable processes.