Technical Advisor, Application Development / Database and Data Administration (Data Warehouse)

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

When submitting your application, you MUST ANSWER questions regarding the education and experience requirements (both essential and asset qualifications). You must CLEARLY DEMONSTRATE how you meet each of these requirements by answering the online questions. It is not sufficient to only state that the qualifications are met or to only provide a listing of current or past responsibilities. Rather you must clearly demonstrate WHEN (month-year to month-year), WHERE and HOW you acquired each qualification by giving CONCRETE EXAMPLES. Information provided in your answers related to your education and experience must be supported in your resume. Failure to provide the above information in the format required WILL result in your application being rejected from the process. The information you provide in the questionnaire must be true.

Applicants meeting the initial screening requirements will be contacted for further assessment.

The screening criteria are those related to *Education and *Experience listed under the *Essential Qualifications.

The other Essential Qualifications will be assessed through Second Language Evaluation (SLE) tests, written exams, interviews and reference checks. If you are unsuccessful at any stage, you may not be evaluated again in this selection process.

Depending on the requirements of the positions being filled, any or all of the asset qualifications and organizational needs may be considered at any time during this process. These criteria may be a deciding factor in choosing the persons to be appointed. Therefore, it is IMPORTANT that you answer each of the questions related to these requirements.

TRAVEL AND RELOCATION: CANDIDATES WILL BE REQUIRED TO PAY FOR THEIR OWN TRAVEL, INCLUDING TRAVEL FOR ASSESSMENT PURPOSES, AND MAY BE REQUIRED TO PAY FOR THEIR OWN RELOCATION EXPENSES.

It is your responsibility to keep your personal data in your PSRS Applicant Account up-to-date and to check your e-mail account regularly to ensure that you do not miss out on any opportunities. If you fail to respond in the appropriate timeframe, your candidacy WILL NOT BE REFERRED to the hiring manager.

All job applications must be submitted through the Public Service Resourcing System.

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

Intent of the process

A pool of fully qualified candidates may be established to staff similar or identical positions within Elections Canada with various tenures (indeterminate, specified periods) and with various linguistic profiles.

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:

Successful completion of two years of an acceptable post-secondary educational program in computer science, information technology, information management or another specialty relevant to the position to be staffed.

NOTA: Indeterminate period incumbents of positions in the CS group on May 10, 1999, who do not possess the education prescribed above, are deemed to meet the minimum education standards based on their education, training and/or experience. They must be accepted as having met the minimum education standard whenever this standard is called for when staffing positions in the CS group.

or

At the manager's discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum post-secondary education stated above. Whenever the minimum education is met via this alternative, it is met for the specific position only and must be re-assessed for other positions for which this alternative has been specified by the manager.

Degree equivalency

EXPERIENCES :

Recent* experience in providing technical advice and guidance to management or colleagues or clients as a subject matter expert.

Recent* and significant** experience in providing technical leadership in the support of Business Intelligence technology.

Recent* and significant** experience in working on complex IT issues, making recommendations, and implementing IT related solutions.

*Recent is defined as an experience having been acquired within the last five (5) years

**Significant is defined as the depth and breadth of experience normally associated with full-time performance of duties for a period of approximately two (2) years

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

English or French

Information on language requirements

Knowledge:

Knowledge of techniques and/or practices related to the gathering and analyzing client or stakeholder business requirements.

Knowledge of Systems Development Life Cycle (SDLC) techniques and/or practices.

Knowledge of Business Intelligence Life Cycle.

Key Competencies:

Thinking things through;
Client Focus;
Creative Thinking;
Teamwork.

Abilities:

Ability to analyze complex issues, formulate options and make recommendations.

Ability to communicate effectively orally.

Ability to communicate effectively in writing.

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

Asset/Education:

College Diploma of 3 years or more in an IM/IT discipline.

University Degree in an IM/IT discipline.

Degree equivalency

Asset/Professional Certification:

Possession of one or more relevant professional certification that applies to an IM/IT position.

Asset/Experiences:

Experience in developing and executing test plans, test scripts, test cases or use cases.

Experience designing and building Extract, Transform and Load (ETL) processes.

Experience in maintaining or enhancing Data Warehouse and/or Data Marts.

