IT Technical Advisor / IT Team Leader

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

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

STREAM 1:
CSC is looking for an IT technical advisor – Oracle E-Business developer with strong experience in Oracle development tools in order to design, develop, document, and test all required customizations, interfaces, conversions, and reports related to E-Business suite application. Asset qualifications include foundation in Oracle EBS technology, which may include Oracle Reports, Oracle Forms, PL/SQL, BI Publisher, Unix and OA Framework. Strong aptitude in Structured Query Language (SQL) and understanding the data structure of various EBS modules (i.e. AP, AOL, PO) are essential.

STREAM 2:
CSC is looking for an IT Technical Advisor – Data Modeler and an IT Team Leader with strong SQL, PL/SQL or T-SQL experience in order to design develop, document and test Extract Transform and Load (ETL) scripts, as well as data models in a data warehouse environment. This job also involves interacting with clients, working closely with team members with diverse expertise, reporting to the Manager. The IT Team Leader role would also involve leading team members.

Intent of the process

Although the immediate intent of this Job Opportunity Advertisement is to staff indeterminately, applicants should be aware that a pool of qualified candidates (fully assessed or partially assessed) may be established and may be used to staff similar positions at this group and level with various language requirements listed in the Language Requirements section. In addition, this process may be used for various tenures (indeterminate, specified period), security requirements and conditions of employment within the Correctional Service of Canada. As a result of the potential and possible use of the selection process and subsequent pool by hiring managers, we encourage all employees seeking this type of opportunity to apply.

Positions to be filled: 3

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:

Graduation from a two-year program of study from a recognized post-secondary institution with acceptable specialization in computer science, information technology, information management or another specialty relevant to the position to be staffed; or an acceptable combination of education, training, and/or experience relevant to the position.

Note:

1. Indeterminate incumbents in the IT group on December 9, 2021 who do not possess the education prescribed above, are deemed to meet the minimum education standard 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 IT group.

2. Indeterminate 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 standard 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 IT group.

Degree equivalency

EXPERIENCE:

COMMON EXPERIENCE FOR BOTH STREAMS:

Experience in developing IM/IT solutions to meet business needs.

Experience in the Design, development, and tests solutions, including data design to meet partner expectations.

Experience in the development of technical documents.

EXPERIENCE FOR STREAM 1:

Significant** experience in the design, development, maintenance and support of EBS applications.

Significant** experience with production support of Oracle E-Business suite

EXPERIENCE FOR STREAM 2:

Recent* and significant** experience with advanced SQL

Recent* and significant** experience with advanced Microsoft T-SQL and/or Oracle PL/SQL

Recent* and significant** experience as a data modeler

Significant** experience developing and maintaining data warehouses and data marts

Recent* and significant** of Extract Transform Load (ETL) experience


* Recent is defined as performing the duties within the last five years.

** Significant is defined as performing for the duties for a minimum of three years.

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

Various language requirements
Stream 1:
English essential

Stream 2 :
English essential
Bilingual imperative CBC/CBC - for the IT Team Leader position

Information on language requirements

COMPETENCIES:

Working well with others
Demonstrating Integrity and Respect
Thinking things through
Showing initiative and Being Action Oriented

ABILITIES:

Ability to prioritize, plan, and organize
Ability to work with minimal supervision
Ability to provide recommendations on complex IT issues
Ability to communicate effectively in writing
Ability to communicate effectively orally

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

EXPERIENCE:

Stream 2

Experience with DevOPS methodology.

Experience configuring Microsoft Azure data pipelines.

Experience migrating ETL Scripts (T-SQL and SQL) from Microsoft SQL Server “on premises” environment to Microsoft Azure environment.

Experience supervising an IT Team.

OPERATIONAL REQUIREMENTS:

Work overtime when needed.

Conditions of employment

Reliability Status 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

A written examination may be administered.

An interview may be administered.

Reference checks may be sought.

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.

For this selection process, we may find that email is the most efficient way to communicate with you. Candidates who apply to selection processes should include an email address that accepts email from unknown users (some email systems block these types of email). It is the candidates' responsibility to inform us of a change of contact information during the course of this selection process and to regularly verify your incoming e-mails.

An assignment, secondment, or acting appointment requires approval of your supervisor.

Please identify clearly for which position(s) you are submitting an application.

You must provide proof of your education credentials.

Candidates with foreign credentials must provide proof of Canadian equivalency. Consult the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca.

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.