Major Case Management Information Systems Applications Specialist - Inventory

Major Case Management Information Systems Applications Specialist - Inventory

Reference number : RCM24J-106296-000072

Selection process number : 24-RCM-EA-P-E-VAR-INV-MCMOSC-127580 Royal Canadian Mounted Police - ISOC Major Case Management Operational Service Centre (MCMOSC)

Kelowna (British Columbia), Nanaimo (British Columbia), Prince George (British Columbia), Surrey (British Columbia), Victoria (British Columbia)

AS-03 - CM equivalent - SPS-ADM-03 (RCMP Civilian Member)

$72,171 to $77,758

For further information on the organization, please visit

Closing date : 31 March 2025 - 23 : 59, Pacific Time

Who can apply : Persons residing in Canada, and Canadian citizens and Permanent residents abroad.

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.

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.

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.

Please do not email the Contact asking for an update. You will be contacted if your resume will be considered further.

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.

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.

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

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. Should you require accommodation at any point during the evaluation process, please don’t hesitate to reach out to the Contact information provided below to request specialized accommodation.

All information received in relation to accommodation will be kept confidential.

Please be patient with us. We will be periodically reviewing batches of resumes, so it might take some time before you receive a response from us.

Additionally, please be aware that our positions require an RCMP specific clearance, which is processed once the candidate pool is established.

We genuinely want you to join our team, but these steps are essential and may require a bit of time.

Duties

The Information Systems Application Specialist (ISAS) plays a key role in coordinating and creating electronic Disclosure packages.

The information Management team, which you supervise, works closely with police investigators on multiple simultaneous files.

You may travel with the investigative team to local detachments to keep up with the urgent demands of an investigation. Using tools such as SQL and Crystal Reports, you will be designing database audits to identify inconsistencies and Disclosure risks, as well as prioritizing work for the teams and inputting large volumes of information through scripting.

You will need to be familiar with all roles of Information Management (Data Entry and Vetting) to step in when necessary to meet deadlines.

You will be responsible for training new Information management team members and Police officers, in using the Investigational database.

Work environment

Who is Major Case Management? We are the group that specializes in Information Management of serious, large and complex investigations the RCMP undertakes across the Province.

We have offices in all the major cities in BC. You will be working directly with police officers, as a team, in support of the investigations.

You will work directly embedded in an Investigative unit providing support, training and expertise for the management of information for major cases such as drug trafficking, homicides, financial fraud and organized crime across the Province.

You will be instrumental in the creation of electronic Disclosure packages presented to the Courts for criminal prosecutions.

Attention to detail, task orientation, and effective multitasking are essential skills, as you’ll regularly re-evaluate priorities amidst ongoing investigations.

In the course of your work, you may be exposed to materials from Crime scenes, autopsies and / or other graphic materials.

These positions will expose you to all aspects of investigations and what goes on behind the scenes in major investigations.

What do we offer?

At Major Case Management, we foster a work environment where employees have opportunities to grow, learn, progress in their careers and long-term job satisfaction.

Our team enjoys the challenges of this important work and benefits from :

Opportunities for advancement within our program but also exposure the many non-police opportunities within the RCMP as well as the wide array of roles in the Federal Government

A total benefits package including a competitive salary, health and dental insurance plans, pension plan and a variety of leave entitlements

Following the TBS common hybrid work model for the Federal Public Service, full-time employees are required to be in the office for at least 3 days a week, with exceptions for roles with sensitive work that don’t allow for remote work.

However, many of our positions offer 1 or 2 days of telework per week, with expectations varying based on the position.

Intent of the process

Anticipatory.

A qualified group of candidates may be identified and may be used to staff future permanent or temporary vacancies in similar -level positions.

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

It may also be used to staff future vacancies throughout RCMP E Division in British Columbia.

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

A response to a text question addressing the following :

According to the Treasury Board Standard on Security Screening, 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.

and may require certain residency requirements.

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.

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

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)

EDUCATION :

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

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.

Receipt of applications will not be sent. Candidates will be considered for positions as they become available, and will be advised of any further evaluation.

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.

and may require certain residency requirements. As such, the process may take several weeks or months to complete.

Please refer to Appendix B and D (4) of the Treasury Board Standard on Security Screening for more information - .

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, operational requirements, and organizational needs may be applied at the time of staffing.

Candidates may be contacted and assessed against these criteria at any time during this process.

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

A person may be appointed to the position even though he / she does not meet any or all of the asset qualifications, operational requirements or organizational needs.

However, meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed.

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.

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.

This process and the resulting pool will only be used to staff positions in the RCMP.

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.

Those selected for assessment should be prepared to provide the names and contact information of recent references (recent is defined as within the last 2 years) :

References must be available, have an in-depth knowledge of your work / projects, and must be able to answer specific questions pertaining to your experience, achievements and strengths.

References that are not reachable and / or not available are lowering the candidates’ chances to be found fully qualified and be considered for appointment.

When providing names of references, it is the candidate’s responsibility to ensure they are available to respond in a timely manner.

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

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.

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