John Abbott College

Administration Technician - College Development Office


IMPORTANT: Effective immediately

JOB SUMMARY: Under the general authority of the College Development Office Manager and direct supervision of the pedagogical counsellor, the administration technician performs a variety of statistical tasks for the systematic collection, compilation, analysis and interpretation of data. The technician also performs various administrative and technical tasks pertinent to the operation of the service.


Extract information from the main databases such as Clara, PSEP, DEFI and CHESCO, as well as all other external databases Create Clara reports in the Structured Query Language (SQL) server environment using Visual Studio software Perform statistical analysis from data collected; include means, medians, modes and standard deviations from data collected; execute tests of significance, analysis of variance, correlation, and regression analysis Design, administer, monitor, maintain and analyze surveys, including surveys of students and alumni to better evaluate student success (i.e. Omnivox, Survey Monkey, LimeSurvey) Design formats for data presentation and display which are user friendly, i.e. tables, graphs, charts, dashboards Prepare data-related materials for various reports such as the annual report, dashboards, course calendar and program assessments Prepare reports at the request of departments, program committees, the College and others using the data collected from various databases Provide the necessary data to support college quality assurance initiatives Provide data and support for Strategic Plan analysis and development Create and maintain filing system Comply with applicable policies, guidelines and procedures in the sharing and distribution of data and results Contribute to the work of departments, program committees and Academic Council or its committees dealing with student success and other data, including attending meetings and liaising with other departments, as and when requested Perform any other related tasks as may be assigned



College diploma (DEC) in science (sciences de la nature), techniques de recherche et de gestion de données, or an appropriate specialty or an attestation of studies recognized as equivalent by the competent authority

Specific Requirements

Knowledge of databases such as SQL, PSEP, DEFI, CHESCO, CLARA and others; an asset Knowledge and usage of statistics and databases, with an understanding of database environments Ability to use office systems technology Ability to think critically and problem-solve Ability to produce effectively under pressure, providing accurate data Ability to work with a production schedule and deadlines Autonomous- able to work with minimal supervision Ability to maintain confidentiality Ability to organize work efficiently and accurately Strong communication skills Good interpersonal skills Works well within a team setting Excellent computer skills (Excel, Word and PowerPoint) English advanced- oral and written French intermediate- oral, written and written comprehension Related experience would be an asset

Testing may be required to demonstrate knowledge of or to evaluate technical skills in the following areas:

Word (intermediate) Excel (intermediate) English advanced – oral and written French intermediate – oral, written and written comprehension Knowledge and usage of databases and statistics and data presentation


Situated on the most western tip of the island of Montreal, in Sainte-Anne-de-Bellevue, John Abbott enjoys a rural setting just a half hour drive from downtown Montreal. As one of 48 CEGEPs (collège d’enseignement général et professionnel) in Québec, John Abbott offers two types of programs: two-year pre-university programs that lead to university, and three-year career or professional programs designed to lead directly to the labour market.

Primary Address

21 275 chemin Lakeshore
Ste-Anne-de-Bellevue, Quebec, H9X 3L9