Under the direction of the Vice President of Development and Senior Philanthropic Advisor, the Database and Analytics Manager (Database Manager) is responsible for leading the effort to benchmark current information management practices against industry best practices, evolving The Community Foundation's current information systems and processes to higher levels of efficiency and maturity. The Database Manager is responsible for the administration of The Community Foundation's database: Foundation Information Management System (FIMS). The Database Manager will also be responsible for leading the preparations for and the implementation of database conversion.

ESSENTIAL FUNCTIONS & RESPONSIBILITIES

• Serve as The Community Foundation’s primary database administrator.
• Manage overall system configuration, workflows, data imports/exports, upgrades, and global updates, as well as integrations to the FIMS database.
• Manage new fund opening, closing, and monitoring of activity and balances. Monitors all aspects of fund administration, such as fee codes, asset allocations, and fund advisor updates. Coordinates with staff to ensure administrative accuracy.
• Streamline data management and system. Audit funds for accuracy and compliance quarterly. Manage pledge administration.
• Manage the administration of the donor portal, DonorCentral NXT, and coordinate with the donor services team to ensure positive donor experience.
• Develop and implement tools for data integrity and accurate evaluation and assessment.
•  Coordinate with the finance and community investment teams on financial data reporting, analysis, data mining, business intelligence, dashboards, and processes and procedures –including budget and revenue projection scenarios and investment reporting.
• Coordinate cross-team collaboration between donor services, community investment, and finance on system-related processes, including gift entry, posting, and acknowledgments.
• Coordinate with the director, employee engagement on data management considerations for staff training, creating a shared understanding of system processes, and standard operating procedures.
• Liaise with financial advisors of separately managed accounts, including fund opening, quarterly reporting, and administration.
• Supports community investment team’s administration of Gift Online.
• Serve as project manager for conversion to a new database: including data preparation and transfer, field mapping, conversion timeline, training, and implementation.
• Monitor field for cutting-edge technology that will enable The Community Foundation to effectively and efficiently manage its data.