Database Administrator - Vancouver, Canada - Ronald McDonald House BC and Yukon

Ronald McDonald House BC and Yukon

Verified Company

Vancouver, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

About the Organization

At Ronald McDonald House Charities British Columbia and Yukon (RMH BC), we envision a province where families stay close to their sick children.

Today, 2 out of 3 Canadians live in a city or town without a children's hospital. Our Mission is to give sick children the healing power of being together with family.

As a champion of family-centered care, we enable access to children's hospitals by providing families with sick children accommodation, meals, and wellness programs that support their emotional and physical well-being.

In 1983, the first RMH BC House opened its doors in Vancouver with a 13-Bedroom House, and over the years, with an increase in demand for this essential service, construction of a new building was underway.

In 2014, a 73-bedroom House was unveiled on the grounds of BC Children's Hospital along with a new 2,000 sq.

ft. RMH Family Room in Surrey Memorial Hospital.

As the second-largest House in Canada and one of the largest in the world, RMH BC will continue to grow and meet the needs of families across BC and Yukon.

Our team is the backbone of our organization—serving our families, supporting volunteers and donors, and spreading awareness every single day.

About the Position

Reporting to the VP, Finance, the Database Administrator will manage the Raiser's Edge fundraising solution, which supports the organization's present and future fundraising activities with accurate and timely information and data management.

The Database Administrator is responsible for all aspects of donor database management utilizing the Raiser's Edge (RE) Database View and RE NXT Web View, including prospect clearance, gift processing, acknowledgement, reporting and analysis, constituent data management, security and administration, family data management, and assisting with Annual Giving, Leadership Giving, Stewardship and Recognition, Event, and Volunteer Management.

This position will also act as a central point of information, collaboration and communication for donors and internal/external stakeholders.

Key areas of responsibility include:

Data and Information Management

Continue to enhance, maintain and optimize a comprehensive fundraising database solution: The Raiser's Edge Database View and RE NXT Web View, and to effectively support RMH BC's Development team and fundraising programs, including the gathering, assimilating and reporting of key information and data for financial reporting, donor data management, and donor analytics and metrics.
In conjunction with the Development team and VP, Finance, develop and maintain a Policy and Procedure Manual including standards and procedures for data entry and gift processing, to ensure consistency and the highest levels of data integrity, accuracy, and standardization.
Adhere to the standards of ethical fundraising (AFP, Imagine Canada, CRA), industry best practice, and all RMH BC policies, as relating to the collection and analysis of donor data.
Provide oversight to the Database & Finance Coordinator to ensure accurate and efficient gift processing, tax receipting, and tracking of all donor information.
Oversees the donor acknowledgement process to meet the turnaround target of 48 hours.
Responsible for the management of prospect/donor information including accurate coding of data and information, compiling analytics, assisting entering actions, and creating prospect lists and related queries and reports.
Responsible for accurate tracking of campaigns, funds, and appeals, and routine reporting of fundraising activities and metrics.
Coordinate and oversee preevent and dayof event activities relating to receiving and processing donations for fundraising events.
Design and generate reports for financial updates, prospect management, stewardship activities, and ad hoc reports as needed by Finance and Development teams.
Assist the Development team in their distribution of communication and marketing materials.
Provide continuous analysis of data and software functionality to increase efficiency an effectiveness of workflow.
Provide technical training and guidance for Raiser's Edge as needed.
Support the execution of a comprehensive stewardship and recognition strategy for donors and partners.
Perform other related duties as required or assigned to support the mission and goals of the organization.

Reporting

Provide detailed RE Database view and RE NXT web view reports, exports, lists, dashboards and report builder support to Development and Finance teams.
Support the preparation of the annual audit and CRA T3010 filing.
Validate and commit all gift entry records and prepare applicable reports to complete a monthly scheduled reconciliation with Finance.
Generate, review and send pledge reminders, including statements, monthly.
Prepare queries and reports as requested by the Development team including segmented direct mail lists, donor recognition and invitat