Direct Marketing Data Assistant, Federal Work Study

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Construct, organize, and sustain extensive donor and campaign datasets using Excel.

• Utilize pivot tables, VLOOKUP/XLOOKUP, conditional formatting, and various formulas to categorize audience segments.

• Establish and oversee Excel-based A/B testing worksheets.

• Divide audience lists, monitor test variables, and compile results for campaign evaluation.

• Develop and manage audience segmentation queries in Snowflake.

• Support campaign data validation by confirming donor records in Salesforce Ascend.

• Examine and resolve data issues through query logic analysis.

• Document query logic and uphold clear, repeatable workflows.

• Offer office assistance, customer service, data entry, and utilize standard office software and systems.

• Participate in occasional meetings and programs that may require travel.

⛳️ Requirements

• Only Federal Work-Study students are eligible.

• Currently enrolled in a degree program in Data Science, Business Analytics, Information Systems, Computer Science, or a related field.

• Must be a current undergraduate or graduate student at UVA eligible for student employment and work study.

• Proficient, practical Excel skills, including formulas, pivot tables, lookup functions, and data formatting for large datasets.

• Strong comprehension of relational database principles.

• Capable of writing SQL queries that involve joins, CTEs, and conditional filtering.

• Comfortable addressing query results and articulating logic clearly.

• Excellent attention to detail and ability to handle multiple tasks autonomously.

• A resume and one academic reference are required.

• Able to work a minimum of 10 hours and a maximum of 20 hours per week.

• Must have work-study eligibility for the 2026–27 academic year.

🏝️ Benefits

• Remote-first learning environment.

• Fully remote work arrangement.

• Opportunity to gain insights into data-driven marketing strategies within the fundraising and higher education sectors.