This employment equity task involves:
- examining the workforce data you collected through the self-identification questionnaire to find out if:
- the representation of the 4 designated groups in your organization is equal to their availability in the
Canadian workforce (or one of its segments)
- designated group members are concentrated in specific occupational groups
- identifying any gaps in representation for each of the designated groups by occupation, including:
- areas of significant under-representation
- examining all hires, promotions and terminations
- writing a report detailing the results of your workforce analysis
Some parts of this task are only required of
Legislated Employment Equity Program employers.
On this page:
How to analyze workforce data and identify representation gaps
The purpose of your workforce analysis is to see how each of the 4 designated groups are represented within your
organization, by occupational group and/or by geographic area, compared to their availability in the Canadian
workforce (or one of its segments). This information will help you set quantitative short- and long-term goals to
close any representation gaps in your:
Once you have uploaded your employee.txt file into the Workplace Equity Information Management System (WEIMS), you
can download your workforce analysis report. It will show you in red where you have gaps in designated group
representation for each occupational group. WEIMS calculates this report using default values for the occupational
group, census metropolitan area, province/territory, or national location of recruitment based on the availability
of the designated groups in the Canadian workforce.
The illustration below shows an example of a workforce analysis report generated by WEIMS which shows the
representation of women within an organization. In this example, the employer has 4 financial managers and 1 is a
woman, so the "internal" representation of women in this National Occupational Classification (NOC) code occupation
by percentage is 25%. Financial managers are captured in the 'Middle & Other Managers' Employment Equity
Occupational Group (EEOG), which shows the availability of women in the broader workforce is 39.4%, so the
"external" representation (or availability) is higher than the "internal" representation. This means there is a
representation gap of women in the financial manager occupation, which is expressed numerically in column I.
Using the same example, the employer has 14 employees in the 'Middle & Other Managers' EEOG: financial managers,
human resources managers, advertising, marketing and public relations managers, and computer and information systems
managers. When analyzing the "internal" representation of women in this EEOG, compared to the "external"
representation in this EEOG across the Canadian workforce, there is no representation gap.
Workforce analysis template sample
Note that the WEIMS will automatically round up or down decimal points in the "external" representation (column H) and representation gap (column I).
The detailed tables of your workforce analysis report identify the:
- representation gap or (over)achievement for each designated group in each EEOG and/or NOC group, and
- the overall representation gap or (over)achievement in your organization's workforce.
They also identify any areas of significant under-representation that will inform your employment systems review. Significant gaps in representation are numerically captured as:
- -3 or a higher negative value in an EEOG (e.g. -4, -5, etc.)
- -3 or a lower negative value (e.g. -2, -1) in more than 2 EEOGs for a designated group
- -3 or a lower negative value (e.g. -2, -1) in the same EEOG for all 4 designated groups
How to do an advanced workforce analysis
Legislated Employment Equity Program employers
If you need to change the default values to make your workforce analysis report more accurate, this change must be
made in WEIMS before you generate your report. You must also record these changes and make the information available
during an audit.
Federal Contractors Program employers
If you need to change the default values to make your workforce analysis report more accurate, this change must be
explained in the contextual box in this section of the WEIMS and then approved by the Labour Program.
When to do a clustering analysis
Legislated Employment Equity Program employers
If you find more than 20 designated group members in an EEOG or a lower salary quartile compared to their
non-designated colleagues, you need to do a clustering analysis. For example, if your organization has 20 women and
5 men in middle management positions, but the majority of women are in salary quarter 1 or 2 while the men are in
salary quarter 3 or 4.
WEIMS has a clustering analysis template (shown below) so you can look more closely at your overall workforce and
each designated and non-designated group by EEOG at all four salary quarters. This template should be filled out
separately for:
- permanent full-time employees
- permanent part-time employees
- temporary employees
- all employees
To do a clustering analysis, fill in the top and bottom of the salary range for each occupational group (column C),
as well as the number of employees in each yellow column shown in the template sample below. You can use the data
generated by WEIMS in Form 2 parts A to C to make this task easier. WEIMS will automatically calculate the salary
ranges. Refer to the WEIMS user guide detailed steps on how to use the system to analyze clustered workforce data.
Clustering analysis template sample
How to analyze hires, promotions and terminations: Flow data analysis
In the last part of your workforce analysis, you need to look at the hires, promotions and terminations in your organization by occupational group to compare the
- percentage of hires of designated group members with external availability
- percentage of promotions of designated group members with internal representation
- percentage of terminations of designated group members with internal representation
Your objective is to find any areas where designated group employees are not being hired or promoted at the same
rates as their non-designated colleagues, as well as areas where there are high termination rates among designated
group employees.
WEIMS has a flow data analysis tool for Legislated Employment Equity Employers. There are also flow data analysis
tables within the achievement report template for Federal Contractors Program (FCP) employers who are preparing for
a subsequent compliance assessment. The flow data analysis tables, combined with Tab 8 of the achievement
report, function as a goal-setting tool.
An example of this table is shown below. You only need to fill in the yellow columns, but a separate table must be
created for hires, promotions and terminations of each designated group.
FCP achievement report flow data analysis table example
How to write a workforce analysis results report
Employers subject to the
Legislated Employment Equity Program must prepare a report on the results of their workforce analysis once it is completed. This report should include a:
- brief profile of your organization
- description of the methodology you used to do the workforce analysis, including an explanation of why you
changed the default values in WEIMS for occupational group or geographical recruitment location (if applicable)
- workforce analysis summary report and detailed tables identifying all representation gaps by EEOG and
designated group
- written description of the representation gaps identified in the report tables
- list of significant gaps, which will be the focus of your employment systems review
- description of the methodology and results of clustering and/or flow data analyses (if done)
- conclusion
The report will inform your employment systems review and the development of your employment equity plan. It should
be properly stored so it is available for any
compliance audit that may be done by the Canadian Human Rights Commission.