Data 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 special accommodation. All information received in relation to accommodation will be kept confidential.

Information on accommodation for persons with disabilities

Depending on the number of applicants, AAFC's needs and/or AAFC Human Resources plans, volume management strategies such as random selection, top-down approach and/or establishing cut-off scores to determine who will continue in the staffing process, MAY BE USED for the purpose of managing applications. Please note that although you may attain the established pass mark on any of the assessments used in this staffing process, management may decide to use a higher cut off score.

For this selection process, our intention is to communicate with applicants by e-mail. This includes: information requests, invitations, provision of assessment results, etc. Applicants must include in their application a valid e-mail address that is functional at all times and accepts messages from unknown users. Some e-mail systems block these types of e-mails. Ensure to check/view your spam folder regularly. Applicants MUST check their e-mail accounts frequently as there may be a deadline for responses. Responses provided after the indicated deadline WILL NOT be accepted.

Work environment

As one of Canada’s Best Diversity Employers, AAFC is proud to celebrate our achievement in creating a diverse, respectful, and positive workplace where all employees are valued and recognized for their unique qualities, ideas, voices and perspectives.

Intent of the process

Immediate need: To staff a position on an indeterminate basis for the location indicated for this process.

In the event that an employee of the public service is qualified through this process, and there is a temporary need, he/she may be considered for acting or assignment/secondment opportunities.

A pool of partially partially qualified candidates may be established and may be used for similar positions with various tenures, various linguistic profiles and various security requirements, for the location indicated for this process.

Positions to be filled: 1

Information you must provide

Your résumé.

A covering letter in 3,000 words (maximum) "Candidates must clearly demonstrate IN THEIR COVER LETTER how they meet the education and experience factors listed in the essential and asset qualifications. CANDIDATES MUST USE THE EXPERIENCE FACTORS AS A HEADER AND THEN WRITE NO MORE THAN TWO PARAGRAPHS DEMONSTRATING HOW THEY MEET THE EXPERIENCE REQUIRED. Resumes may be used as a secondary source to validate the experience described in the cover letter. FAILURE TO PROVIDE THIS INFORMATION IN THE REQUESTED FORMAT MAY RESULT IN YOUR APPLICATION BEING REJECTED."

Contact information for 2 references.

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

EDUCATION
Successful completion of two years of a post-secondary program with acceptable specialization in social science, statistics, library/archival work, Computer Science, Engineering, Database Management, Accounting, and Business Administration or a law-related field OR an acceptable combination of education, training and/or experience.

Notes:
1. An indeterminate incumbent of a former SI position who became an EC on June 22, 2009, who does not possess the above stated minimum level of is deemed to meet this minimum educational standard based on his/her education, training and/or experience. He/she must be accepted as having met the minimum educational standard for appointment or deployment to Part B EC positions. This note also applies to a person appointed or deployed for an indeterminate period to an EC position with the above education criteria, after that date as the result of a staffing transaction started before June 22, 2009.

2. At the manager's discretion, an acceptable combination of education, training and/or experience that is comparable to the minimum education stated above, may serve as an alternative. Whenever the minimum educational standard is met through an alternative, it is met only for the position being staffed, and a candidate must be re-assessed for future appointments and deployments if the manager has asked for this alternative.

3. "Social science" includes economics, political science, sociology, anthropology, history, psychology, geography, criminology, and other disciplines associated with social science. "Library/archival work" includes gallery and museum functions.

4. It is the recognized educational institution (e.g. community college, CÉGEP or university) that determines whether the courses taken by a candidate correspond to two years of a post-secondary program at that institution.

IF YOU HAVE FOREIGN CREDENTIALS, please follow the link below for information on how to obtain a degree equivalency. You must obtain an equivalency, at your own expense, in order to be considered for appointment into the public service.

Degree equivalency

EXPERIENCE
Recent* and significant** experience in the data entry, updating and maintenance of an established database or data systems.

Recent* and significant** experience searching for and extracting information from established database or data systems to develop and prepare analysis

Recent* and significant** experience in organizing, analyzing and preparing statistical or financial information for reports.

*Recent is defined by having been acquired within the last twelve (12) months;

**Significant is defined as breadth and richness of experience that would normally be associated to the performance of duties over a period of at least six (6) months.

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

EDUCATION
Graduation with a degree* from a recognized university with acceptable specialization in statistics, computer science, economics or some other specialization relevant to the position.

*Unless it is otherwise specified (e.g., Master’s degree), the term “degree” refers to a baccalaureate as established by educational authorities.

Degree equivalency

EXPERIENCE
Experience with MS Access and MS Excel regarding creation/modification of pivot tables and or queries
Experience in using SQL Developer and Oracle,.
Experience in using Excel, Tableau and/or Power BI for Data visualization.

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

English essential

Information on language requirements

KNOWLEDGE
Knowledge of MS Access and Excel

COMPETENCIES
Adaptability
Initiative
Project management
Team work

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

In support of achieving a diversified workforce, consideration may be given to candidates self-identifying as belonging to one of the following employment equity groups: aboriginal peoples, persons with a disability, visible minorities and women.

OPERATIONAL REQUIREMENT
Ability and willingness to work overtime including evenings and weekends, at times on short notice.

Conditions of employment

Reliability Status 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 targeted groups when you apply.

Information on employment equity

Applications submitted by email will not be accepted. You must apply on-line through www.jobs.gc.ca.

Persons with disabilities preventing them from applying on-line are asked to contact 1-800-645-5605.

Persons are entitled to participate in the appointment process in the official language(s) of their choice. Applicants are asked to indicate their preferred official language(s) in their application.

Communication for this process will be sent via email. It is the responsibility of the candidate to ensure accurate contact information is provided and updated as required. Candidates who apply to this selection process should include an email address that accepts email from unknown users (some email systems block these types of email).

All communication relating to this process, including email correspondence, may be used in the assessment of qualifications.

Appointment decisions may be based on one or more of the following criteria:
- Matching of the individual's experience or qualifications to the strengths and weaknesses of the work team.
- Matching of the individual's experience or qualifications to the specific duties of the position being staffed.
- Depth, breadth, type of work-specific experience.
- Level/degree of one or more competencies/qualifications.
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.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.