Technical Advisor, Enterprise Architecture

Important messages

Only applications received directly via the System (https://www.canada.ca/en/public-service-commission/jobs/services/public-service-jobs.html) will be accepted. If you require accommodation for any reason, you must contact the HR Advisor listed below before the closing date.

If you do not clearly demonstrate how you meet all screening criteria, your application will be rejected. Your application may also be rejected if it has incomplete information. We will not contact you to request information that is missing from your application.

Work environment

The Treasury Board of Canada Secretariat (TBS) is a central agency located in the National Capital Region. Working at TBS offers a unique opportunity to contribute to the work of a central federal agency, and to be part of cultivating the federal public service as a model workplace. With high-performing teams and innovative practices, TBS professionals in various fields serve Canadians by collaborating on government-wide initiatives, driving excellence in people management and taking initiative while effectively managing risks.

Employees of the TBS Corporate Services Sector (CSS) have recently moved to a newly renovated building in the downtown core that meets the government’s new Workplace 2.0 concept and has Wi-Fi throughout. Employees have access to amenities such as showers, change rooms and secure bicycle storage, allowing them to commute using Ottawa’s bike path system.

If you are a leader, a motivator and a strategic thinker who wants to work for one of Canada’s Top Employers, consider joining the TBS team.

Intent of the process

ANTICIPATORY PROCESS - A pool of qualified persons resulting from this process WILL be created and MAY be used to fill similar positions with linguistic profiles (English essential, bilingual imperative BBB/BBB, bilingual imperative CBC/CBC) as well as tenures (indeterminate, deployment, acting, assignment, secondment, specified period) which may vary according to the position being staffed.

This pool may be used to staff similar positions in other organizations within the core public administration (http://www.psc-cfp.gc.ca/plcy-pltq/rfli-lirf/index-eng.htm).

By applying to this process, you consent to your personal application-related information being shared with other government departments interested in staffing similar positions

Positions to be filled: 1

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.

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:
-Recent* and significant** experience working in an Information Management and Information Technology (IM/IT) environment analyzing data requirements;
-Significant** experience in designing and developing conceptual, logical and physical (e.g. 3Normal Form) data models, such as the design and development of data models to create application database structures;
-Recent* and significant** experience in data architecture and modeling and data flow modeling;
-Recent* and significant** experience with MS SQL Server or oracle server coding (2008 and above);
-Recent* and significant** experience in data migration analysis;
-Experience with ERWIN or Oracle SQL Developer Data Modeler or an equivalent tool.

Notes:
*Recent is defined as experience normally acquired within the last seven (7) years.
**Significant is defined as depth and breadth of experience normally associated with the performance of those duties for a period of approximately five (5) years.

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

Various language requirements
-English Essential;
-Bilingual Imperative BBB/BBB;
-Bilingual Imperative CBC/CBC.

Information on language requirements

Knowledge:
-Knowledge of ISO data Standards related to data modeling;
-Knowledge of data architecture principles;
-Knowledge of MS SQL Server 2008 or above;
-Knowledge of SQL and procedural languages.

Behavioural Competencies:
-Analytical Thinking: Analyzing and synthesizing information to understand issues, identify options, and support sound decision making;
-Planning and organizing : Ability to work on multiple concurrent projects;
-Team Work: Working collaboratively with others in a multidisciplinary team setting to achieve organizational goals;
-Communication: Ability to communicate effectively both orally and in writing.

Competencies:
-Negotiation: Ability to promote data architecture principles while taking into considerations operational realities.

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

Asset Qualifications

Education:
-Graduation with a degree from a recognized post-secondary institution in information technology or a related field.

Degree equivalency

Certification:
-DAMA (Data Management) certification;
-TOGAF (The Open Group Architectural Framework) certification.

Experience:
-Experience in designing or exposure to master data management concepts;
-Experience in Extract, Transform & Load (ETL), data architecture analysis, ETL process modelling and ETL design;
-Experience with CA ErwinV7.3 or above.

Knowledge:
-Knowledge of the business process modeling.

Organizational Needs:
-Treasury Board Secretariat employees affected by workforce adjustment may be appointed before persons employed by other government organizations;
-In support of achieving a diverse workforce, consideration may be given to candidates self-identifying as belonging to one of the following Employment Equity groups: Aboriginal peoples, persons with disabilities, members of visible minorities, and women.

Operational Requirement:
-Willingness to work overtime on short notice.

Conditions of employment

Secret security clearance

Other information

Reference checks may be sought.

An interview may be administered.

A test may be administered.

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

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

You must provide proof of your education credentials.

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.

We will communicate with you about this process by email. As a result, you must update your Public Service Resourcing System profile if it changes. Applicants should use an email address that accepts messages from unknown senders (some email systems block such messages).

If you do not respond to our communications, we will interpret this as your withdrawal from the process.

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

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.