Report Writer

Job Family Group: Staff Department/Office: Reporting, Data Analysis and Special Projects (Julie Domel) Time Type: Full time Compensation: $49,848.43-$62,310.54 Please note, starting salaries are based on factors including internal equity, relevant experience, and education. Exemption Status: United States of America (Exempt) Job Description: Reporting to the Assistant Director of Advancement Resources and working closely with the University Salesforce/Affinaquest Administrators in Information Technology Services (ITS), delivers critical reporting and value-added data insights that meet the University's Advancement Office needs. Gives guidance and advice to primary users of constituent data reports, and provides leadership in the planning and implementation of data-related services that support the fundraising goals of both the division and the University. Works primarily with University Advancement Office, the Office of Annual Giving, the Office of Major Gifts & Planned Giving, the Alumni Relations Office, the Office of the President, and the Strategic Communications & Marketing Office to provide a wide variety of reports. Produces mailing lists for the Advancement Division and also all departments on campus. Collaborates with internal partners and produces accurate standardized reports of key insights using Advancement's constituent management platform/CRM (Affinaquest) and Salesforce reporting tools (Apsona). Develops and builds queries, validates and executes ad-hoc reports that answer specific business questions for internal customers. Regularly attends meetings for Annual Giving (AG) and Alumni Relations (AR) teams to better assist in identifying specific needs for data and reporting resolutions. Advises and provides evaluative insights to teams in connection with providing and presenting results. Annual Giving Program Support: Performs data analysis on direct mail and email solicitations. Coordinates and manages all development/direct marketing prospect data pools and coordinates preparation and data segmentation for all integrated marketing. Collaborates to determine donor segments and appeal strategies to ensure efficient creation and production of assets used in direct mail, email,