Technical Advisor, Data Modeling / Architecture

Important messages

We strongly encourage applicants to submit their applications on-line.
Following are some of the benefits associated with applying on-line:
• Applicants can create and manage their accounts and apply to job opportunities as long as an internet connection is available.
• Applicants can create a profile and retrieve stored application(s) (personal information, covering letter and résumé) previously submitted and modify them, if necessary, before submitting the application.
• Applicants can modify their application/resume at anytime BEFORE the closing date indicated on the job advertisement.

Should you be unable to apply on-line on jobs.gc.ca, please submit your application, quoting the Selection Process Number, to the application contact listed on the poster on or before the closing date.

Candidates must clearly demonstrate IN THE PRE-SCREENING QUESTIONS, using CONCRETE AND DETAILED EXAMPLES, how they meet the education and experience factors listed in the essential and asset qualifications.

Your answers must include where and how you obtained the required education or experience, as well as the period(s) in which you performed the functions of the position(s). Your answer must include the date format of Month-Year to Month-Year.

Resumes may be used as a secondary source to validate the education and the experience described in their answers to the pre-screening question. Failure to provide this information in the requested format will result in your application being rejected.

The pre-screening questions may be used to evaluate the ability to communicate effectively in writing.

“The Government of Canada is committed to building a skilled workforce that is representative of Canada's diversity, which includes the recruitment of Canadian Veterans and releasing Canadian Armed Forces personnel.

We encourage applicants to identify any skills, competencies and/or experiences they acquired through a career with the Canadian Armed Forces.
https://www.canada.ca/en/public-service-commission/jobs/services/public-service-jobs/canadian-armedforces-members-veterans.html”

Work environment

Most positions will be located in Gatineau, QC. Virtual work reporting from another ESDC office in Canada may be possible upon management approval.

IITB's Hub locations outside of the NCR are located in: St-John's, Dartmouth, Charlottetown, Bathurst, Fredericton, Miramichi, Moncton, Boucherville, Jonquière, Laval, Montréal, Shawinigan, Belleville, Chatham, Cornwall, London, Toronto, Mississauga, Windsor, Vaughan, Winnipeg, Regina, Edmonton, Calgary and Vancouver.

Intent of the process

A pool of qualified candidates may be established and could also be used to staff similar positions, with various tenures, and/or various security requirements within the Information, Innovation and Technology Branch (IITB).

Positions to be filled: 3

Information you must provide

Your résumé.

You must meet all essential qualifications in order to be appointed to the position. Other qualifications may be a deciding factor in choosing the person to be appointed. Some essential and other qualifications will be assessed through your application. It is your responsibility to provide appropriate examples that illustrate how you meet each qualification. Failing to do so could result in your application being rejected.

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.

Notes:
1.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.
2.It is the recognized educational institution (e.g. community college, CÉGEP or university) that determines if the courses taken by a candidate correspond to two years of a post-secondary program at the institution.
3.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 using 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

EXPERIENCE
1. Experience in developing conceptual, logical and physical data models.
2. Experience establishing standards and best practices in at least one of the following areas: data modeling, data management, data architecture, data warehousing or data analytics.
3. Experience in providing recommendations to senior management (manager and above) in one or more of the following areas: data modelling, data management, data architecture, data warehousing, or data analytics.

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

Bilingual - Imperative (CBC/CBC)
English Essential
French Essential

Information on language requirements

KNOWLEDGE
1. Knowledge of current relational database management systems (Oracle and MS SQL Server).
2. Knowledge of data modeling techniques and practices.
3. Knowledge of data warehousing techniques and best practices.

ABILITIES
1. Ability to communicate effectively orally.
2. Ability to communicate effectively in writing.
3. Ability to analyse and work with large and complex data sets.
4. Ability to work collaboratively with multi-disciplinary teams, such as; application development teams, storage specialists, or system administrators on IT project or maintenance activities.

COMPETENCIES
1. Demonstrating integrity and respect;
2. Thinking things through
3. Working effectively with others
4. Showing initiative and being action-oriented

PERSONAL SUITABILITY
1. Leadership
2. Judgement
3. Client Service Orientation

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

ASSET QUALIFICATIONS

EXPERIENCE
1. Experience in developing and implementing complex data models in one or more of the following areas: operational applications (transactional processing); Data Warehouse and Data Mart applications (analytical processing).
2. Experience in conducting requirement gathering sessions, documenting data requirements and providing impact analyses for database solutions.
3. Experience in developing technical specifications for data extract, transformation and load (ETL) routines as required to support requirements.
4. Experience in the design, development, implementation and support of solutions using Oracle’s PL/SQL language.
5. Experience in performing analysis, troubleshooting and offering solutions to extract, transformation and load (ETL) processing errors and data inconsistencies.
6. Experience in data profiling.
7. Experience performance tuning SQL data load scripts.

At Employment and Social Development Canada, diversity is our strength. If you’re a woman, an Aboriginal person, a person with a disability or a visible minority and are interested in bringing in different perspectives and insights, let us know by completing the Employment Equity (EE) section in your application. Appointments of members of these EE groups could be made to ensure our workforce is inclusive and representative of the Canadian public we serve.

Conditions of employment

CONDITIONS OF EMPLOYMENT

VARIOUS:
Reliability Status security clearance
Secret security clearance

Other information

ACKNOWLEDGMENT OF RECEIPT OF APPLICATIONS WILL NOT BE SENT. WE WILL ONLY CONTACT THOSE CANDIDATES SCREENED INTO THE PROCESS.

Reference checks may be sought.

An interview may be administered.

A test may be administered.

A situational exercise may be administered.

No informal discussions will be held.

You must provide proof of your education credentials.

Candidates with foreign education credentials are required to provide proof of Canadian equivalency. Any applicable fees are the responsibility of the candidate.

Testing/interviews will be conducted at locations of the employer's choice and may
require candidates to travel to the test/interview location.

TRAVEL RELATED TO THE SELECTION OR APPOINTMENT PROCESS: Please note that candidates (including employees of the Public Service) will not be considered to be in travel status or on government business and that travel costs will not be reimbursed. Consequently, candidates will be responsible for travel costs.

Please note that within the context of this selection process, travel costs or travel expenses will not be reimbursed.

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

Indeterminate employees at the same group and level or equivalent may be considered for deployment. If no deployment is made, applicants from other groups and levels will be considered in the advertised appointment process.

Persons are entitled to participate in the appointment process in the official language of their choice.

You must indicate on your application if you require a technical aid for testing or an alternative method of assessment.

A random and/or top down selection of candidates may be used in the determination of those to be given further consideration in the assessment process.

Candidates must meet the essential qualifications to be appointed to a position.

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

Please identify clearly your substantive group and level and your employment status on your resume and/or application form.

The essential qualifications that are listed in the statement of merit criteria are mandatory. A pass mark will be established for each. Applicants may be appointed to the position even though he/she does not meet any or all of the asset qualifications. However, meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed. In the event that there are as many applicants who meet the essential qualifications as there are vacancies, the manager may decide not to assess some or all of the asset qualifications.

Pass marks will be established for each qualification. However, achieving the pass mark is not a guarantee of an appointment or that candidates will be put through the next stages of the assessment process. A cut-off score or a top-down approach may be used at any step if there is a sufficient number of candidates to meet immediate and anticipated staffing needs.

Candidates will be contacted by email and it is imperative that you provide a current email address that accepts e-mail from unknown users (some email systems block these types of email). Candidates are strongly encouraged to check their email on a regular basis. It is your entire responsibility to inform us at all times of any changes regarding your contact information.

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.

Information on the preference to veterans

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