Job Description
As a UW employee, you have a unique opportunity to change lives on our campuses, in our state and around the world. UW employees offer their boundless energy, creative problem-solving skills and dedication to build stronger minds and a healthier world.
UW faculty and staff also enjoy outstanding benefits, professional growth opportunities and unique resources in an environment noted for diversity, intellectual excitement, artistic pursuits and natural beauty.
UW Medicine Advancement has an outstanding opportunity for a Associate Director for Major Gift Data Strategy and Reporting to join their team.
At UW Medicine, we work to improve health for all people through excellence in clinical, research, and education and training programs. As the only comprehensive clinical, research and learning health system in the five-state WWAMI (Washington, Wyoming, Alaska, Montana, Idaho) region, UW Medicine provides the most up-to-date care for each individual patient, leads one of the world’s largest and most comprehensive medical research programs, and provides innovative learning programs for students, trainees, and practitioners in the health professions.
The passionate, 70-person team at UW Medicine Advancement works collaboratively to connect donors with meaningful opportunities to enhance patient care, expand educational opportunities and advance research at UW Medicine. This inspiring, challenging and rewarding work provides team members an opportunity to grow their careers, while making a difference in people’s lives, in our community and around the world. In the 2022 fiscal year, UW Medicine Advancement raised $284 million in gifts and private grants (46 percent of the University of Washington’s total) from nearly 14,000 donors to support the mission of UW Medicine. You can find out more about UW Medicine Advancement’s priorities and office culture on our career website: https://give.uwmedicine.org/careers/
The Associate Director for Major Gift Data Strategy and Reporting is responsible for managing data systems and strategy with the aim of identifying prospective major gift donors through UW Medicine’s constituency, which includes donors, grateful patients, alumni, volunteers and community members. This role will create and execute processes to ensure that data on identified prospects are efficiently and compliantly delivered to fundraisers and leadership.
The Associate Director will create reports and visualizations to demonstrate the impact of the fundraising efforts of UW Medicine Advancement. Additionally, the Associate Director will be reporting on engagement activity between Advancement and UW Medicine faculty partners.
KEY RESPONSIBILITIES
Program Development and Management:
• Manages SQL patient fundraising database, Bridge, including developing relationships with data partners in UW Medicine IT and University Advancement, managing and updating the patient data extract, monitoring data integrity, writing queries and stored procedures to create efficiencies in accessing key data, and troubleshooting any data transformation issues.
• Research and make recommendations for technology improvements, including a new CRM solution to manage information protected by HIPAA.
• Collaborate with the faculty engagement (Engage) team on managing data intake and data reporting within HIPAA-compliant environments while creating end-user friendly solutions for data collection.
• Create visualizations and reporting for faculty engagement resources including performance dashboards, prospect heat maps and other resources, all within HIPAA-compliant environments.
• Independently consult and advise on, as well as create, internal products and processes that improve the donor pipeline, from beginning (identifying new potential prospects) to end (demonstrating the impact of philanthropy to current donors).
• Independently develop ad hoc project analyses and visualizations supporting faculty engagement, annual philanthropy, prospect discovery, fundraiser metrics, and related activity.
• Consult with internal stakeholders to help define functional requirements for major information initiatives. Analyze and identify opportunities to expand and improve data processes in support of long-range automated and self-service information needs.
• Serve as a subject matter expert to teams who manage the Advancement data warehouse and create tools/reports; articulate nuance and business practices related to UW Medicine prospect data, beats, grants, gift utilization, and funds; advise on related data structures and usage.
• Advise and collaborate with other strategists across academic units to bring rigor to their data analysis projects.
• Advise on and support data governance policies and practices articulated by the Advancement Data Governance Oversight Committee.
• Promote a mutual understanding of data elements and reliable data standards through documentation and other learning opportunities.
Other duties as assigned.
MINIMUM QUALIFICATIONS
• Bachelor's degree and four years of experience in advancement/development, business intelligence, or related field.
Additional requirements:
• Proficiency in SQL and Excel
• Proficiency with Tableau, Power BI, or other data visualization or business intelligence software
Equivalent education and/or experience may substitute for minimum requirements.
DESIRED QUALIFICATIONS
• Knowledge of nonprofit fundraising practices
• Experience with project management
• Experience with donor or customer CRM (customer relationship management) software
CONDITIONS OF EMPLOYMENT
The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select “Apply to this position”. Once you begin an assessment, it must be completed at that time; if you do not complete the assessment, you will be prompted to do so the next time you access your “My Jobs” page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.