Senior Economic and Socio-Economic Analyst **AMENDMENT TO CLOSING DATE**

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

** Initial closing date December 14, 2022 - 23:59, Pacific Time **


Please apply online. When applying:

Candidates must complete the screening questions on the Public Service Resourcing System (PSRS) application website, in the space provided for each question. Candidates must meet all the essential qualifications in order to be appointed to a position. Asset qualifications may be a deciding factor in choosing the person to be appointed. Please note that only stating the Essential Experience qualifications have been met, and/or listing job titles and responsibilities does not represent adequate substantiation and, as such, it is the candidate’s responsibility to provide appropriate examples that illustrate how they meet each screening qualification.

DETAILED RESPONSES TO THE SCREENING QUESTIONS IN THE APPLICATION MUST BE COMPLETED IN ADDITION TO YOUR RESUME.

Resume may be used as a secondary source to validate the qualifications described; comments such as "refer to my attached resume" will not be accepted and may result in your application being rejected.

Intent of the process

At least 3 positions will be filled on an immediate and indeterminate basis.

These positions are with the Data Analysis and Reporting Unit (DRAU) of the Non-Insured Health Benefits (NIHB) Program.

The incumbent of one (or more) of these positions will work as a part of the DRAU team that undertakes and leads the data analysis necessary to support critical program management activities related to the development and implementation of complex rebate agreements with private industry, all with varying contracting elements and parameters. The incumbent of this position will utilize SAS, Structured Query Language (SQL) and algebra to implement and run these rebate calculations using automated database queries.

The incumbents of the other positions will work as a part of the DRAU team that supports internal and external stakeholders through claim data analyses, which are leveraged for evidence based policy and program decision making and for First Nations and Inuit community program planning.

In addition, a pool of partially or fully qualified candidates will be established through this process for anticipatory staffing of positions with various tenures, official language proficiencies and security profiles.

Positions to be filled: 3

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 with a degree from a recognized post-secondary institution with acceptable specialization in economics, sociology or statistics.

Candidates must always have a degree. The courses for the specialization must be acceptable and may have been taken at a recognized post-secondary institution, but not necessarily within a degree program in the required specialization. The specialization may also be obtained through an acceptable combination of education, training and/or experience.

Degree equivalency

EXPERIENCE:

Significant * experience extracting, manipulating and analyzing data from computer database systems, including utilizing SQL to develop queries for relational databases.

Significant *experience conducting data analyses, and providing reports to internal or external clients.

Significant* experience working with statistical software applications (e.g., SPSS, R, SAS, etc.) excluding spreadsheet applications (e.g., Microsoft Excel, Google Sheets, Apple Numbers, etc.).

Experience preparing written material (e.g., briefing note, presentation deck, statistical report, written recommendations).

Experience working collaboratively with internal or external stakeholders or clients.

* Significant experience is defined as the depth and breadth of experience associated with having performed complex related activities normally acquired over a period of three (3) years.

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

Various language requirements
English Essential, Bilingual Imperative BBB/BBB

Information on language requirements

KNOWLEDGE:

Knowledge of practical techniques used to design and implement procedures for the collection, validation and analysis of data.

COMPETENCIES:

Communication - Oral
Communication – Written
Ability to work under pressure to meet tight deadlines.
Ability to prepare and present information in textual, tabular and graphical formats.
Ability to clean, manipulate, analyze and validate data, and make recommendations based on results.
Ability to implement complex technical and business requirements.
Demonstrating integrity and respect
Working effectively with others
Showing initiative and being action-oriented
Thinking things through

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

ASSET EDUCATION:

Master’s degree from a recognized post-secondary institution in a field related to the position such as statistics, algebra, or economics.

Degree equivalency

ASSET EXPERIENCE:

Experience using data querying software (e.g., ORACLE, COGNOS, etc.)

Experience creating pivot tables in Microsoft Excel

Experience developing Visual Basic for Applications (VBA) code

Experience working with large** data sets

** Large data sets are defined as datasets with more than a million rows.

ASSET KNOWLEDGE:

Knowledge of statistics
Knowledge of algebra
Knowledge of epidemiology
Knowledge of health economics
Knowledge of health claim processing of extended health benefit programs (public or private)
Knowledge of pharmacologic classification systems
Knowledge of systems or business practices used in pharmacy, dental care, vision care, medical supplies and equipment, mental health care, or medical transportation.
Knowledge of Indigenous communities or organizations in Canada including their social, economic, political structures and cultures

