Direct Marketing Data Assistant

Location Charlottesville, Virginia, United States of America Category Finance, Business \& Human Resources The Rector \& Visitors of the University of Virginia Job Id R0084462 Job Type Full time External Relations at the University of Virginia (UVA) is seeking a highly qualified candidate to fill the role of Direct Marketing Data Assistant. The University of Virginia has a strong and reputable advancement community, boasting effective, results\-oriented, and resourceful professionals. Our community comprises a robust central advancement organization, 12 University schools, and more than 25 University\-related programs. We offer a wide variety of career opportunities, as well as an outstanding environment for professional growth and development. Position Summary The Direct Marketing Data Assistant is responsible for helping with the coordination and execution of data sets for the University Annual Giving \& Stewardship Direct Marketing team. The incumbent will work independently to pull donor data to generate audience lists for multi\-channel appeals. This role is ideal for someone with practical SQL and Excel skills who is detail\-oriented and can manage multiple projects and deadlines simultaneously. The Direct Marketing Data Assistant will report to the Direct Marketing Strategist. 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. Minimum Qualifications 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. Preferred Qualifications Experience with SQL, Oracle Database, Snowflake, Excel, Salesforce CRM, Ellucian Advance. Physical Demands This is primarily a sedentary job involving extensive use of desktop computers. The job does occasionally require traveling some distance to attend meetings, and programs. Salary Range The anticipated hiring range is $57K \- $64K year Position Type \& Work Location This is an exempt\-level, benefited position. Learn more about UVA benefits. This is a restricted position, which is dependent on funding and is contingent upon funding availability. 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. Depending on the type of position and work performed, or as deemed by manager, some positions may be required to work intermittently in a shared office space located in Charlottesville, Virginia (VA). 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. About UVA and the Community To learn more about UVA and in the Charlottesville area, visit UVA Life and Embark CVA. Application Timeline Application review will begin after July 3rd, 2026 Additional Requirements Background checks will be conducted on all new hires prior to employment. This position will not consider candidates who require immigration sponsorship now or in the future. How to Apply Please apply online, by searching for requisition number R0084462\. Complete an application with the following documents: Internal applicants may search and apply for jobs on theUVA Internal Careers website. Resume Cover Letter Upload all materials into the resume submission field. You can submit multiple documents into this one field or combine them into one PDF. Applications without all required documents will not receive full consideration. Reference Check Process Reference checks will be completed by UVA’s third\-party partner, SkillSurvey, during the final phase of the interview. Five references will be requested, with at least three responses required. Contact For additional information about the position, please contact Sandi Hall, Senior Associate Director for Staff Success, at eym5wh@virginia.edu. For questions about the application process, please contact Bill Crane Senior HR recruiter at Xer5ff@virginia.edu The University of Virginia is an equal opportunity employer. All interested persons are encouraged to apply, including veterans and individuals with disabilities. Click here to read more about UVA’s commitment to non\-discrimination and equal opportunity employment. The University of Virginia is an equal opportunity employer. All interested persons are encouraged to apply, including veterans and individuals with disabilities. Learn more about *UVA’s commitment to non\-discrimination and equal opportunity employment**.*