Senior Analyst

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

Intent of the process

The immediate need is to staff one position on an indeterminate basis.

This selection process may be used to establish a pool of partially qualified and/or qualified candidates which could be used to staff similar positions at the Office of the Superintendent of Financial Institutions.

Positions to be filled: 1

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:
- Successful completion of an acceptable post-secondary educational program in computer science, information technology, information management or another specialty relevant to the position to be staffed.

Degree equivalency

EXPERIENCE:
- Significant experience* using SQL Server Integration Services (SSIS).
- Significant experience* developing and loading data warehouse (DW) systems.
- Significant experience* analyzing and transforming functional specifications and change requests into technical specifications.
- Significant experience* with Business Intelligence (BI) and Data Analytics.
- Experience in providing 3rd party application support.
- Experience assisting in the development of project plans and assigning appropriate technical resources and cost estimation.

* Significant experience is defined as “Experience that is normally acquired over the course of at least five years actively performing the duties on a regular basis”, where “actively performing the duties on a regular basis” means that at least two days out of a five day work week would typically be spent performing the duty.

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

ASSET EDUCATION:
- Graduation with a degree from a recognized university with an acceptable specialization in computer science, computer engineering, information technology, or other related area.
- Microsoft BI Certification.
- IBM Cognos Certification.

Degree equivalency

ASSET EXPERIENCE:
- Experience creating logical and physical data models using best practices.
- Experience working in an Agile development environment.
- Experience developing business solutions with Microsoft Power BI.
- Experience developing business solutions with IBM Cognos Analytics.
- Experience developing business solutions with Microsoft Dynamics CRM.

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

English essential

Information on language requirements

KNOWLEDGE:
- Knowledge of relational database design principles and SQL scripting language.
- Working knowledge of Erwin Data Modeler version 9 (or above).

COMPETENCIES:
- Critical Thinking
- Innovation
- Results Orientation
- Service Orientation
- Change Leadership

ABILITIES:
- Ability to work under pressure.
- Ability to communicate effectively in writing.
- Ability to communicate effectively orally.

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

ASSET COMPETENCIES:
- Developing Others

ORGANIZATIONAL NEEDS:
- In order to meet the organization’s employment equity objectives in support of a diversified workforce, ‘right fit’ selection for this position may be made from among qualified candidates who self-declare as being Persons with a disability or Aboriginal peoples.

OPERATIONAL REQUIREMENTS:
- Ability and willingness to travel within Canada on occasion.
- Ability and willingness to work overtime when required.

Conditions of employment

Reliability Status 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

In order for your application to be considered, you must submit a completed questionnaire. You will be required to demonstrate how you meet the education and experience criteria (essential and asset) for the initial screening, in answering online screening questions. It is NOT sufficient to only state that the qualifications are met or to provide a listing of current or past responsibilities. Rather, you must clearly demonstrate HOW, WHEN and WHERE the qualification was met through substantiation by examples. Information on your described education and experience provided in the screening questions should be supported by your résumé. Please note that your ability to communicate effectively in writing will be assessed throughout the application. Therefore, we recommend you use complete sentences where appropriate. Failure to provide the above information in the format required may result in your application being rejected from the process.

A written examination will be administered.

An interview will be administered.

Reference checks may be sought.

Please note that OSFI has offices located in Ottawa, Toronto, Montreal, and Vancouver. If you are screened in, you may be required to travel to one of these locations to complete assessments (exam, interview, etc.).

Candidates invited to an interview will be required to bring proof of their education credentials, in the form of a diploma or official transcript (original documents only). 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/.

Candidates must meet all of the essential qualifications to be appointed to a position. A candidate may be appointed to a position even though he/she does not meet any or all of the asset qualifications. However, meeting these criteria is desirable and may be a deciding factor in choosing the person to be appointed.

Depending on the requirements of the position(s) being staffed from this process, for current or future vacancies, any or all of the asset qualifications, operational requirements, and organizational needs may be applied at the time of staffing. Candidates may be contacted and assessed against these criteria at any time during this process.

Achieving a representative workforce has been identified as an organizational need and may be applied in this appointment process. If this criterion is used, only those who have indicated that they are members of the specified designated group(s) will be considered.

A top down selection of candidates may be used in the determination of those to be given further consideration in the assessment process.

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.

For this selection process, our intention is to communicate with applicants by e-mail (including sending invitations for written tests and interviews). Applicants who apply to this selection process must include in their application a valid e-mail address and make sure this address is functional at all times and accepts messages from unknown users.

All job applications must be submitted through the Public Service Resourcing System (PSRS). Do not fax or mail hard copy documents as these will not be accepted. To submit an application online, please click on the button "apply now".

If you do not have Internet access in your home or through friends, relatives or neighbours, here are some suggested locations: campus career centers, libraries, community centers, Internet cafés and Services Canada. You may also call 1-800-O-Canada (1-800-622-6232), or TTY 1-800-926-9105, for information on the nearest public Internet access locations.

Persons with a disability preventing them from applying on-line are asked to contact 1-800-645-5605.

Applicants with disabilities: If you require special accommodation at any stage in the selection process, including technical aid to ensure an equitable assessment of your qualifications, please inform us by sending an e-mail to the following address: .

As a Separate Agency, the Office of the Superintendent of Financial Institutions (OSFI) appoints employees in accordance with the Public Service Employment Act (PSEA). OSFI is named in Schedule V of the Financial Administration Act (FAA) and it offers the same pension and benefits plans as the core Federal Public Service. In addition to this, OSFI employees obtain a minimum of 4 weeks of vacation leave per year, earn a competitive salary, and are eligible for an annual performance bonus.

Preference

Preference will be given to veterans and to Canadian citizens, in that order, 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.