Information Systems Application 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

*** ONLY ONLINE APPLICATIONS WILL BE ACCEPTED ***

All job applications must be submitted through the Canada.ca/jobs site. To submit an application online, please select the button "Apply Online" below.

Persons who cannot apply online or persons with disabilities preventing them from applying online are asked to inform the contact persons responsible for this process prior to the closing date.

**IMPORTANT INSTRUCTIONS TO FOLLOW**

You are required to complete screening questions that clearly demonstrate how you meet the essential criteria of education and experience and any asset if applicable. Your response must include HOW (concrete examples), WHEN (dates) and WHERE (location of work) you meet the essential criteria required.

Your resume will not be used as second source to validate the experience listed in the answers. Comments such as "refer to my attached résumé" will not be accepted and may result in your application being rejected.

On October 6, 2021, the Government of Canada announced details of its plans to require vaccination across the federal public service.

As per the new Policy on COVID-19 Vaccination for the Core Public Administration Including the Royal Canadian Mounted Police, federal public servants in the Core Public Administration and members of the RCMP must attest to their vaccination status. The requirement for employees to be fully vaccinated applies whether they are teleworking, working remotely or working on-site. This is a condition of employment and it applies to indeterminate (permanent), determinate (term), casual, and student hiring. Should you reach the point in the selection process where it is necessary to verify terms and conditions of employment then the hiring manager or a human resources representative will contact you in order to complete an attestation.

Duties

Who are we and what we do?

Major Case Management Unit (MCMU) provides support to the Federal Policing (FP) mandate to investigate matters relating to serious and organized crime, financial crime and cybercrime. MCMU is responsible for collecting and cataloging investigational data and information using applicable software to prepare court evidence (electronic disclosure).

What will you be doing?
An Information Systems Application Specialist (ISAS) provides database management services to facilitate the collection, retrieval, sharing and analysis of investigative data obtained and generated during an investigation. An ISAS also develops and maintains data reports using Crystal Reports and other tools. Additionally, an ISAS will also provide client support on the troubleshooting of the database applications. An ISAS will manage, prepare and oversee the organization of investigative electronic data for court purposes. An ISAS is responsible to conduct data audit to ensure compliance with the unit standard operation procedures (SOP’s). Also, to assist investigational units with file management and relationship management with the investigation teams. An ISAS will manage the workflow, priorities and workload within the unit. Other responsibilities of an ISAS is to participate in elaboration of new SOP’s, to have problem solving skills and a resolution approach. An ISAS plays a centric role in investigation data management while using technology to manage such data.

Why you will love working with us:

MCMU is a great positive and respectful workplace. The well-being of employees is important and taken into consideration. MCMU is an operational support unit that provides learning and growth opportunities. MCMU employees have a work life balance as we are flexible with the schedule working hours. Also, with MCMU you have the opportunity to meet colleagues and to be part of an amazing team.

Work environment

National Division Vision: To be a world-class leader in high-priority sensitive investigations and protective operations

As the RCMP’s newest Division established in April 2013, National Division (ND) continues to contribute to the protection of Canada’s national interests through its dual mandates: Sensitive and International Investigation (SII) and Protective Operations. National Division is the most unique Division endeavoring to excel in delivering on its distinct and high profile dual mandates within a borderless and continuously evolving operating environment.

As National Division is a smaller division, you will grasp the strong sense of camaraderie within every unit, which is one of National Division’s most distinctive qualities. By joining National Division, you will have an opportunity to contribute to service excellence and have a direct impact on daily operations.

What are you waiting for? Join our National Division Family!

Intent of the process

The intent of the selection process is to staff one (1) indeterminate AS-03 positions with an Enhanced Reliability Status with Top Secret security clearance. The position has a Bilingual Imperative BBB/BBB language profile. The position is located at 155 McArthur Avenue, Ottawa, ON.

A pool of qualified candidates could be established and could also be used to staff similar positions within RCMP National Division.

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. Information regarding the CM appointment will be sent to all applicable candidates who are within the area of selection and participated in the advertised process.

Should a Public Servant employee be found qualified and selected for appointment, notification regarding the PS appointment will be posted accordingly on https://www.canada.ca/en/public-service commission/jobs/services/gc-jobs.htmI.

Positions to be filled: 1

Information you must provide

Your résumé.

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

A secondary school diploma or employer-approved alternatives Degree equivalency

Degree equivalency

Recent* and significant** experience in working with Adobe products

Experience in data administration (Data administration involves the logical management of data in which the flow of data is analyzed, data models are created and the relationships among them are defined. Data administration also defines the security and access control elements of data where data might be limited to some people and processes)

Experience working with advanced features of Adobe Acrobat Professional, including merging of documents, creating bookmarks, creating hyperlinks and using electronic vetting tools

Experience identifying relevant information from operational investigative file(s) to create links within a relational database to assist in the preparation of electronic disclosures which are organized, indexed and searchable

*Recent = within the last three years

**Significant = experience will be evaluated with regard to complexity and diversity of work handled, level of autonomy demonstrated and impact of the decisions

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

Bilingual - Imperative (BBB/BBB)

Information on language requirements

Knowledge of relational database concepts

Knowledge of computer concepts

Knowledge of principles, practices, policy and legislation associated to the vetting of operational information in relation to disclosure and non- disclosure of evidence.

Ability to solve problems

Ability to establish priorities to meet deadlines

Ability to develop and deliver training materials and/or mentor Ability to supervise

Ability to communicate effectively orally Ability to communicate effectively in writing

Leadership and Effective Interpersonal Skills
Attention to Detail
Dependability
Initiative Client Service

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

Experience in working with reporting tools such as ‘Crystal Reports’

Experience in working with ‘Visual Cut’ applications

Experience troubleshooting computer problems

Experience building and/or reviewing disclosure for Court Knowledge and use of Evidence and Reports (E&R)

Conditions of employment

Must be willing and able to travel for work-related matters

Must be willing to work overtime on short notice to meet operational need

Enhanced Reliability Status with RCMP Top Secret security clearance

All employees of the core public administration are required to be fully vaccinated against COVID-19 and attest to their vaccination status unless accommodated based on a medical contraindication, religion, or another prohibited ground for discrimination as defined under the Canadian Human Rights Act

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

A written examination, an interview and/or reference checks may be administered.

Deployment may be considered.

Candidates must meet all the essential qualifications to be appointed to a position and may be required to meet the asset qualifications depending on the requirements of the specific position being staffed.

You must provide proof of education credentials. If you obtained your education outside Canada, it is your responsibility to demonstrate its equivalence, please take a look at the following link for more information : http://www.cicic.ca/383/foreign-credential-recognition.canada.

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 identify clearly your substantive group and level and your employment status on your resume and/or application form.

Our means of communication with applicants are via e-mail. Please ensure to include a functional e-mail address, which will accept messages from unknown users (some e-mail systems block these types of e-mails). It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required. Acknowledgement of receipt of applications will not be sent.

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.