Various positions IT-03(Stream 1: Technical Advisor and Stream 2: 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

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 Technical Advisor and Team Leader positions in different teams within Global Affairs Canada with various language levels.

List of positions to be filled:

Stream A. Technical Advisor, Scrum Master
Stream B. Technical Advisor, Enterprise Data Management
Stream C. Technical Advisor, Platform
Stream D. Technical Advisor, Data Scientist and Artificial Intelligence
Stream E. Technical Advisor, Application Development
Stream F. Technical Advisor, Cloud Application Development
Stream G. Team Leader, Product Owner
Stream H. Team Leader, Enterprise Data Management
Stream I. Team Leader, Platform
Stream J. Team Leader, Business Analyst

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

The minimum standard is:
• Graduation from, at a minimum, a 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 education. 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

Ex1. Recent* and significant** experience working in multi-disciplinary teams to develop, operate and support IM/IT solutions to meet business needs.

Ex2. Significant** experience providing technical services or advice in at least one of the following areas
a) Business Intelligence and Analytics
b) Data Management
c) Data Engineering
d) Enterprise Architecture
e) Data Architecture
f) Product Management
g) Platform Administration
h) Data Science and Artificial Intelligence
i) Application Development

Recent* is defined as experience gained within the last five (5) years.

Recent experience is required due to the fast changing nature of IT technologies, methodologies and best practices.

Significant** is defined as experience normally associated with having performed a broad range of related activities for a period of approximately five (5) years.

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

Stream A: Technical Advisor, Scrum Master

ESSENTIAL CRITERIA
1. Recent* and significant** experience leading Agile Scrum teams on projects and working in an environment using Agile software development methodology
2. Recent* and significant** experience working with ETL software (eg. MS SSIS, IBM DataStage, Informatica) or Azure analytics services (e.g. Data Factory, Databricks, Data Lake, Synapse) and/or
3. Significant** knowledge of Kimball or Inmon design patterns for data warehouse design

ASSET CRITERIA
4. Recent* and significant** experience conducting architectural evaluation, design and analysis of enterprise data warehouse solutions
5. Recent* and significant** experience troubleshooting ETL and database performance issues
6. Significant** experience coaching and mentoring junior team members

Stream B, H: Technical Advisor / Team Leader, Enterprise Data Management

ESSENTIAL CRITERIA
7. Significant** experience in data management or database management such as reference and 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.
8. Experience providing client services in the development of data management solutions and artefacts including identifying and analyzing current and future client needs.

ASSET CRITERIA
9. Experience developing, implementing or leading data governance initiatives.
10. Experience planning, coordinating and facilitating data steward working groups.
11. Experience developing data standards/policies.

Stream C, I: Technical Advisor / Team Leader, Platform

ESSENTIAL CRITERIA
12. Experience in the development of technical documents such as: architecture diagrams, concepts of operations, design documents, procedures, specifications reports or standards.
13. Experience in working with key platform elements in support of application development such as network elements, security elements (e.g., firewalls), data center elements, database administration, application programing interfaces (API), code repositories (e.g., DevOps).
14. Experience configuring Azure analytics services (e.g., Data Factory, Databricks, Data Lake, Synapse, Purview etc.).

ASSET CRITERIA
15. Experience developing or implementing enterprise or complex solution architectures.
16. Experience providing or delivering cloud services or managing cloud-based environments
17. Experience integrating Azure services with other Microsoft 365 solutions.

Stream D: Technical Advisor, Data Science and Artificial Intelligence

18. Experience performing complex data exploitation on large volumes of data to provide tactical and strategic insights directly to analysts, business owners, and decision makers.
19. Experience in the creation and implementation of algorithms and statistical techniques.
20. Experience with supervised and unsupervised machine learning.
21. Experience with text analytics and natural language processing (NLP).
22. Experience in the design, creation, and implementation of graph analytics.

Stream E: Technical Advisor, Application Development (IBM Planning Analytics)

