Research and Business Intelligence Officer

The Royal Ottawa Mental Health Centre

Position Information

Posting Number: ROM22-250E

Title: Research and Business Intelligence Officer

Position Status: Regular Full-time

FTE: 1.0

Job Schedule: Days

Department: Foundation

Union: Non-union

Site: Royal Ottawa Mental Health Centre

Number of Vacancies: 1

About The Royal


Are you inspired to work for an organization that is leading the charge in breaking down the stigma and discovering the causes and cures for mental illness? Join Us! The Royal Ottawa Foundation for Mental Health raises funds to support the best possible patient care and leading-edge research provided by the Royal Ottawa Mental Health Centre, the Brockville Mental Health Centre and the University of Ottawa Institute of Mental Health Research at The Royal.

The Research and Business Intelligence Officer is a member of the Royal Ottawa Foundation for Mental Health’s (the “Foundation”) Campaign Operations and Business Intelligence Team who will support the development and maintain a new business intelligence system, support the development of management information strategy and strengthen and streamline prospect research and prospect management processes.

Reporting to the Director, Campaign Operations & Business Intelligence, the Research and Business Intelligence Officer is an important contributor to the Royal Ottawa Foundation’s culture, driven by inclusivity, collaboration, and our strategic framework. A curious, analytical and proactive thinker with a commitment to agile principles, you work well independently and collaboratively with related key internal and external partners.

Key Areas of Responsibility:
Prospect Research & Prospect Management

Carry out strategic, accurate and timely prospect research which may include prospect profiles, prospect identification, review & qualification, targeted screening, etc.

Investigate and analyze complex forms of information for the development of comprehensive and strategic briefings to support development activities.

Align prospective donors’ interests with The Royal’s organizational and strategic priorities.

Conduct and support research and analytics projects, which may involve trend analysis, environmental scans, economic trends, competitive analysis, and pipeline and financial analysis.

Maintaining a strong commitment to ethical prospect research practices and producing accurate, insightful research and data-driven work.

Establish a strong prospect pipeline that leads to relationships with diverse stakeholders.

Support a ‘moves management’ tracking system to support fundraisers.

Data Analytics & Management

Support an information driven culture by deriving conclusions and identifying trends through analysis of internal and external data.

Implement ongoing prospect development strategy and data integrity initiatives.

Design and produce regular and ad-hoc auditing reports to ensure data integrity of key prospect data, including ratings, assignments, cultivation approaches, proposals, and prospect groups.

Manage the collection, storage, maintenance and retrieval of donor and stakeholder insights.

Ensure a high level of data quality and integrity in Raiser’s Edge through timely and accurate data entry, record maintenance and prospect tracking.

Provide recommendations on the development of standard operating procedures related to management of prospect data and data to support tracking fundraising activities.

Business Intelligence

Support the development of customised, usable dashboards and reports in QlikSense.

Learn and fully understand the data landscape of the Foundation’s business systems.

Understand the end-to-end life cycle of our data to effectively review and validate the data within it relevant to business intelligence reporting.

Actively participate in and contribute to architecture/design discussions and decisions.

Gather end user reporting and dashboard requirements.

Support users with the navigation and interpretation of dashboards.

Communicate insights from data across the organization to influence improvements to standard operating procedures.

Support the creation of the management information strategy and create standard operating procedures relevant for business intelligence.

Proactively identify opportunities for system improvement and business intelligence enhancements.


Participate in fundraising initiatives for special events and projects required from time-to-time.

Participate and support Foundation, Royal Ottawa Health Care Group (ROHCG), and Institute of Mental Health Research (IMHR) committees as required.

Work in manner that is in compliance with staff and patient/client safety practices, policies and procedures of the Royal.

Ensure a work environment that is conducive to The Royal’s Respectful Workplace policy.

Operate within the culture and core values of the Foundation.

Other responsibilities and duties as required.

Qualifications & Key Competencies

A university degree combined with a minimum of three years of experience in a non-for-profit with a focus on prospect research.

Knowledge and practical experience of complex information systems, data analytics, business intelligence tools (Qlik Sense an asset), prospect tracking, fundraising, research and prospect management.

Comprehensive understanding of and experience in prospect research using a variety of online information sources such as SEDAR, SEDI, iWave, Grant Connect, CharityCAN and Directory of Directors.

Understanding of Canadian business landscape, financials and corporate annual reports.

Understanding and practical experience of effectively reviewing data for reporting needs.

Superior computer and data analysis skills within a complex CRM database (Raiser’s Edge preferred).

Strong working knowledge of the Microsoft Office suite including advanced fluency in spreadsheet manipulation.

Exceptional analytical and problem-solving skills, with an attention to detail and accuracy.

Ability to evaluate, interpret, and present complex information effectively in professionally prepared documents or presentations.

Ability to communicate clearly, concisely and professionally both orally and in writing. Strong interpersonal skills are a must.

Ability to manage several projects simultaneously, prioritize and plan work activities while meeting respective deadlines. Strong organizational and time-management skills.

Independent and innovative self-starter who displays an ability to learn quickly and easily adapts to changing situations. Experience researching topics to gain knowledge and understanding when information gaps exist.

Proven training and coaching skills and the ability to collaborate effectively within a team and with colleagues to achieve specific goals.

Tact in handling sensitive and confidential information appropriately and with discretion; follow and promote APRA’s ethical guidelines for the collection and use of information.

Fluency in French is an asset.

Starting Salary Range: $60,000 – $67,500 – commensurate with experience, along with a competitive benefits package and a defined benefit pension.

Date Required: ASAP

All applicants must provide a recent resume that clearly indicate that they meet the required qualifications.

Please apply directly to this internal posting at: on or before May 16th, 2022.

Why with us?

Working at the Royal Ottawa Foundation puts you at the forefront of delivering mental health supports for people living in eastern Ontario, including research that has a national and international impact.

The Royal Ottawa Foundation is a team of passionate and talented people helping transform the mental health landscape. Our culture is built on respectful collaboration with the common goal of paving a path for the continued advancement of mental health care and research.

The Royal Foundation thanks all applicants. Only those selected for an interview will be contacted. The Royal Ottawa Foundation is a respectful, caring and inclusive workplace. We champion accessibility, diversity and equal opportunity. We welcome all applicants, including but not limited to all religions, ethnicities, LGBTQ2s+, BIPOC, persons with disabilities and all others who contribute to the diversification of ideas.

Salary Range: $30.77 to $34.62 per hour

Additional Information

All applicants must provide a recent resume that clearly indicate that they meet the required qualifications.

Please apply by clicking on the Apply button below.

The Royal sincerely thanks all applicants for their interest in a career with us; however, only those applicants selected for an interview will be contacted.

All new hires will be required to obtain a clear and valid Criminal Record or Vulnerable Sector Records Check as a pre-condition of employment.

The Royal is an equal opportunity employer. Upon request, accommodations due to a disability are available throughout the recruitment process.

Apply Now
To help us track our recruitment effort, please indicate in your cover/motivation letter where ( you saw this job posting.