Coordinator, Business Intelligence

St. Paul's Foundation; Vancouver; Hybrid; CAD 57,000 - 70,000; Full time

Benefits offered by this job

Extended Health Benefits

BC Municipal Pension Plan eligibility

Job summary

St. Paul’s Foundation is seeking a Coordinator, Business Intelligence to support fundraising operations through accurate donor processing, data integrity, and BI reporting.

You will ensure timely administration of donor information, prepare reports, and collaborate across departments to bolster data quality and operational efficiency. You will coordinate gift processing, data updates, and routine BI outputs while participating in process improvements and maintaining internal controls.

Qualifications

• Post-secondary program in business administration, information systems, data analytics, accounting, finance, computer science, or related discipline.
• 2–4 years of progressive experience in data administration, business operations, donor services, finance, reporting, or business intelligence.
• Experience maintaining databases and ensuring data accuracy, integrity and quality in a complex environment.
• Familiarity with donor management or CRM systems, Raiser's Edge is a plus.
• Experience preparing reports, reconciling data, and supporting operational or financial processes.
• Proficiency with Microsoft Office, especially Excel; Outlook, Word, PowerPoint.

Responsibilities

• Process charitable donations across payment types within Raiser's Edge.
• Balance and reconcile gift batches to support financial reporting.
• Maintain donor data accuracy and up-to-date records.
• Prepare donations for deposit and support internal controls.
• Generate and distribute tax receipts in compliance with requirements.
• Support donor data administration and system maintenance.
• Prepare routine reports and data extracts for fundraising, finance, and operations.
• Contribute to process documentation and improvement initiatives.
• Provide general administrative support to the BI team.

Skills

Donor data management

Data analysis

Reporting

Power BI

Raiser’s Edge

Excel

CRM systems

Education

Post-secondary program in business/IS/data analytics

Tools

Raiser’s Edge

Power BI

Job description

Annual Salary Range: Range $57,000 to $70,000. Typical hiring range $60,000 to $67,000

Employment Type: Permanent, Full-Time

Location: Hybrid (3 days in office per week)

Benefits: Extended Health Benefits and eligibility to participate in the BC Municipal Pension Plan

Role Overview

The Coordinator, Business Intelligence plays a key role in supporting the Foundation's fundraising operations through the accurate processing of donations, maintenance of donor data, and coordination of business intelligence and reporting activities. This position contributes to data integrity, operational efficiency, and informed decision-making by ensuring the timely administration of donor information, preparing reports, supporting continuous process improvements, and providing administrative support to the Business Intelligence team. Working collaboratively across departments, the Coordinator helps ensure the Foundation's systems, data, and processes effectively support fundraising and organizational priorities.

Key Responsibilities

• Coordinate the timely and accurate processing of charitable donations, including cash, cheques, credit cards, and other gift types within Raiser's Edge.
• Prepare, balance, and reconcile gift batches to support accurate financial processing and reporting.
• Maintain the integrity of donor information by ensuring records are accurate, complete, and up to date in the donor database.
• Prepare donations for deposit and support reconciliation activities in accordance with established internal controls and procedures.
• Generate and distribute charitable tax receipts in compliance with applicable regulatory requirements and organizational standards.
• Support the processing of digital transactions and related data administration activities.
• Assist with donor database administration, including routine maintenance, data updates, and system support.
• Coordinate the preparation of routine reports and data extracts to support fundraising, finance, and operational decision-making.
• Contribute to process documentation and participate in continuous improvement initiatives to enhance operational efficiency and data quality.
• Provide administrative support, including managing incoming mail, preparing meeting materials, recording meeting minutes, processing expense reports, filing, scanning, and responding to general inquiries.
• Collaborate with colleagues across the Foundation to support business intelligence, donor services, and operational priorities.
• Participate in process improvement initiatives and perform additional related duties as required.

Qualifications & Experience

• Successful completion of a post-secondary program in business administration, information systems, data analytics, accounting, finance, computer science, or a related discipline is required.
• A minimum of 2–4 years of progressive experience in data administration, business operations, donor services, finance, reporting, business intelligence, or a related role.
• Experience maintaining databases and ensuring data accuracy, integrity, and quality in a complex business environment is required.
• Working knowledge of donor management or customer relationship management (CRM) systems, preferably Raiser's Edge, is considered an asset.
• Experience preparing reports, reconciling data, and supporting operational or financial processes is considered an asset.
• Intermediate proficiency with Microsoft Office applications, particularly Excel, as well as Outlook, Word, and PowerPoint, is required.
• Experience with reporting and data visualization tools, such as Power BI or Raiser's Edge NXT reporting, is considered an asset.

As a not-for-profit foundation entrusted with donor funds and community partnerships, the successful candidate must complete and pass a criminal background check prior to commencing employment.

About St. Paul’s Foundation

St. Paul’s Foundation raises funds to support patients, residents, caregivers, and families at St. Paul’s Hospital and at Providence Health Care and Providence Living sites across BC. Our generous donors are an essential part of Providence’s mission to deliver compassionate care, innovative research, and world-class medical training and education.

As we look back on our 130-year history – and forward to our future in the new St. Paul’s Hospital at the Jim Pattison Medical Campus – we are ready to further push the boundaries of innovation, research, and patient-centred care for the people of British Columbia and beyond. Truly, our mission and the support of our community have never been more important. www.helpstpauls.com

All Candidates Are Welcome

Diversity, equity, and inclusion are essential to creating a great workplace. At St. Paul’s Foundation, we are fully committed to building a strong and representative team. To that end, we especially encourage applications from members of all communities who are disadvantaged on any grounds under the BC Human Rights Code, including people of colour, people of all genders and sexualities, people with disabilities, and Indigenous Peoples, who, as a result of colonization, are under‑represented in positions of economic, social, and political influence and leadership.

Thank you for your interest in working with St. Paul’s Foundation. Only candidates short‑listed for interviews will be contacted.