Humber River Hospital Foundation

 

Job Description:  Officer, Database Reporting & Analytics

 

Lighting New Ways in Healthcare – Humber River Hospital stands apart. As North America’s most digital hospital, our state-of-the-art facility is enabling our physicians and staff to deliver healthcare in new and innovative ways, and is a model of efficiency for hospitals around the world. Everything we do is designed to enhance not only outcomes but also the experiences of our patients and their families.

Humber River Hospital Foundation raises funds to invest in the programs, technologies and equipment that make our Hospital’s superior patient care a reality. Since the day we opened our new facility we’ve proudly stayed ahead of a changing world, always innovating to continue lighting new ways in healthcare now and into the future. This spirit of innovation is powered by the Foundation’s donors and volunteers, who share our vision for a brighter future.

Please refer to the Foundation www.hrhfoundation.ca and the Humber River Hospital website www.hrh.ca for additional information.

Position Summary

As a key member of the Finance and Administration team, Database Reporting & Analytics Officer is responsible and accountable for managing the system data relating to Raiser’s Edge and to ensure the accuracy and integrity of the database, overseeing data input and output, and end-user training and support. The Officer will also support the Gift Processing & Finance Officer including the processing of all donations received and applicable receipts.  Responsibilities include importing and exporting of data, extracting and analyzing data in Excel, report writing, data mapping, developing and implementing policies to guide data entry, documenting database changes, and ensuring donor information that is captured generates accurate financial and analytical reports for all staff of the Foundation.

Reporting to the Vice President Finance and Administration, the Officer is responsible for providing leadership for the Foundation’s data management systems and to assist all Foundation staff to extract data and utilize Raiser’s Edge in support of their goals and functions.

Reports To:

• VP, Finance & Administration

Direct Reports:

• N/A
  

Key Responsibilities:

• Maintain, update and create as needed, the coding and field structure in Raiser’s Edge for all fields and edit fields as appropriate.
• Provide guidance and assistance to the gift entry and acknowledgement process.
• Extract data for finance, direct response mailings, donor recognition, stewardship and other reporting purposes as required.
• Import online donations from AKA Raisin into Raiser’s Edge using Import-O-Matic and merge duplicate records as needed.
• Import data files, from all sources, and generate required reports to review accuracy and completeness of imports.
• Produce queries and reports as requested including donor giving, prospect management and other campaign reports as required.
• Maintain, update and create Donor Reports for the Development Team, Special Events, Donor Relations groups, etc. as needed.
• Upload back-feed file from mailing house and append appropriate codes to donor records.
• Recommend changes, use of technology and other improvements to enhance database and database performance.
• Partner with Blackbaud staff and Humber River Hospital IT staff as required.
• Routinely examine and cleanse donor records to ensure data accuracy, eliminate duplicate records and inconsistent data, to maintain overall database integrity.
• Develop MS Excel reports to manipulate data where Raiser’s Edge tools are insufficient and write customized reports and forms as required.
• Perform additions, upgrades and conversions to Raiser’s Edge and other relevant programs as required.
• Analyze and report trends and other information from within the donor database as required.
• Train new staff and develop ongoing training for staff in the use of Raiser’s Edge and queries, exports, customized reports, etc.
• Oversee user accounts/groups, recommend and manage security permissions and develop and implement related security policies.
• Other duties as required.

Skills/Knowledge:

• Bachelor’s Degree or equivalent.
• Highly developed understanding of database systems.
• Technical knowledge and experience with Raiser’s Edge, Excel including the extensive use of Macros and Pivot Tables, and Crystal Reports.
• Excellent interpersonal and communication skills, verbal and written.

• Strong customer service oriented approach complemented by excellent organizational and time management abilities.
• Ability to manage multiple priorities from different sources enhanced by problem solving capabilities.

• Excellent analytical and project management skills.

• Ability to think strategically in how to improve and streamline processes.
• A valid driver’s license and access to a vehicle preferred.

 

Related Experience:

• 3-4years progressive experience in database management, in a fundraising environment preferable.
• Demonstrated success in developing custom reports, queries and exports in MS Excel
• Demonstrated strategic thinking and initiative

Note: Flexibility is required as this position may be required to work some weekends and evenings.

Job Posting Closes: February 17, 2023

Interested applicants are required to apply online at www.hrh.ca/careers before the closing date. We thank all candidates that apply but only qualified candidates will be contacted for an interview.

Humber River Hospital Foundation is an equal opportunity employer and we will accommodate your needs under the Ontario Human Rights Code. Upon individual request, hiring processes will be modified to remove barriers to accommodate those with disabilities. Should any applicant require accommodation through the application, interview or selection processes, please contact the Human Resources Department for assistance.

Please be advised that in order to be eligible for employment at Humber River Hospital Foundation, all new hires must have received the full series of a COVID-19 vaccine or combination of COVID-19 vaccines approved by Health Canada (e.g., two doses of a two-dose vaccine series, or one dose of a single-dose vaccine series); AND have received the final dose of the COVID-19 vaccine at least 14 days prior to the hired employee’s first date of employment  Medical exemptions or any other kind of requested exemption based upon the Foundation’s obligations pursuant to the Ontario Human Rights Code will be considered on a case-by-case basis