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

The Rector & Visitors of the University of Virginia

Where
Charlottesville, VA
Pay
$19.50 an hour

Posted 42 days ago· Checked live at The Rector & Visitors of the University of Virginia 4 days ago

Stale: open 42 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what The Rector & Visitors of the University of Virginia asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on The Rector & Visitors of the University of Virginia's own hiring page 4 days ago.
What is the job?
***** Federal Work Study Students Only***** This position will remain open for applications for up to 30 days from the posting date. However, please note that the position may be filled before the 30-day period ends if a suitable candidate is selected. Interested applicants are encouraged to apply as soon as possible, as the posting may close early once the hiring process is complete.
What does it pay?
$19.50 an hour, as the posting states.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

***** Federal Work Study Students Only*****

This position will remain open for applications for up to 30 days from the posting date. However, please note that the position may be filled before the 30-day period ends if a suitable candidate is selected. Interested applicants are encouraged to apply as soon as possible, as the posting may close early once the hiring process is complete.

Key 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.

Qualifications

  • 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.

Rate of pay

$19.50/hour for up to 20 hours a week; a minimum of 10 hours a week. Fully-remote.

Minimum requirements

Resume and one academic reference required.

Education: Current UVA student. Federal Work-Study eligible

Experience: None

Licensure: None