Various IT-02 Technical Advisor Positions

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

Global Affairs Canada (GAC) is committed to advancing equity and embracing diversity and inclusion by implementing meaningful actions that are founded in respect, collaboration and accountability. GAC is committed to ensuring that its workforce both at home and abroad is representative of Canada’s current and evolving population. GAC’s dedication towards advancing equity diversity and inclusion is exemplified through the various efforts and initiatives in place that aim to ensure representation at all levels, provide equitable career opportunities, provides a safe and accessible workplace and to strengthen the inclusivity of the workplace so that all employees have the possibility to be authentic. All candidates who believe they are qualified are encouraged to apply, including Black, other racialized and Indigenous peoples, women, persons with disabilities and persons of the 2SLGBTQI+ community. We invite you to be part of the change by joining an organization where your voice is heard, valued, respected and amplified. Knowing that diverse teams foster innovation we strongly encourage you to complete the Employment Equity (EE) section in your application.

Work environment

A career in the Department helps to shape Canada's place in the world. Global Affairs Canada is made up of professionals who work in the National Capital Region and around the world. Global Affairs Canada is also a global network of 178 missions in 110 countries that supports the international work of the Department and 37 partner departments, agencies and co-locators. With six regional offices across Canada and more than 11,000 employees supporting this network, Global Affairs Canada offers you the opportunity to pursue a broad career with challenging perspectives that enrich professional skills and broaden perceptions of other cultures.

Our organization offers a healthy, inclusive and diverse workplace where respect, teamwork, and collaboration are part of our culture, and where innovation is valued.

Global Affairs Canada is committed to promoting and supporting values such as equitable treatment, accommodation and an environment free from harassment and discrimination as well as encouraging and supporting employees to work at their full potential.

Intent of the process

The intent of this process is to fill various IT-02 positions in different teams within Global Affairs Canada with various language levels.

List of positions to be filled:
Stream A - Data Warehouse Developer
Stream B - Enterprise Data Management Analyst
Stream C - Platform Analyst Position
Stream D - Data Science and Artificial Intelligence
Stream E - Application Development
Stream F – Cloud Application Development

Positions to be filled: Number to be determined

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.

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.
3. At the manager’s discretion, an acceptable combination of education, training and/or experience may serve as an alternative to the minimum 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 working, developing, operating or supporting IM/IT solutions to meet business needs.

2. Experience providing technical services or solutions in at least one of the following areas:
a. Business Intelligence and Analytics
b. Data Management
c. Data Engineering
d. Data Architecture
e. IT Support
f. Cloud Administration
g. Application or Web development
h. Platform Administration
i. Data science and Artificial Intelligence

Knowledge

1. Knowledge of current and emerging IM/IT trends
2. Knowledge of current and emerging trends in data and analytics.

Abilities

1. Ability to build effective working relationships.
2. Ability to synthesize information from various sources.
3. Ability to communicate effectively orally and in writing.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

Stream A – Data Warehouse developer

ESSENTIAL CRITERIA
1. Experience working with ETL software (eg. Microsoft SSIS, IBM DataStage, Informatica) or Azure analytics services (e.g., Data Factory, Databricks, Data Lake, Synapse).
2. Experience with scripting languages such as SQL, Python.

ASSET CRITERIA
3. Experience working in Agile Scrum teams on projects and working in an environment using Agile software development methodology.
4. Experience in co-designing solutions with clients and in rapid-prototyping.
5. Experience developing dimensional data models

Stream B – Enterprise Data Management analyst

ESSENTIAL CRITERIA
6. Experience working in data management or database management such as master data management, DAMA Data Management Body of Knowledge, ETL processing, Enterprise Data Warehouse, data relationships, metadata management, governance catalog, data profiling or data quality.
7. Experience providing client services in the development of data management solutions and artefacts including identifying and analyzing current and future client needs.

ASSET CRITERIA
8. Experience planning, coordinating or facilitating data steward working groups.
9. Experience supporting the development of data standards or policies.
10. Experience in actively participating in inter departmental working groups.