Asset/Knowledge:

Knowledge of Business Intelligence components:
- Data warehouse concepts
- Extract, Transform and Load (ETL) concepts
- Analytical and reporting tools.

Selection may be limited to members of the following Employment Equity groups: Aboriginal persons, persons with disabilities, visible minorities, women

Information on employment equity

Operational requirements:

Willingness and ability to work overtime on as when needed and on short notice.

Willingness and ability to work according to a variable schedule.

Conditions of employment

Other Conditions of Employment :

Consent to observe strict political impartiality and neutrality for the duration of employment.

Willingness and ability to work overtime on as when needed and on short notice.

Willingness and ability to work according to a variable schedule.

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

A written examination may be administered.

An interview may be administered.

Reference checks may be sought.

ACKNOWLEDGMENT OF RECEIPT OF APPLICATIONS:
Acknowledgment of receipt of applications will not be sent. We will contact candidates when the screening process is completed.

COMMUNICATIONS WITH CANDIDATES:
YOUR EMAIL ADDRESS AND CONTACT INFORMATION FOR COMMUNICATION PURPOSES :
Given that communication will take place by email, candidates who apply to this selection process must include in their application a valid email address and make sure that this address is functional at all times and accepts messages from unknown users (some email systems block these types of email).

Candidates are responsible to inform us at all times of any changes regarding their contact information or candidate profile.

PERSONAL RECORD IDENTIFIER (PRI)
If you are currently an employee or a former employee of the Federal Public Service, please specify your Personal Record Identifier (PRI) in your application.

SECOND LANGUAGE EVALUATION (SLE) RESULTS
If you already have valid SECOND LANGUAGE EVALUATION (SLE) RESULTS, please ensure that you have a copy of your results and be prepared to send them shortly.

YOUR RESUME
Your resume must clearly demonstrate that you meet the education and experience requirements listed under the essential and asset qualifications. Failure to provide sufficient information about these requirements, your candidacy may be screened out.

OFFICIAL LANGUAGE OF YOUR CHOICE:
Each candidate is entitled to participate in the appointment process in the official language of her/his choice. Applicants are asked to indicate their preferred official language in their application.

ACCOMMODATION ARRANGEMENTS:
Should you have any physical restrictions or other limitations that may necessitate accommodation measures in order for you to take future assessments, you must inform the contact person mentioned below of your accommodation needs (e.g. an alternative method of assessment, a technical aid, accessibility requirements, etc.), as quickly as possible. Please also indicate your needs in your application.

For testing purposes, "accommodations" refer to alternate formats or modifications to testing procedures that are designed to accommodate the needs of a candidate with a disability in order to eliminate or minimize the impact of any disabling condition and permit a fair and equitable assessment of the candidate's skills. Information received relating to accommodation measures will be handled confidentially.

PROOF OF CANADIAN EDUCATION OR CANADIAN EQUIVALENCY:
Candidates are responsible to provide the appropriate documentation to show that they possess the education credentials from an educational institution.

PROOF OF CITIZENSHIP
Candidates will be required to provide proof of citizenship (original document only) when invited to the written exam.

CANDIDATES INVITED TO AN INTERVIEW will be required to bring proof of their education credentials, in the form of a diploma(s) and /or official transcript(s )(original documents will be required if offered a position - a copy will be accepted in the meantime). We therefore encourage candidates to retrieve their original proof of education or to request this documentation from their educational institution(s) should they do not have them on hand. Candidates with foreign educational credentials are required to provide proof of Canadian equivalency. You may consult the Canadian Information Centre for International Credentials at http://www.cicic.ca for further information. Candidates who are unable to provide proof that they meet this essential qualification as requested will be eliminated from the current selection process.

ESSENTIAL QUALIFICATIONS :
Candidates must meet ALL of the essential qualifications in order to be appointed to a position.

ASSET QUALIFICATIONS, ORGANIZATIONNAL NEEDS AND OPERATIONAL REQUIREMENTS
Depending on the requirements of the position or positions being filled (currently and in the future), any or all of the asset qualifications, operational requirements, and organizational needs may be considered and assessed at any time during this process. This is why meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed.

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.