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.

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.
• Education: Current UVA student. Federal Work-Study eligible
• Experience: None
• Licensure: None
• Eligibility: Applicants must be a current UVA undergraduate or graduate student eligible for student employment and work study.
• MINIMUM REQUIREMENTS: Resume and one academic reference required.