Database Reporting Officer

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

Please note when submitting an application to this selection process, you will be prompted to answer screening questions concerning the essential education and experience qualifications and, if applicable, other (nonessential) qualifications.

It is NOT sufficient to only state that the qualifications are met or to provide a listing of current or past responsibilities. Rather you must clearly demonstrate HOW, WHEN, and WHERE the qualification was met through substantiation by examples. Information on your described skills, experience, etc. provided in the screening questions should be supported by your resume. Failure to provide the above information in the format required may result in your application being rejected from the process.

Candidates may not be solicited for incomplete or possible missing information.

Resumes will be used as a secondary source to validate the experience and education described in the screening questions.

INSTRUCTIONS

When recording your examples, be sure you:

• Provide concrete, specific examples of actions that speak directly to the experience sought.
• Choose examples with sufficient complexity, impact and degree of difficulty that will allow you to illustrate to what extent and depth you have shown the behaviours expected for each qualification.
• Focus on what you did. In referring to an experience achieved in the context of a team, set your role apart from the role(s) of others.
• Please describe the achievements in the past tense. This will help to ensure that you are providing concrete examples, rather than making general statements (e.g. instead of saying “I work well within a team….” you can say “I worked well with a team when….”).
• Use action verbs when describing your experience i.e. lead, managed, organized, planned, prepared, informed, determined, etc.
• Provide all examples in sentence format.
• Each example must include when the example took place, background of each situation, what you did, how you did it, what your role was in the situation, and what was the outcome.

Duties

Participates on multi-disciplinary teams and provides input and data to support departmental initiatives.

Interacts extensively with clients to discuss their information requirements and specifics relating to desired output as well as providing advice pertaining to business solutions.

The work requires knowledge of business intelligence tools and data warehouse to access and manipulate data.

Interprets user requests to determine the nature, feasibility and options for providing the information required.

Intent of the process

The intent of this process is to establish a pool of qualified candidates which could be used to staff similar or identical positions with various tenures, various language requirements, and/or various security clearance levels.

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)

Education:
ED1 - Graduation with a degree from a recognized post-secondary institution with acceptable* specialization in economics, sociology or statistics.

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.

An indeterminate incumbent of a former ES position on June 30, 1967 who became an EC on June 22, 2009, who does not possess the minimum level of education as indicated for Part A above is deemed to meet this minimum educational standard based on his/her education, training and/or experience.

* An acceptable specialization means a total of six courses from economics, sociology or statistics.

** An acceptable combination of education, training and/or experience is defined as: University degree and minimum one year work experience within last two years preparing, creating or managing statistical reports or creating reports from primary data using data query and retrieval tools.

Degree equivalency

Experience:
EX1 - Experience extracting data from databases using SQL tools (such as IBM Cognos, Information Management System (IMS+), MS Access).
EX2 - Experience organizing data into informational summaries.

Abilities:
AB1 - Ability to communicate orally.
AB2 - Ability to communicate in writing.
AB3 - Ability to review data and identify anomalies or errors.
AB4 - Ability to deal with conflicting deadlines.

Personal Suitability:
PS1 - Effective Interpersonal Relationships
PS2 - Judgement
PS3 - Initiative
PS4 - Reliability

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

English essential

Information on language requirements

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

Education:
AED1 - Degree or diploma in Computer Science.

Degree equivalency

Experience:
AEX1 - Experience in the use of Business Intelligence (BI) Tools (e.g. SAS, PowerBI, Tableau).
AEX2 - Experience working in and creating reports in data bases used by VAC and/or VAC service providers; such as CSDN, CRM, SAP, or FreeBalance.
AEX3 - Experience in preparing formal response to ad hoc requests, such as; Parliamentary Written Questions, Access to Information and Privacy (ATIP) and Media requests.
AEX4 - Experience in writing SQL queries.
AEX5 - Experience serving as a member of the Canadian Armed Forces.
AEX6 - Experience reporting on VAC program delivery or performance.

Organizational Needs:
Preference may be given to Veterans Affairs employees affected by workforce adjustment.

Conditions of employment

Reliability and Security: Reliability Status, Secret security clearance.

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

It is your responsibility to ensure that your email and contact information are maintained with the hiring board. All communication for this process will be sent by email and it is your responsibility to verify your messages regularly.

Education and/or Experience factors in the asset qualifications may be used for screening. Applicants should clearly demonstrate on their application if they meet any of the education and/or experience asset qualifications. Failure to do so may result in the rejection of your application.

One or more asset qualifications may be used during the screening to manage the volume of applications.

Candidates will be asked to provide proof of their education credentials, and proof of citizenship at a later date.

An interview and/or written exam may be administered.

Reference checks will be sought. The Assessment Committee reserves the right to contact references other than those provided by the candidates (within the Public Service only) in order to adequately assess the candidates.

Indeterminate employees at the same group and level or equivalent may be considered for assignment, deployment or secondment opportunities before other candidates.

The Public Service of Canada is committed to building a skilled, diverse workforce reflective of Canadian society. As a result, it promotes employment equity and encourages candidates to indicate voluntarily on their application if they are a woman, an Aboriginal person, a person with a disability or a member of a visible minority group.

The Public Service of Canada is also committed to developing inclusive, barrier-free selection processes and work environments. If contacted in relation to a job opportunity or testing, you should advise the Public Service Commission or the departmental official in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner. Information received relating to accommodation measures will be addressed confidentially.

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.