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

Manages the information in MCM Applications for the Coordinated Investigative team.

Provides information management services including the business analysis and planning, to facilitate the collection, retrieval, sharing and analysis of investigative material obtained and generated during investigations.

Supervises one to three people, including training, mentoring, and managing performance.

Work environment

Major Case Management Operation Service Centre (MCMOSC) provides client, technical and compliance services for the electronic management of information and infrastructure for major cases. MCMOSC staff provide essential support to operational units with the creation, organization, auditing and general management of major case files, as well as providing significant assistance to investigators in the compilation of disclosure packages. MCMOSC also delivers training in electronic file management systems as well as the continuing development of policies and business rules for the implementation of these systems in consultation with the Criminal Justice Branch, Public Prosecution Service Canada, various investigative bodies and working groups.

This position is located in a law enforcement environment which includes regular contact with uniformed and armed police officers.

It is important to note that the work involves dealing with information that may be emotionally disturbing. Psychological and emotional effort is required to maintain composure when exposed to graphic and specific descriptions of violent crimes.

Intent of the process

The intent of this process is to establish 5 pools of qualified candidates in each of the stated geographic locations: Surrey, Kelowna, Victoria, Nanaimo 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.

Should a CM be found qualified and selected for appointment, the appointment will not result in a change of status to another category for the member.

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)

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)

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

Degree equivalency

(AE1) Recent experience using Major Case Management software
applications, for example Evidence & Reports, SUPERText, and Powercase.
(AE2) Experience working with digital multimedia (video, photo, audio) and related software.
(AE3) Experience working in a police environment.
(AE4) Successful completion of two or more relevant courses in database design, database administration, and/or business intelligence at the post- secondary level.

*“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

Reliability Status security clearance - 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

The successful applicant will have to obtain, as a minimum, an RCMP Reliability Status. In some cases/positions, a RCMP Top Secret Security Clearance may also be required. The process also requires a Security/Reliability Interview, a field investigation in matters of Criminal Activities, credit/finances, education, employment, references, etc.

An assignment/secondment or an acting appointment is a temporary resourcing option. The approval of your substantive supervisor may/will be required before an offer can be made.

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.

Your resume will be used as a secondary source of information and must accurately reflect your employment history and support your qualifications.

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.

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.