Branch: Technology and Information Management Branch

Employment Type: Indeterminate

Position Linguistic Designation: Bilingual (English, French)

Position Global Linguistic Level: B2

Salary: $108,836.99 - $122,492.00 + $1,798.58 Bilingual Allowance

Location: Ottawa Headquarters

Search Area: Internal; Membership; Public

Closing Date: 07/16/2025

Who are we?

Founded in 1966, The Public Service Alliance of Canada is the union that represents over 230,000 workers in every province and territory in Canada and in locations around the world. PSAC is headquartered in Ottawa with regional offices across the country. PSAC strives to enhance its members’ quality of life and has been at the front of significant and successful campaigns for workplace and human rights; Learn more about our victories.

We will support your mental and physical health with:

• Flexible work arrangements. Hybrid employees may have own dedicated workstations.
• Group Benefits (Health, Dental, Life Insurance, Disability Insurance, Employee and Family Assistance), such as $7,500 for mental health professionals, that are 100% paid by employer.
• Defined Benefit Pension Plan (50/50 contribution from you and us).
• Three (3) weeks' vacation to start, plus extra paid leave to support your wellness.
• Generous support for your professional growth and career development.
• Recreation allowance of $800 per year.

Primary Responsibilities:

Under the direction of the Manager, Data Solutions and Analytics and as a member of the Information Technology and Information Management Section, the Data and Analytics Officer (DAO) is responsible for developing and executing data strategy, governance and architecture, while leveraging the power of analytics and artificial intelligence (AI) to create an organizational advantage. The position oversees data management, system integration, governance, architecture, analytics and AI across all the Public Service Alliance of Canada’s data systems.

What you will bring to the table:

Education/Experience

• University degree in the field of computer science, mathematics, or statistics, or 8 years equivalent work experience in Data Architecture and Analysis.
• Demonstrated experience responding strategically and tactically to operational issues with innovative solutions including experience developing and implementing database solutions.
• Extensive experience with the programing languages: Python, R, VB.net, C#, SQL.
• In-depth experience with corporate Data Governance.
• Experience in data strategic planning and initiative designs to develop data strategies that fit in with both the long and short term and be readily adaptable.
• Experience implementing Data Analytical Systems utilizing historical and real-time data from multiple systems.
• Demonstrated experience in project management.
• Experience with data architecting, data mining, large-scale data modeling, and business requirements gathering and analysis of diverse user data and systems needs to develop solutions.
• Experience implementing data ecosystems with high data volume, high throughput, and various content structures

Knowledge

• Strong knowledge of current data privacy practices and laws such as PIPEDA and GDPR.
• Strong knowledge and experience with reporting tools such as Power BI, SSRS, Crystal Reports.
• Knowledge of Nintex workflow, Microsoft Power Apps and Microsoft Power Automate is an asset.
• Strong understanding of relational and non-relational data structures, theories, principles, and practices. (Data Lakes, NoSQL, CosmoDB, MongoDB, MSSQL, etc…)
• Advanced knowledge of Excel data connections, pivot tables and formulas.
• Understanding of Web services (SOAP, REST, XML, UDDI, WSDL).

Abilities

• Ability to anticipate, identify and understand data trends to be leveraged in management strategic decision making.
• Ability to communicate orally and in writing (according to the position’s requirements) with systems stakeholders and end-users as well as with technical specialists.
• Ability to work in a political organization with often competing priorities as well as a commitment to union and social justice issues.

Personal suitability

• Excellent judgment and demonstrated problem solving, consultative, persuasive and conflict resolution skills to provide technical advice and guidance on complex data related technologies and process issues to all levels of users.

What you need to know:

• Second language skills as per the Common European Framework of Reference for Languages (CEFR) level indicated above. Federal Government valid SLE results can be used toward this. Preferred candidates may have their second language skills assessed as part of the hiring process.
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.
• While we appreciate all the candidates’ interest, only those considered in the process will be contacted.
• A full job description is available upon request.

NOTES:

Internal applicants should submit their résumé online through the internal career site.

Indeterminate PSAC employees who meet all the qualifications of this position can request a transfer in accordance with the relevant collective agreement by uploading a cover letter indicating it is a transfer request, on or before the closing date. Please also upload a resume in your candidate profile (if not previously done) and indicate “Yes” under “Employment Information”, in your candidate profile when requesting a transfer.

The objective of the PSAC's policy on Employment Equity is to achieve equality in the workplace for women, Indigenous peoples, racialized persons, persons with Disabilities, Lesbians, Gays, Bisexuals and 2SLGBTQIA+ community people.
The Employee Self-Identification Questionnaire is an important part of the PSAC’s Employment Equity Program. All of the individual information collected from this questionnaire will be kept strictly confidential.
The statistics gathered from this survey will assist the PSAC in obtaining an accurate profile of its current workforce, which will enable us to keep an up-to-date and progressive employment equity plan.
In many cases, you may identify in more than one designated group. For example, you may identify yourself as an Indigenous person and a person with a disability and a woman.
False declaration on the Employment Equity Self-Declaration Questionnaire will be taken seriously and may prompt an investigation or further actions, as necessary.

Please contact hractionhr@psac-afpc.com to obtain this questionnaire in an alternate format (i.e. large print) or should you need more information or require assistance in completing this questionnaire.

Accommodations are available on request for candidates taking part in the selection process. For accommodation needs or to obtain a copy of the documents in alternate format, please email hractionrh@psac-afpc.com.