CURRENT AND/OR FUTURE ORGANIZATIONAL NEEDS:

Indigenous Services Canada is committed to having a skilled and diversified workforce representative of the population it serves. In support of our strategy to achieve our employment goals for Aboriginal peoples, preference may be given to candidates who, at the time of application indicate that they are an Aboriginal person (self-declaration).

The term Aboriginal is used, as per the Employment Equity Act, to define a North American Indigenous person as members of First Nations, Inuit or Métis. North American Indigenous people or members of First Nation include treaty, status or registered Indigenous people, as well as those non-status and non-registered. However, please note that the terms Aboriginal and Indigenous are used interchangeably within this job advertisement. Both terms include First Nations, Inuit and Métis.

The Self-declaration is completed as part of the job application under the “Employment Equity” tab and your affiliation as a member of First Nations, Inuit or Métis will be will be verified via an Affirmation Affiliation form to be provided later in the staffing process.

Conditions of employment

Security: Secret security clearance - Reliability Status

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

Our intention is to communicate with candidates via email. Candidates who apply on this opportunity must include in their application a valid e-mail address and to make sure that this address is functional at all times and accepts messages from unknown users (some email systems block these types of email). It is the applicant's responsibility to ensure that accurate contact information is provided and updated as necessary.

Applications will not be acknowledged; applicants will be contacted once the screening process is complete.

FAILURE TO CLEARLY DEMONSTRATE HOW YOU MEET THE ESSENTIAL CRITERIA (Education and Experience) WILL RESULT IN THE REJECTION OF YOUR APPLICATION. APPLICANTS WILL NOT BE SOLICITED FOR INCOMPLETE OR POSSIBLE MISSING INFORMATION.

Reference checks will be conducted;
An interview will be conducted;
A written examination may be administered.

It is the applicant's responsibility to ensure that their application is submitted correctly and on time. ALL APPLICATIONS MUST BE ONLINE THROUGH THE SRFP SYSTEM. No applications will be accepted after the deadline. Applicants will not be contacted to complete files or obtain missing information.

VERY IMPORTANT NOTE: The PSRS system will shut down after 60 minutes, which may prevent you from saving your work or cause you to lose data. We recommend that you create a draft of ALL YOUR RESPONSES, as well as your application, in another document on your computer that you can save (e.g., in MS Word or WordPerfect), and then copy and paste it into the PSRS system when you are finished. Indigenous Services Canada IS NOT RESPONSIBLE FOR SYSTEM PROBLEMS THAT MAY RESULT IN LOST DATA AND/OR INCOMPLETE APPLICATIONS OR NON-SUBMISSION OF APPLICATIONS

Persons are entitled to participate in the appointment process in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

Proof of education will be required. Candidates with foreign credentials must provide proof of Canadian equivalency. Consult the Canadian Information Centre for International Credentials for further information at http://www.cicic.ca

Proof of citizenship:

All applicants who are new to the federal public service must provide proof of citizenship or permanent residency prior to their appointment. This is necessary for both temporary (specified period) and permanent (indeterminate) employment. Any of the four (4) documents would be accepted: 1. Birth Certificate, 2. Passport, 3. Citizenship Certificate or 4. Permanent resident card (PR card). Note: An expired passport, satisfies the proof of citizenship requirement.

How to obtain Canadian Citizenship Certificate: The citizenship certificate is provided by Immigration, Refugees and Citizenship Canada. To learn about how to obtain the certificate, visit this link:

https://www.canada.ca/en/immigration-refugees-citizenship/services/canadian-citizenship/proof-citizenship/eligibility.html

Note that there is a fee to receive this certificate and the displayed wait time for the production of the certificate may be several months, however; requiring proof of citizenship in order to obtain employment would be considered an urgent reason, significantly reducing the wait time.

Depending on the number of applicants, needs and/or plans, volume management strategies such as, but not limited to, top-down approach, cut-off scores, asset selection, random selection and/or assessment may be used for the purpose of managing applications/candidates and/or determining which candidates will continue in the staffing process. Should a volume management strategy be used, communication regarding the application of the strategy will be provided to those candidates who are impacted.

Assignment or acting appointment are temporary resourcing options. The approval of your SUBSTANTIVE manager will be required before an employment offer can be made.

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.