Stream C – Platform analyst

ESSENTIAL CRITERIA
11. Experience supporting the development of technical documents such as: architectures, concepts of operations, designs, procedures, specifications reports or standards.
12. Experience with key platform elements such as network elements, security elements (e.g., firewalls), data center elements, database administration, application programing interfaces (API), code repositories (e.g., DevOps).
13. Experience supporting the deployment and configuration of Azure analytics services (e.g., Databricks, Data Lake, Synapse, Purview etc.).

ASSET CRITERIA
14. Experience supporting the development of solution architectures.
15. Experience in troubleshooting and resolving technical issues of a Cloud platform.

Stream D – Data Science

ESSENTIAL CRITERIA
16. Experience performing complex data exploitation on large volumes of data.
17. Experience in the creation and implementation of algorithms and statistical techniques.
18. Experience with supervised and unsupervised machine learning.
19. Experience with text analytics and natural language processing (NLP).
20. Experience in the design, creation, and implementation of graph analytics.

Stream E - Application Development (IBM Planning Analytics)

ESSENTIAL CRITERIA
21. Experience in developing IBM Planning Analytics solutions with experience in using Rules, Feeders, Cubes, Dimensions and Turbo Integrator processes.
22. Experience in Data Modelling, Multi-Dimensional Analysis, ETL processes, SQL, data structures and data manipulation.

ASSET CRITERIA
23. Experience in creating and maintaining technical documentation, such as, but not limited to, design documents, deployment guidelines, test cases.
24. Experience with financial planning, budgeting and forecasting cycles.
25. Experience in troubleshooting technical issues related to IBM Planning Analytics solutions.

Stream F – Cloud Application Development

ESSENTIAL CRITERIA:
26. Experience in designing, developing, and deploying software solutions in a corporate environment, with preference on cloud native applications.
27. Experience with modern programming languages such as C#, Python, Java, etc.
28. Experience in frontend software development using modern web technologies such as JavaScript, HTML5, React, etc.
29. Experience writing various types of automated tests (unit/integration/functional/performance).
30. Experience working with Relational DBs such as SQL Server, PostgreSQL, or other large-scale RDBMS
31. Experience with test-driven development, agile practises, and Git workflows.

ASSET CRITERIA:
32. Experience with CI/CD pipelines.
33. Experience in administering, supporting or maintaining software solutions in MS Azure Cloud platforms such as: Azure Functions, Azure Web Apps, Azure Synapse Analytics, Azure Databricks, Azure Cognitive Search, Azure SQL Databases.
34. Experience in creating and maintaining technical documentation, such as, but not limited to, design documents, deployment guidelines, test cases.
35. Experience with container technologies such as Docker and Kubernetes.

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

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

Information on language requirements

Personal Suitabilities

1. Client focus
2. Analytical thinking
3. Creative thinking
4. Judgment

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

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
Ability and willingness to travel on occasion.
Ability and willingness to work overtime on short notice.

Conditions of employment

Secret security clearance

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

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 qualified candidate may be offered the position even though they do not meet any or all of the asset qualifications. However, asset criteria are desirable and may be applied at any point of the staffing process by the hiring manager, including for being a deciding factor in choosing the candidate.
Communications for this selection process will be sent via email. It is the responsibility of the candidate to ensure accurate contact information (including the email address) is provided and updated as required.
You will be required to provide proof of your education credentials.
The board members may retain a certain number of applicants for further assessment, based on a top-down approach, random selection or based on some of the assets qualifications. Only applicants whose candidacy is retained will be contacted.
All qualifications could be assessed throughout the process, including by using email communications.
Applications submitted by email will not be accepted. You must apply on-line through www.canada.ca/en/public-service-commission/jobs/services/gc-jobs.html.

Persons who cannot apply online or persons with disabilities preventing them from applying online are asked to inform the contact persons responsible for this process prior to the closing date. You may also review jobs open to the public through INFOTEL at 1-800-645-5605. The INFOTEL number for persons using a TTY/TDD is 1-800-532-9397.

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.