This job has expired and you can't apply for it anymore.
Company Name:
The Calgary Foundation
Approximate Salary:
Not Specified
Location:
CALGARY, Alberta
Country:
Canada
Industry:
Other
Position type:
Full Time
Experience level:
5 - 10 years
Education level:
Associate Degree

DATABASE ADMINISTRATOR

The Calgary Foundation (“Foundation”) has been nurturing a healthy, vibrant, giving and caring community since 1955. The Foundation facilitates collaborative philanthropy by making powerful connections between donors and community organizations for the long-term benefit of Calgary and area.  In 2016-17, the Calgary Foundation saw $26 million in new contributions, had an asset base of $925.6 million and granted $40.2 million to 896 charitable organizations.

THE OPPORTUNITY:

To advance the vision and mission of the Calgary Foundation through ensuring the effective and efficient collection, retention and use of critical information related to donors, charitable organizations, volunteers, allied professionals, community leaders and other stakeholders. This is a one year term position to cover a maternity leave.

SCOPE OF RESPONSIBILITIES:

  • CRM Data Entry and Maintenance (25%)
  • Email and Mailing Lists, Database Analysis and Data Extraction (40%)
  • Reporting and Presentation (30%)
  • Staff Training and User Support (5%)

DESIRED OUTCOMES:

Reporting to the Vice President, Finance, the Database Administrator makes a significant contribution to the following overall organizational outcomes.

The Calgary Foundation:

  • Knows the community and its needs and opportunities
  • Engages citizens in community building
  • Inspires philanthropy and matches donors with the needs for which they care deeply
  • Builds a permanent endowment to address the needs of today and the needs of tomorrow that we cannot yet see
  • Strengthens charities in all parts of the sector (360 degrees)

SPECIFIC RESPONSIBILITIES:

The principal responsibilities are two-pronged and include:

 Data Administration

  • Overall responsibility for improving the efficiency and efficacy of the organization’s translation of multiple types, sources and sets of data into information
  • Responsibility for the proper recording of Constituent Relationship Management (“CRM”) information in the Management Information System (“MIS”) including, but not limited to, data entry, assisting with the setting up of organizational business rules and implementing procedures

  • Database clean up and maintenance (i.e. merging duplicate constituents, importing new constituents, ensuring data conforms to organizational standards –  e.g. Canada Post addressing standards – and updating addresses)
  • Development of queries and exports to extract data from MIS and related business intelligence tools
  • Responsibility for maintaining accurate and consistent CRM information within the MIS
  • Responsibility for introductory MIS training for new hires and ongoing basic support to other staff (includes creating and maintaining customized MIS training manuals)
  • Responsibility for aligning on-line data sets with MIS where applicable
  • Providing support, including research, for various organizational initiatives

Reporting

  • Creating internal dashboard reporting and presenting data analytics for a wide variety of organization-wide activities (e.g. CRM, financial reporting, website activity, etc.)
  • Presenting external summary reporting of data for hard- and soft-copy publications and various websites (e.g. annual report, management discussion and analysis, community initiatives, etc.)

 MEASURES OF PERFORMANCE SUCCESS:         

  • Accuracy, timeliness and completeness of CRM data
  • Prompt production of precise and easily understandable reports
  • Quality of feedback from staff and other stakeholders

SKILLS AND COMPETENCIES REQUIRED:

Post-secondary college or university degree with minimum 5 – 7 years related working experience.

  • Proficiency in MIS, relational databases, and business intelligence tools such as Foundation Information Management System (“FIMS”), Raiser’s Edge, Access or equivalent and Rocket’s CorVu Compass or similar.
  • Advanced skills in Microsoft Office productivity tools (Word, Excel, Outlook).
  • Awareness of the impact of Canadian Anti-Spam Legislation (CASL), Personal Information Protection Act (PIPA) and Personal Information Protection and Electronic Documents Act (PIPEDA) on the work.

HOW TO APPLY:

The salary for one year term position is competitive with industry standards.  In addition to salary, a comprehensive benefits package is offered.

Interested candidates are invited to submit, via email, a resume in PDF file format together with their salary expectations and cover letter, no later than Tuesday, October 24, 2017 to:

Tracy Maracle

Director – Governance, Human Resources & Administration

Email:  [email protected]

For information regarding the Calgary Foundation please visit www.calgaryfoundation.org.