This repository contains code to visualize employee salary data from the Government of Canada’s Treasury Board, publicly available here. You can access the GitHub repo here.
This data is based on self-identification of equity-deserving group
and is only available for the core federal public service. In order to
obtain the data, the webpage was scraped with the R package
rvest. Then, dplyr and tidyr were
used to clean it up and plotting was done with: ggplot2,
plotly scales, and MetBrewer.
We are including the following groups in
Total Asian Population:
Non-White West Asian was not included because it was grouped along with North African and Arab. If needed, this group can be added into the data.
This plot looks at the total count of self-identifying Asian employees.
This plot looks at the year-over-year (YOY) growth of self-identifying Asian employees.
Considering these two plots, we can see that though the YOY is comparable between Asian and non-Asian employees, the pre-existing disproportionality between the groups continue to persist.
To give context, in the 2016 Census 6,095,235 people in Canada reported having Asian origins, representing 17.7% of Canada’s population.1 At most, ESDC in 2021 had 12.16% of their employees self-identifying as Asian.
This is a more focused plot which looks at the top 10 departments with the highest Asian population.
This is a really busy plot but it shows the breakdown of Asian and non-Asian employees by count.
Moving forward, these data can be further broken down looking more into the departments/agencies, looking at the classification, salary wages, etc. We can also compare the data to the Workforce Availability for a more accurate comparison.
Source: Statistics Canada. 2017. Canada [Country] and Canada [Country] (table). Census Profile, 2016 Census.↩︎