Located in a historic neighborhood in the nation's capital, Georgetown offers rigorous academic programs, a global perspective, exciting ways to take advantage of Washington, D.C., and a commitment to social justice. Our community is a tight knit group of remarkable individuals interested in intellectual inquiry and making a difference in the world.
The Office of Advancement supports the mission of Georgetown University, its faculty, and students by developing relationships with key constituencies, connecting with alumni, and working with donors to help them know and understand opportunities for partnership with the university.
The Associate Director , Data and Reporting Services is responsible for leading the reporting function for the Office of Advancement. This team provides the Office of Advancement with data extracts and reports from the University's Salesforce platform (GU360) to make data-driven business decisions and provide accurate forecasting in support of the planning and execution phases of the University's next campaign and ambition to raise $500 million annually by 2025.
The Associate Director, Data and Reporting Services will report to the Director, Reporting Services. The Associate Director is the senior-most member focused on executing project management related to data validation/specifications, report type management, data cleanup, and custom functionality testing, while the Director maintains overall oversight for reporting services and strategies related to reporting functionality for end users.
The Associate Director provides reporting support for the entirety of the Office of Advancement (most frequent interaction occurs with the front line development officers and development associates, prospect management, annual giving, discovery ambassadors, data and analytics and gift administration), as well as key campus partners such as the Dean's offices and Admissions.
The Associate Director will have duties that include, but are not limited to the following:
Collaborates with Reporting Services team members and requestors to understand the needs of complex reporting requests, narrow specifications, and include necessary fields.
Provides excellent customer service and partnership to stakeholders requesting reports.
Uses Transact SQL, Salesforce Reporting Tools, and other 3rd party applications to fulfill complex user report requests.
Consults with the Director, Senior Director, and other stakeholders regarding data for custom requests.
Works independently on assigned requests and adapts, modifies and enhances reports based on the available data and reporting needs of the requester.
Responds to time-dependent and urgent requests from management and OA users within agreed upon deadlines.
Requirements Gathering, Testing, and Documentation
Works closely with the University's Information Services team and Advancements' Chief Data Officer to gather necessary requirements and track changes to reflect in the system.
Tests all custom changes, data cleansing efforts, and upgrades from Salesforce and Affinaquest in the database to avoid user issues and problems with data integration.
Recommends internal Salesforce enhancements and modifications based on user experience and feedback.
Documents data cleanup projects, custom SF functionality development, software vendor updates. and new report templates to ensure compliance with audit requirements.
Salesforce Reporting Environment and Management
Serves as an in-house expert on data knowledge and reporting tools/processes in Salesforce.
Has in-depth knowledge and understanding of data in the system to change or update databases when fields are modified.
Supports the Director in working with internal clients to define project objectives, set up timelines, implement measurable goals, and manage delivery of final project materials to clients.
Monitors, manages, modifies report types and impacted reports, and customizes Affiniquest field to ensure accurate reporting.
Collaborates with University Information Systems to ensure proper organization and accuracy of the report types.
Serves as a key connection point for the Reporting Services team within the Office of Advancement to validate data and develop data cleanup specifications.
Assists the Director, Senior Director, Records team, and Office of Gift Administration to document and develop specifications for data cleansing.
Works proactively to uncover data issues and run reports on a routine basis to limit problems that may arise.
Provides data validation, development of data cleanup specifications for University Information Systems, and documents and retrieves approval of specifications from Senior Director.
Consults with users to provide support and guidance on the best way to leverage available data.
Works to gather business requirements from end users and synthesize those with existing and future data and records storage processes.
Provides data support for users to understand business needs and present options for reporting and presenting data accurately.
At least 3-5 years of experience analyzing data in the setting of complex fundraising and/or sales organizations
Completion of advanced-level coursework in mathematics, statistics, data science or operations
Experience with reporting and manipulating data from Salesforce
High attention to detail, with demonstrated experience managing and understanding large amounts of data
Highly organized, able to work independently, and under pressure to complete multiple requests and competing deadlines
Excellent writing and editing skills; excellent verbal communication skills
Ability to adapt and present information in a variety of formats to meet constituent needs
Knowledge of and experience working with Advancement database/CRM systems
Demonstrated knowledge of operations practices of large fundraising organizations
Expert-level Microsoft Excel and/or Access skills
Functional knowledge of database programming languages such as SQL/SOQL or APEX
Understanding of the Salesforce platform; Salesforce Certified Administrator certification preferred
General knowledge and understanding of data architecture
Advanced understanding of analytical problem solving methodologies
Desire to grow knowledge and skills, along with rapidly advancing trends in the field of data science
Current Georgetown Employees:
If you currently work at Georgetown University, please exit this website and login to GMS ( gms.georgetown.edu ) using your Net ID and password. Then select the Career worklet on your GMS Home dashboard to view Jobs at Georgetown.
Please note that in order to be considered an applicant for any position at Georgetown University you must submit a cover letter and resume for each position of interest for which you believe you are qualified. These documents are not kept on file for future positions.
If you are a qualified individual with a disability and need a reasonable accommodation for any part of the application and hiring process, please click here for more information, or contact the Office of Institutional Diversity, Equity, and Affirmative Action (IDEAA) at 202-687-4798 or firstname.lastname@example.org .
Need some assistance with the application process? Please call 202-687-2500. For more information about the suite of benefits, professional development and community involvement opportunities that make up Georgetown's commitment to its employees, please visit the Georgetown Works website .
Georgetown University is an Equal Opportunity/Affirmative Action Employer fully dedicated to achieving a diverse faculty and staff. All qualified applicants are encouraged to apply and will receive consideration for employment without regard to race, color, religion, national origin, age, sex (including pregnancy, gender identity and expression, and sexual orientation) , disability status, protected veteran status, or any other characteristic protected by law.
Georgetown University offers a wide variety of comprehensive and competitive benefits. Benefits packages include comprehensive health, dental and vision plans, disability and life insurance coverage, retirement savings programs, tuition assistance, voluntary insurance options (including group legal, accident, and critical illness), and much more. Whatever your need, the Office of Faculty and Staff Benefits will be standing by to support you. You can learn more about the benefits offered to eligible faculty and staff at https://benefits.georgetown.edu or view the online interactive benefits guide for more information.
Internal Number: JR07680
About Georgetown University
Established in 1789, Georgetown is the nation's oldest Catholic and Jesuit University. Georgetown is one of the world's leading academic and research institutions, offering a unique educational experience that prepares the next generation of global citizens to lead and make a difference in the world.