Major Case Management Information Systems Applications Specialist (Inventory)

Important messages

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

Assessment accommodation

When you apply to this selection process, you are not applying for a specific job, but to an inventory for future vacancies. As positions become available, applicants who meet the qualifications may be contacted for further assessment.

Your application in this inventory will be active for 180 days. A notice that your application is about to expire will be posted to the My Jobs menu of your account 30 days before the end of your active period. If you do not take action, your application will no longer be active and therefore no longer considered for this inventory. Should your application become inactive while the process is still open, a notice will be posted to your account indicating that your application has expired; you may select the link Update my Inventory Status to reaffirm your interest.

Required: PLEASE NOTE, WE WILL ONLY ACCEPT ON-LINE APPLICATIONS RECEIVED VIA THE Canada.ca SITE. Persons with disabilities preventing them from applying on-line are asked to contact the individual noted at the bottom of this advertisement.

NOTE: Applications are to be received online by clicking on the button below. Please do not send your resume or application to the Contact noted unless you are a person with a disability who is unable to apply online. The Contact can assist with general questions.

Original proof of your education will be requested and must be provided during the selection process, in order to verify that candidates meet the education requirement. Candidates who are unable to provide proof that they meet this essential qualification as requested may be eliminated from the process. Also note, if the name on your education credentials does not match the name on your current photo identification, you will need to provide proof of your name change.

Duties

Reporting through the Division Major Case Management Operational Service Centre, the Information Systems Applications Specialist (ISAS) provides information management services to facilitate the collection, organization, sharing and analysis of investigative material obtained and generated during major investigations.

Through the implementation of sound business processes, standards, and regular audits using SQL queries and Crystal Reports, the ISAS will ensure that the information stored in the major case database is complete, accurate and consistent.

The ISAS provides significant assistance to investigators first line troubleshooting of IM/IT issues, general and role specific training, and in the compilation of disclosure packages for Crown and Defense Counsel.

This position is also responsible for the direct supervision, training and performance management of subordinate Prosecutorial & Disclosure Coordinators and/or Information Processors.

Work environment

The Information Systems Application Specialist (ISAS) provides specialized support and training for major investigations as a member of the disclosure team. This position is located in a law enforcement environment which includes regular contact with uniformed and armed police officers. You may be exposed to highly sensitive and confidential information, which may be of a graphic nature that may have a strong emotional impact. Graphic material may include, but is not limited to, murder scenes and assault victim(s), autopsy photos, 911 audios and material relating to child exploitation investigations.

Intent of the process

This inventory will be used to staff positions at RCMP E Division Headquarters at 14200 Green Timbers Way, Surrey, BC, as well as Kelowna, Prince George, Nanaimo, and Victoria.

A qualified pool will be established and may be used for future permanent or temporary vacancies.

Should a Civilian Member (CM) be found qualified and selected for appointment, the appointment will not result in a change of status to the Public Service (PS) category for the CM.

Positions to be filled: Number to be determined

Information you must provide

Your résumé.

In order to be considered, your application must clearly explain how you meet the following (essential qualifications)

ESSENTIAL QUALIFICATIONS
EDUCATION:
A secondary school diploma OR an acceptable combination of education, training and/or experience.

Degree equivalency

EXPERIENCE:
(EX1) Recent experience* managing information in a relational database.
(EX2) Recent experience* working with advanced features in Microsoft Office and/or Adobe Acrobat such as inserting hyperlinks, bookmarking, and using formulae.
(EX3) Experience in creating reports using Business Intelligence (BI) applications such as Crystal Reports and SQL Server Reporting.
(EX4) Recent experience* in coaching, mentoring, or supervising one or more staff.

*“Recent experience” refers to experience obtained within approximately the past 2 years.

The following will be applied / assessed at a later date (essential for the job)

English essential

Information on language requirements

KNOWLEDGE:
(EK1) Knowledge of retrieving data from a relational database using SQL.

ABILITIES & SKILLS:
(EA1) Ability to communicate effectively orally.
(EA2) Ability to communicate effectively in writing.
(EA3) Ability to plan, organize, and effectively address multiple priorities.
(EA4) Ability to analyze problems and evaluate solutions.
(EA5) Ability to manage conflict.
(EA6) Ability to facilitate learning.
(EA7) Ability to perform quality assurance in the context of information management.

PERSONAL SUITABILITY:
(EPS1) Conscientiousness and Reliability
(EPS2) Flexibility
(EPS3) Client Service Orientation
(EPS4) Teamwork

