Pratt Institute's Office of Institutional Advancement has the charge to serve as Pratt Institute's Raiser's Edge subject matter expert. Reporting to the Director of Advancement Operations, the Database Manager (DBM) is responsible for ensuring the accuracy and integrity of constituent data within and related to the Development CRM (database), Raiser's Edge NXT. This role is responsible for data management, technology management and end-user support.
The DBM will assist with reporting, technical support, administering user accounts, implementing guidelines and standards to guide data entry, and ensuring the database and integrations effectively capture constituent information and generate accurate financial and analytical reports. This role will serve as a liaison, communicating across sub-divisions and cross-departmentally on a regular basis to ensure strategies and systems are effective.
Responsibilities of the position include, but are not limited to:
Database Management and Application
Administer accounts, system roles, security settings, and coordinate CRM trainings
Serve as point person for departments and divisions across campus requesting data, updates, training, or database related services
Working with IT and other stakeholders, integrate custom reporting and business intelligence tools, including CRM reporting, Colleague Server Reporting Services, and financial integrations
Integrate and monitor 3rd party applications for changes/upgrades which may impact RE NXT and take the appropriate action
Ensure regular adherence to data privacy, compliance laws and best practices
Conduct regular data integrity checks and perform necessary clean up to ensure overall data hygiene
Develop data standards to ensure consistent and high quality data
Export and share relevant data analytics on an ongoing basis. Inform stakeholders of changes and updates to Raiser's Edge analytics tools. Ensure all changes/updates are communicated out to the respective teams and train if appropriate
Work with software vendors to make improvements and fix bugs in service to all departments
Ensure all Pratt Security measures are maintained including account access/deletion
Assist with the development of relevant guidelines and procedures for front-end and back-end users of Raiser's Edge; communicate guidelines to pertinent staff; create a feedback system
Assist with regular maintenance and reconciliation of donor database
Maintain technical documentation and develop user training and support materials
Work with Director of Alumni Engagement, the Office of the Registrar and the Director of Annual Giving to create a process for quarterly "rollover" of confirmed alumni and parents to be added to or updated in RE.
Data Input and Reporting
Assume role of subject matter expert across all data in Advancement systems to support strategic initiatives and define requirements for reporting and analytical needs
Create and manage constituent records; input and update data points for the effectiveness of each subdivision
Create workflow for import and input of newly-acquired data
Oversee the database related gift reporting acknowledgement process
Responsible for batch uploads, exports, and updates of data; utilizing the Omatic suite - create data maps and dictionaries were appropriate for importing or exporting of relevant data
Verify and fulfill data requests as needed
Create accurate reporting tools for staff by designing and generating queries, reports, and customized outputs
Coordinate with IA, Finance, and Registrar to import large quantities of complex data into RE and/or other solutions as deemed necessary; manage/facilitate database syncing between systems/API's
In partnership with other IA team members prepares the donor recognition lists on behalf of the IA department.
Financial Support and Reporting
Ensure all gift coding and related data entry is accurate for all gifts, including merging of duplicate records
Prepare acknowledgment gift receipts and other gift receipts letters
Resolves gift and transaction issues; processes refunds when necessary; communicates transactional issues and refunds to Finance department
Acts as a secondary liaison to the Finance department, helping maintain consistency of information between RE/Omatic and the general ledger
Oversees gift matching program by verifying and approving requests from matching companies
Works closely with Director of Operations to reconcile the general ledger with Omatic records on a regular basis
Works with IA and Finance leadership to stay current on donor commitments by ensuring pledges are confirmed in writing, generating pledge reports, and writing off pledges as needed
Support reconciliation of funds and other support documents in annual audit processes
Develops and implements processes and procedures for gift tracking and reporting, in collaboration with the Director of Operations
Is driven and self-motivated, able to initiate and complete assigned projects and tasks independently
Is able to work collaboratively with teams from various departments
Has strong communication skills and can translate technical information to non-technical audiences and communicate with NXT users to understand their needs
Is able to troubleshoot NXT issues in person, by phone or email
Has excellent time management skills-successful at juggling competing requests and priorities
Possesses excellent team-working and interpersonal skills; is comfortable working with a wide range of external stakeholders, ranging from high level donors to first time visitors
Is trustworthy and able to act with sensitivity and discretion while working with confidential information
Required Education and Experience:
A bachelor's degree is required
Demonstrated experience serving as a super user and administering a comprehensive CRM (some knowledge of and experience with Raiser's Edge highly preferred).
Experience with report-writing technology including Excel and Microsoft Access. Hands-on experience with Crystal Reports, and other Moves Management tools highly preferred
Three to five (3-5) years of working experience with a complex database system in an Advancement environment with heavy customer service emphasis
Demonstrated experience in organizing, maintaining, managing, troubleshooting, and interacting with computer software systems
Demonstrated experience performing in a liaison role across multiple business departments and with outside vendors and partners
Raiser's Edge administration (highly preferred)
Advanced SQL administration
Knowledge of Data Management best practices
Knowledge of user interface usability best practices
Advanced Microsoft Excel 2010/2013/2016
Software Development Life Cycle
Please submit your cover letter and resume. If you are selected for an interview, please be prepared to provide at least 5 References via our on-line reference tool system. At least 2 of your References must be, or have been, your direct managers.
Equal Employment Opportunity Statement
We are an equal opportunity employer and do not discriminate in hiring or employment on the basis of race, color, religion or belief, national or ethnic origin, citizenship, marital or domestic partnership status, sexual orientation, gender identity or expression, age, disability, military or veteran status, or any other characteristic protected by federal, state, or local law. Pratt Institute recognizes and values the benefits of a diverse workforce.
Internal Number: 114805948
About Pratt Institute
The mission of Pratt Institute is to educate artists and creative professionals to be responsible contributors to society. Pratt seeks to instill in all graduates aesthetic judgment, professional knowledge, collaborative skills, and technical expertise. With a firm grounding in the liberal arts and sciences, a Pratt education blends theory with creative application in preparing graduates to become leaders in their professions. Pratt enrolls a diverse group of highly talented and dedicated students, challenging them to achieve their full potential.