Database Analyst I, Business Intelligence
Duke Alumni Engagement & DevelopmentDurham, NC
Reporting to Associate Director of Business Intelligence supporting the University’s foundation fundraising program. Duties include: Oversight of data concerning organizations (focus on foundations and corporations), analysis of Duke’s organization-based fundraising as well as that by other universities; serve as liaison with peer offices, understanding their databases and how Duke Alumni Engagement and Development’s (AED) database intersects with them; work with foundation fundraisers to support their efforts.
The Office of Foundation Relations (OFR) is a division within AED. OFR supports and coordinates foundation fundraising efforts across the broader university community and works closely with senior administrators, faculty, and peer offices, as well as numerous interdisciplinary institutes and programs. This position will perform multiple tasks/projects simultaneously with a high degree of attention to detail. Demonstrate working knowledge of Duke University’s fundraising management system. Interface with internal customers, using excellent listening skills to understand the organizational needs and solid analytical skills to develop workable solutions that support progress toward organizational goals.
- Manage the prospect management system for organizations: receive team requests; add/delete team members; assist in determining team leadership.
- Coordinate with foundation relations colleagues, Alumni and Development Records, Partnership Resources, and others on data and analytics issues as needed.
- Serve as OFR liaison for the DADD database (alumni, gift, and prospect database).
- Design and implement data analytics projects related to organizations (with emphasis on foundations and corporations) from the Alumni and Development Database (DADD), SPS (sponsored programs database), R-3 (accounting system for Duke), VSE (CASE database), etc. as requested by the OFR team, AED, and the Schools and Units, using data and analytic tools and techniques. Evaluate the underlying available characteristics to respond to specific needs concerning an entity donor record or for various groupings or university/AED priorities, as needed.
- Provide data analysis supporting fiscal and Campaign progress.
- Research data issues to determine possible root causes of the concerns (data entry error, system issue, etc.).
- Research gift and pledge histories, e.g., overdue pledges, missing parent/subsidiary relationships, as needed and reach out to appropriate development officers or peer offices to make corrections, if appropriate.
- Develop a strong understanding of the interaction and differences between DADD and the University’s ledger to be able to analyze data to identify deviations and changes made to the ledger that impact the use of the gift as reflected in DADD.
- Track transactions between DADD and the Duke General ledger when questions arise as to how we “count” versus “account” for gifts.
- Train colleagues on systems and databases (DADD, SPS, R-3, VSE, Foundation Directory Online).
- Understand and manage organization data integrity (primarily foundations and corporations) and provide analysis to enhance fundraising efforts. Make recommendations based on institutional, departmental, and PI-specific grant seeking trends and results.
- Evaluate budgeting implications for curricular and co-curricular programs to assist OFR and Partnership Resources officers in their fundraising efforts.
- Assist frontline fundraisers with institutional data and financial information required for grant proposals.
- Assist frontline fundraisers with complex proposal budgets and financial reporting.
- Serve as OFR liaison to the Grant Management/Research Administration community; attend university-wide grants management meetings.
- Maintain tracking systems for proactive dissemination of corporate and foundation information and track requests for responsive corporate and foundation prospect research to provide for team metrics.
- Serve as OFR data liaison to School and Unit fundraisers and provide temporary reporting and other support regarding organizations to schools and units when they experience employment turnover or do not have the expertise within their area to support their Development functions.
Required: knowledge of Microsoft Office Suite products, internet search skills, and knowledge of databases; strong research and analytical skills. Prefer knowledge of Duke Systems, including DADD, SPS, R-3
Education: Work requires a bachelor’s degree in mathematics, computer science, or a computer related field or the equivalent coursework or technical training.
Experience: Work requires 2 years of progressive programming or database administration experience to include design, implementation, tuning, backup, recovery, modification and reorganization of relational databases for a complex computer network. Or an equivalent combination of relevant education and/or experience.
- Master’s degree preferred
- Five or more years of experience with data analytics in fundraising or related field. Accounting, budgeting, and financial reporting an asset.
Duke is an Affirmative Action/Equal Opportunity Employer committed to providing employment opportunity without regard to an individual’s age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or veteran status.
Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends on the robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.
To apply for this job please visit careers.duke.edu.