Reporting to the Director, Advancement Services, the incumbent is responsible for managing the Banner Advancement database, reporting solutions to further the donor and alumni objectives of Carleton University. S/he will be responsible for the management, evaluation, planning, testing, documentation and implementation/coordination of Advancement database projects, training users and liaising with ITS on technology matters, as required. On medium to large projects, the Database Specialist will act as project leader and have staff assigned to report to the incumbent to assist in the projects.
PART B Primary Duties Performed
Data Generation – 50%
Develop new database reporting applications using Access and other database tools based on consultation with users.
Craft processes and procedures for generating lists, reminders, acknowledgements, letters and charitable tax receipts.
Respond to time-sensitive ad-hoc data requests from Senior Management, Directors, Deans and other staff.
Translate requests into accurate reflections of requirements, provide recommendations and plans for handing data, document processes, anticipate needs, write accurate and detailed reports, and develop and deliver training materials for using self-serve system functions.
2. Records Management – 30%
Represent Advancement on committees and steering groups for database and records issues. · Design, monitor and update Banner Advancement database information, in conjunction with ITS, for various SQL server, Web and Banner applications.
Generate, review, and follow up on routine integrity check programs associated with Banner Advancement to maintain consistency and accuracy across University systems.
Ensure the design and implementation of systems adhere to industry and university policies, standards, codes, procedures and guidelines.
Implement quality control measures and identify problems with data.
Define and specify appropriate technical solutions through the coordination of efforts with other system specialists to ensure that systems meet user needs.
Develop, organize and facilitate on-going training programs to educate Advancement staff in the use of the various donor and alumni applications.
3. Upgrades and Improvements – 20%
Identify, evaluate and advise, through consultation with users, on the database and microcomputing needs of Advancement.
Manage projects in terms of the design, improvement and implementation of Banner Advancement modules, the CRM, reporting solutions and other systems and processes.
Implement system upgrades, in collaboration with vendors and ITS.
Facilitates the testing of modified systems and implementation of new systems.
PART C Specifications (to be completed by Supervisors, in conjunction with employee)
a) Minimum amount of formal education: Bachelor’s Degree in Information Technology.
b) Minimum amount of relevant work experience required:
c) Minimum amount and type of continuing study required: The duties of this position require the incumbent to keep abreast of software and hardware developments in the rapidly changing environment of database management, technology and computing through review and study of computer journals, manuals, or literature; by attending conferences, seminars, technical meetings and courses; and conversing and collaborating with other information technology professionals. The work requires knowledge of the trends and developments in database management and of technology theories and principles to organize and direct the design, development and modification of various systems, applications and programs; to develop technical and programming documents; to establish standards and to resolve complex and unprecedented problems. The incumbent must maintain knowledge of current and past University rules, regulations and policies. In addition, the incumbent must have a proven understanding of CRM systems and their use within a university environment.
Internal Number: J0419-0183
About Carleton University
Carleton University was established in 1942, growing dramatically over the years to where we now accommodate some 24,000 full and part-time students, with some 800 Faculty members and 1,000 staff. The Development Office was established in 1963 to mount Carleton’s first fundraising campaign; and the Alumni Relations Office was established as an independent office in 1984 to support the Alumni Association’s activities. One year later the two offices were amalgamated. As a result of decreased funding from government and the University’s aggressive growth plan, Department of University Advancement is required to meet a growing number of requests for funding from external sources. The Department ofUniversity Advancement raises funds from community individuals, alumni, Carleton’s internal community, corporations and foundations, and also organizes tri-partite partnership funding for special projects and responds to special provincial or federal government opportunities for one-time funding or matching programs. The Department’s ability to meet the challenge of finding external support will have a direct and permanent impact on the future of Carleton University.