ESSENTIAL CRITERIA
23. Recent* and significant** experience in providing IM/IT advice and guidance to management, colleagues or clients as a subject matter expert.
24. Experience in developing IBM Planning Analytics solutions with significant experience in using Rules, Feeders, Cubes, Dimensions and Turbo Integrator processes.
25. Experience in Data Modelling, Multi-Dimensional Analysis, ETL processes, SQL, data structures and data manipulation.

ASSET CRITERIA
26. Significant** experience in creating and maintaining technical documentation, such as, but not limited to, design documents, deployment guidelines, test cases.
27. Experience demonstrating knowledge of financial planning, budgeting and forecasting processes.

Stream F: Technical Advisor, Cloud Application Development

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

ASSET CRITERIA:
34. Experience with CI/CD pipelines.
35. 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.
36. Experience in creating and maintaining technical documentation, such as, but not limited to, design documents, deployment guidelines, test cases.
37. Experience with container technologies such as Docker and Kubernetes.

Stream G: Team Leader, Product Owner

ESSENTIAL CRITERIA
38. Recent* and significant** experience working in Scrum teams on projects, working in an environment using Agile software development methodology leading product development from concept to release, while ensuring continuous improvement.
39. Recent* and significant** experience providing client services in the development of solutions including identifying and analyzing current and future client needs as well as eliciting, specifying or modelling requirements in an IM/IT environment.
40. Recent* and significant** experience facilitating user story workshops, writing user stories and managing and prioritizing the product backlog.

ASSET CRITERIA
41. Significant** experience in the review, development and application of business process models such as use cases, process maps or workflow diagrams.
42. Significant** experience building and maintaining solid relationships with clients, partners, senior management, and other stakeholders to understand requirements, goals, constraints to develop products that are valuable, usable and feasible.
43. Significant** experience providing product management advice and guidance to clients, senior management, and other stakeholders.

Stream J: Team Leader, Business Analyst

ESSENTIAL CRITERIA:
44. Significant** experience in eliciting requirements and managing business relationships, with clients, partners, senior management, and other stakeholders
45. Significant** experience performing business analyses of functional requirements to identify information, procedures, and decision flows
46. Recent* and significant** experience using collaborative and centralized project and issue tracking tools, such as JIRA, Azure DevOps
47. Recent* and significant** experience defining and documenting interfaces of manual to automated operations within application subsystems, to external systems, and between new and existing systems
48. Recent* and significant** experience in compiling and documenting background information and generating technical acceptance criteria based on business requirements
49. Significant** experience documenting business processes, requirements, work plans, options analysis, current and future state solutions.

ASSET CRITERIA:
50. Significant** experience in performing impact analysis, dependency analysis and mapping
51. Significant** experience identifying and evaluating critical success parameters, factors and performance measurements

Recent* is defined as experience gained within the last five (5) years.

Recent experience is required due to the fast changing nature of IT technologies, methodologies and best practices.

Significant** is defined as experience normally associated with having performed a broad range of related activities for a period of approximately five (5) years cumulatively throughout one’s career.

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

Various language requirements
Technical Advisor positions
English essential, English or French, Bilingual Imperative BBB/BBB, CBC/CBC

Team Leader positions
Bilingual Imperative BBB/BBB, CBC/CBC

Information on language requirements

KNOWLEDGE

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

ABILITIES AND SKILLS
All streams
1. Ability to manage multiple priorities under strict deadlines
2. Ability to build effective working relationships
3. Ability to analyze problems and develop recommendations
4. Ability to facilitate meetings with clients and stakeholders
5. Ability to communicate effectively orally and in writing
6. Ability to mentor junior team members

Team leader positions
7. Ability to mobilize people

PERSONAL SUITABITILIES

1. Attention to detail
2. Dependability
3. Judgment
4. Initiative
5. Client focus

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
1. Ability and willingness to travel on occasion.
2. 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.