EC-03 - Statistical Officer / EC-04 - Analyst, HR Analytics and Reporting

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.

► The first extraction of applications is scheduled for April 1, 2019. The subsequent extractions will take place on an "as and when needed" basis.

*** INSTRUCTIONS TO FOLLOW ***

You must submit a complete application, consisting of screening questions which clearly demonstrate how you meet the screening criteria (education and experience) and a résumé. The screening questions will be used as the primary tool in the screening process and the résumé will only be used to substantiate the information provided.

Please note that the screening questions may also be used to assess written communication.

Please note that point form, “copy and paste" from your résumé and comments such “refer to my attached résumé” will NOT be accepted. Failure to provide this information in the requested format will result in your application being rejected.

FOR EACH EXPERIENCE CRITERION, please provide concrete examples including the following MANDATORY information:

1. Name of the department or organization where the experience was acquired;
2. Title of the position occupied and duration (including dates) for which you exercised the functions;
3. Specific details of tasks, projects, or accomplishments demonstrating how the experience was acquired.

Intent of the process

A pool of partially or fully qualified candidates may be established which may be used to staff similar positions within the Department of Justice Canada with various tenures, language requirements and/or conditions of employment, which may vary according to the position to be staffed.

The positions are currently located in Ottawa, Ontario, but consideration may be given to staffing positions in Montreal, Quebec.

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
ED1 - Graduation with a degree from a recognized post-secondary institution with acceptable specialization in economics, sociology or statistics.

Note: Candidates must always have a degree. The courses for the specialization must be acceptable and may have been taken at a recognized post-secondary institution, but not necessarily within a degree program in the required specialization. The specialization may also be obtained through an acceptable combination of education, training and/or experience.

Degree equivalency

EXPERIENCE
EX1 - Significant* experience in the production, analysis and interpretation of complex data sets and statistics from various data sources.
EX2 - Recent** and significant* experience using advanced Microsoft Excel functions, such as macros and pivot tables.
EX3 - Recent** experience using advanced Microsoft Access functions.
EX4 - Experience in researching and organizing data and information in response to a variety of data and information requests, and preparing written summaries and recommendations.

* “Significant” experience will be assessed in terms of the depth and breadth of activities, the complexity and diversity of the work handled, as well as the level of autonomy demonstrated.
** “Recent” experience refers to experience acquired during the normal performance of such duties for at least one year in the last two (2) years worked.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

ASSET QUALIFICATIONS

EXPERIENCE
AEX1 - Experience with Visual Basic.
AEX2 - Experience designing queries and writing SQL.
AEX3 - Experience with PeopleSoft, including extracting or manipulating data from various fields and modules.
AEX4 - Experience in using business intelligence software (e.g. SAS, PowerBI, Tableau).
AEX5 - Experience with the Phoenix Pay system, including extracting or manipulating data from various fields and modules.
AEX6 - Experience in analyzing and validating data sets and reporting on results in support of Human Resources Management.

OPERATIONAL REQUIREMENTS
OR1 - Ability and willingness to work overtime on short notice.

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

Various language requirements
Bilingual Imperative BBB/BBB / English Essential

Information on language requirements

KNOWLEDGE
K1 - Knowledge of qualitative and quantitative analysis, trend analysis and forecasting.
K2 - Knowledge of advanced Excel functions, such as Macros and pivot tables.
K3 - Knowledge of Human Resources management functions.

ABILITIES
A1 - Ability to analyze and summarize data sets and other information and prepare written summaries and/or recommendations.
A2 - Ability to prioritize workload and to meet deadlines
A3 - Ability to communicate effectively.

PERSONAL SUITABILITY
PS1 - Judgment
PS2 - Effective interpersonal relationships
PS3 - Initiative
PS4 - Thoroughness
PS5 - Dependability

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

All job applications must be submitted on-line. Persons with disabilities preventing them from applying on-line are asked to contact 1-800-645-5605.

Extractions from this selection process may occur throughout and after the advertisement period.

Results from previous extractions may be deemed valid for future extractions.

Candidates may be required to meet the organizational needs, depending on the requirements of the specific position being staffed.

Other qualifications may be taken into consideration in the selection decision.

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.

You must provide proof of your education credentials.

Our means of communication with applicants is 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. We encourage candidates to provide a second e-mail address in their application.

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.