The following may be applied / assessed at a later date (may be needed for the job)

ASSET QUALIFICATIONS
EDUCATION:
(AED1) Successful completion of two or more relevant courses in database design, database administration, and/or business intelligence at the post-secondary level.

Degree equivalency

EXPERIENCE:
(AE1) Recent experience* using Major Case Management software applications, for example Evidence & Reports, SUPERText, Powercase, PRIME Case Management..
(AE2) Experience working with digital multimedia (video, photo, audio) and related software.
(AE3) Experience working in a police environment.
(AE4) Experience creating macros in Microsoft Word or Excel.

*“Recent experience” refers to experience obtained within approximately the past 2 years.

OPERATIONAL REQUIREMENTS
Some positions may require one or more of the following:
• Willingness and ability to travel frequently for work-related matters.
• Willingness and ability to work overtime on short notice based on operational requirements.
• Willingness and ability to work flexible hours on short notice to meet operational needs.
• Possession of a valid BC Driver’s License or personal mobility to the degree normally associated with the possession of a Driver’s License.

Conditions of employment

Enhanced Reliability status security clearance.
Some positions may require Secret or Top Secret security clearance.

Some positions may require one or more of the following:
• Willingness and ability to travel frequently for work-related matters.
• Willingness and ability to work overtime on short notice based on operational requirements.
• Willingness and ability to work flexible hours on short notice to meet operational needs.
• Possession of a valid BC Driver’s License or personal mobility to the degree normally associated with the possession of a Driver’s License.
• Willingness and ability to view graphic material.

Other information

The Public Service of Canada is committed to building a skilled and diverse workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the designated groups when you apply.

Information on employment equity

Persons are entitled to participate in the appointment process in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

NOTE: Successful candidates will require a valid RCMP security clearance prior to appointment and throughout the tenure of their employment. The process to obtain RCMP security clearance involves a security/reliability interview and a field investigation regarding matters of criminal activity which includes reference checks, verification of credit/financial status, education, employment, etc. As such, the process may take several weeks or months to complete.

To be granted RCMP security clearance and to maintain the ethical standards of the RCMP, candidates must not be, or have been, involved in certain criminal activities, have been dishonourably discharged, have pending personal bankruptcies, etc. For additional information and a complete list of activities, please visit http://www.rcmp-grc.gc.ca/en/good-character . The security requirements are the same for all employees of the RCMP.

Once established, the qualified pool will be valid for a period of 12 months and may be extended.

Please note that candidates (including persons employed in the Public Service) will not be considered to be in travel status or on government business and travel costs will not be reimbursed. Consequently, candidates will be responsible for travel costs.

Your resume must accurately reflect your employment history and support your qualifications.

Practical and/or standardized tests may be administered for screening and/or assessment purposes.

Written test(s) may be administered.

Interviews may be conducted.

Reference checks may be conducted.

Random selection may be used to identify which applicants will be assessed or appointed in this appointment process.

Top-down selection may apply.

If a qualified candidate has been selected and appointed on an indeterminate basis from the established pool, they will be removed from the pool. If a candidate is selected for a specified period (including term, acting, or assignment/secondment) appointment, they will remain in the pool for future offers.

Incorrect or fraudulent information provided by a candidate during the application or assessment process will result in elimination from the process.

Experience qualifications will be assessed upon application. Further confirmation or assessment may be conducted through reference checks.

If you do not fully complete the screening questions as instructed, you may be screened out. It is not acceptable to put “see resume” in the space provided to answer the questions. You MUST clearly demonstrate in writing how you meet the Essential Education, and Experience requirements. Provide examples and describe the work/duties you have performed. Failure to do so may result in your application not being considered further during the screening process.

Any or all of the asset qualifications, operational requirements, and organizational needs may be used for the screening of applications. If you meet these criteria, please clearly demonstrate how you meet them in writing. Provide examples and describe the work/duties you have performed. Failure to do so may result in your application not being considered further during the screening process.

Education obtained outside of Canada must be evaluated. Please contact The Canadian Information Centre for International Credentials as soon as possible to initiate the evaluation process http://www.cicic.ca/

All communication relating to this process, including e-mail correspondence may be used in the assessment of qualifications

PLEASE NOTE: Where an e mail address is provided, the Selection Board may choose to communicate with candidates by e mail to provide/request information and to invite candidates to attend any portion of the assessment. It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required.

Candidates must meet the conditions of employment and continue to meet these same conditions during their employment.

Preference

Preference will be given to veterans first and then to Canadian citizens and permanent residents, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.

Apply online