Major Case Management Information Systems Applications Specialist

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

The client organization will accept applications on-line only. All job applications must therefore be submitted through the Public Service Resourcing System. Following are some of the benefits associated with applying on-line:
- Applicants can create a profile and a resume that can be used when applying for other processes without having to recreate a new application each time.
- Applicants can modify their application/resume at any time BEFORE the closing date indicated on the job advertisement.
- Applicants can verify the status of their applications, at any time.
- Applicants can be notified electronically of tests or interviews and results.
- For some jobs, applicants will find important information, namely the job questionnaire and a complete statement of merit criteria that are only available when applying on-line.

To submit an application on-line, please select the button "Apply Online" below. Persons with disabilities preventing them from applying on-line are asked to contact 1-800-645-5605.

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. Education obtained outside of Canada must be evaluated. Consult the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca/

Duties

Reporting through the Division Major Case Management Operational Support 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.

There are two units with vacancies at the RCMP “E” Division Headquarters, 14200 Green Timbers Way, in beautiful Surrey, BC. Headquarters is situated near the heart of downtown Surrey, near Skytrain, transit and the Guildford Mall. The facility hosts a cafeteria, Tim Hortons, and a gym. There are many free health and fitness classes as well as sports leagues to participate in, such as Yoga, Zumba, Meditation, Badminton, Soccer, and Tabata to name a few. There are also walking trails right at the entrance to the building.

One of the units with vacancies is the Integrated National Security & Enforcement Team (INSET), which investigates activities that may pose threat to national security. Candidates would have to undergo a top secret security clearance to work in this unit.

The other unit at Headquarters is the Provincial Major Crime Section. Investigations in the Major Crime Unit include homicides, suspicious deaths and missing persons where foul play is suspected, and investigations span across the entire province.

There is also a vacancy on the Vancouver Island region. The Vancouver Island Integrated Major Crime Unit (VIIMCU) is comprised of investigators and civilian employees from the RCMP, Victoria City Police and the Saanich Police Department. The unit investigates homicides, suspicious deaths and missing persons where foul play is suspected all over Vancouver Island and the Gulf Islands, as well as Powell River and surrounding area. Some areas are more remote and require the ISAS to travel with the team to these locations and work onsite with them. This position will appeal to someone with excellent communication skills as well as good technical troubleshooting abilities.

Intent of the process

The intent of this process is to establish 4 pools of qualified candidates in each of the stated geographic locations: Surrey, Victoria, Kelowna and Prince George BC. You must therefore clearly identify which location(s) you are applying to. Each pool is intended to be inclusive of Public Service (PS) employees and Civilian Members (CM); for various similar positions with various tenures and security profiles.

Once established, each pool will be valid for a period of 1 year, with the possibility of extension. The pool of candidates may be established and may be used to staff similar positions within the RCMP on an indeterminate or specified period (including term, acting, or assignment) basis, with various linguistic profiles and various RCMP security clearances.

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: 3

Information you must provide

Your résumé.

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

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

Degree equivalency

(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” means experience obtained within approximately the past 24 months.

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

English essential

Information on language requirements

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

(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.

(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)

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

Degree equivalency

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

*“Recent experience” means experience obtained within approximately the past 24 months.

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.

Conditions of employment

Obtain a valid reliability status/security clearance at a minimum of Enhanced Reliability Status. Some positions may also require Secret or Top Secret security clearance.

Some positions may require one or more of the following:
Possession of a valid Class 5 driver’s license.
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.

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

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.

Indeterminate employees at the same group and level or equivalent may be considered for deployment before applicants are considered in the advertised appointment process. Please identify clearly your substantive group and level and your employment status on your resume and/or application form.

Interested persons must meet the essential qualifications to be appointed to the position, in a manner determined by the Selection Board.

Depending on the requirements of the position(s) being staffed from this process, for current or future vacancies, any or all of the asset qualifications and operational requirements, may be applied at the time of staffing. Candidates may be contacted and assessed against these criteria at any time during this process.

When applying to this process, you will be required to answer screening questions with full details in the provided text box. Your details should clearly demonstrate HOW you meet the specified criteria, by including when, where and how you obtained the requirement (i.e. education or experience). Please include examples of the functions performed where relevant. Failure to answer the screening questions with sufficient detail may result in your application being rejected from the process. It is therefore inappropriate to only state “refer to resume” in the provided text box.

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 and/or a cut-off score may apply.

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.

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.

Acknowledgment of receipt of applications will not be sent; we will contact candidates when the screening process is completed.

All communication relating to this process, including email correspondence may be used in the assessment of qualifications.

The cost to attend the assessment will be the candidate’s responsibility. Candidates will be required to pay for their own travel (including travel for assessment purposes).

Preference

Preference will be given to veterans and to Canadian citizens, in that order, 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.