Data Architect

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

Candidates must clearly explain in detailed in their answers to the screening questions how they meet each required education and experience criterion including the assets qualifications. Particular attention should be paid to AEX1 in the Asset qualifications. It is important if you possess this asset that you explain how you meet each of the criterions listed under *Measured.

When providing your answers you must include where and how you obtained the required education and experience, as well as the period(s) in which you performed those duties. Please note that stating the requirement has been met, and/or listing past or current responsibilities, does not represent adequate substantiation. Candidates must provide concrete examples that clearly illustrates how they meet each one of them. Each answer must be different from one another (NO COPY PASTE) and must address the specific question.

Please note that your answers to the pre-screening questions will be used to evaluate the ability to communicate effectively in writing.

Only the information provided in the answers to the questions will be used for screening purposes. Candidates will not be solicited for incomplete or possible missing information. Resumes will only be used as a secondary source to validate the education and/or experience described in the answers to the screening questions. Failure to provide the information in the requested format will result in candidates’ applications being rejected.

WORK LOCATIONS
Please note that although IITB is a national organization, all positions staffed as a result of this process are located in the NCR.

Intent of the process

A pool of qualified candidates will be established and used to staff CS-02 data architecture positions within Employment and Social Development Canada in the National Capital Region with various linguistic profiles (Bilingual Imperative BBB/BBB, English Essential, French Essential)

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
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 the manager has specified this alternative.

Degree equivalency

EXPERIENCE
EX1- Recent* experience in developing conceptual OR logical OR physical data models.
EX2- Recent* experience in developing and implementing data models in one or more of the following areas: operational applications (transactional processing); Data Warehouse or Data Mart applications (analytical processing).

Definition of experience: Experience is defined as experience gained through employment, studies, volunteer work or an acceptable combination for a minimum period of one (1) year in the IM/IT field.

*Recent is defined as experience normally acquired within the last three (3) years.

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

Various language requirements
Bilingual Imperative BBB/BBB
English essential
French essential

Information on language requirements

KNOWLEDGE
K1- Knowledge in one or more of the following tools: Oracle SQL Developer Data Modeler, E/R Studio, Erwin Data Modeler and IBM InfoSphere Data Architect.

ABILITIES
A1- Ability to develop conceptual OR logical OR physical data models.
A2- Ability to communicate effectively orally.
A3- Ability to communicate effectively in writing.
A4- Ability to analyze technical problems and make appropriate recommendations.
A5- Ability to plan, prioritize and meet deadlines

PERSONAL SUITABILITY
PS1- Focus on quality and details
PS2- Teamwork
PS3- Judgement

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

ASSET QUALIFICATIONS

EDUCATION
AED1- Graduation with a degree from a recognized post-secondary institution in one of the following programs: computer engineering, computer science, information technology, information management, business technology management

Degree equivalency

EXERIENCE
AEX1- Measured* experience in data modeling.
AEX2- Experience in data profiling.
AEX3- Experience in conducting requirement gathering sessions, documenting data requirements and providing impact analyses for database solutions.
AEX4- Experience in developing technical specifications for data Extract, Transformation and Load (ETL) routines as required to support requirements.
AEX5- Experience in performing analysis, troubleshooting and offering solutions to Extract, Transform and Load (ETL) processing errors and data inconsistencies.

*Measured - Following are the different criterions that will be used to measure the depth and breadth of experience:
• Years of experience developing data models.
• Size of Data Models.
• Generated Logical model from conceptual.
• Generated Physical model from logical.
• Generated DDL from Data Model.
• Designed models with super-types and sub-types.

Employment and Social Development Canada is committed to employment equity (EE). In order to achieve a representative workforce, selection may be based on qualified candidates self-declaring as being a member of one or more of the following EE groups: Aboriginal peoples, persons with disabilities, women and visible minorities.

OPERATIONAL REQUIREMENTS
- Willingness to work overtime, if necessary, often on short notice.

CONDITIONS OF EMPLOYMENT
- Reliability Status

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

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

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

Candidates may have to meet the assets qualifications according the requirements of the position to be staffed.

1. Reference checks will be sought.
2. An interview will be administered.
3. A written examination may be administered.

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

Acknowledgment of receipt of applications will not be sent; we will contact candidates when the screening process is completed.

PLEASE NOTE: For this selection process, our intention is to communicate with applicants by e-mail for screening/ assessment purposes ( including issuing screening results, and sending invitations for written tests and interviews). Applicants who apply to this selection process must include in their application a valid e-mail address and make sure this address is functional at all times and accepts messages from unknown users. It is your responsibility to inform us at all times of any changes regarding your contact information.

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.