Regulatory Information Officer (RE-04), Risk & Data Analytics

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

This position is located in Toronto, Ontario. As a result of the global pandemic, OSFI employees are currently working from home. Should the current telework environment no longer apply, the successful candidate will be required to report to and work onsite from the Toronto or Ottawa office.

Duties

The Regulatory Information Officer, Risk Data & Analytics will play an important role within the newly formed Risk Data & Analytics function at OSFI. This position will provide technical expertise and operational support to OSFI’s data management, BI reporting and advanced analytics functions. Leveraging a mix of data engineering and data analytics skills, and in collaboration with partners across the enterprise, the Analyst will:

- Create and maintain optimal data pipeline architecture
- Develop, implement and maintain ETL (data extract, transform and load) processes
- Identify, design and implement process improvements: automating manual processes, optimizing data delivery and re-designing processes and infrastructure for greater scalability
- Assemble large, complex datasets that meet business requirements
- Consult with staff in other units to determine the appropriate approaches for data platforms and participate in the design, implementation and maintenance of new reporting.
- Conduct ad-hoc analysis and deep dives on large volumes of data and provide impactful stories and insights.
- Gather and understand data requirements and develop complex solutions using structured analysis, data modelling and modern analytical platforms.
- Facilitate UAT and final solution delivery to stakeholders.
- Provide status updates, presentations, recommendations and respond to enquiries from division management.

This is an exciting opportunity to join a new, mission-critical function within OSFI. If you are a passionate data and analytics practitioner looking to make an impact through innovation and technology – please apply within!

Work environment

The Office of the Superintendent of Financial Institutions (OSFI) is an independent agency of the Government of Canada, established in 1987 to contribute to the safety and soundness of the Canadian financial system. OSFI supervises and regulates federally registered banks and insurers, trust and loan companies, as well as private pension plans subject to federal oversight.

What OSFI offers
OSFI is a separate agency that offers a competitive salary and eligibility for performance pay annually. People are the foundation of our organization. You will become part of a diverse community that acknowledges that everyone has varied experience and fosters an environment where communication and teamwork amplify our effectiveness.

Mandate
The work you do at OSFI matters. Your efforts contribute to the safety and soundness of the financial sector. A strong financial sector promotes competition, and benefits all Canadians.

Learning & Development
Our organization understands that ongoing learning and development is critical and necessary, and must evolve with developments in the Financial Sector. Learning and Development is a key component of our Human Capital Strategy.

Community & Culture
We strive to create a working environment that allows employees to work to their fullest potential. We strive to promote employee wellbeing, including a focus on balancing work and personal needs. Subject to operational requirements, we offer opportunities for flexible working arrangements.

Benefits
As a Federal Government Agency, OSFI offers a number of competitive benefits to its employees, including a Defined Benefit Pension Plan, maternity and parental leave benefits, vacation (4 weeks), personal and family leave days.

Intent of the process

This selection process may be used to establish a pool of qualified candidates, which could be used to staff similar or identical positions with various linguistic profiles and requirements, security profiles, geographic locations and various tenures within 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)

ESSENTIAL EDUCATION
- A degree from a post-secondary institution specializing in business, commerce, economics, statistics, mathematics, data analytics, computer science, engineering or another relevant field OR an acceptable combination of education, experience and/or training.

Degree equivalency

ESSENTIAL EXPERIENCE
- Recent* and significant** experience with databases and query authoring (SQL).
- Recent* and significant** experience with programming in object-oriented/object function scripting languages.
- Recent* and significant** experience working with modern BI and analytical tools.
- Recent* and significant** experience managing, assembling large complex volumes of data.

*Recent refers to relevant experience acquired in the past three (3) years.
**Significant is defined in terms of both depth and breadth of experience that is normally acquired by performing the tasks continuously over a minimum period of three (3) years.

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

ASSET EXPERIENCE
- Experience with relational SQL and NoSQL databases
- Experience developing automated workflows for data management and analytical purposes
- Experience working with modern data prep and data engineering tools such as: Alteryx, Trifacta, Datameer, Paxata or related tools
- Experience working with modern data quality tools such as Informatica, Talend, IBM or related tools
- Experience working with modern business intelligence tools such as: PowerBI, Tableau, Qlik, SAS BI, MicroStrategy, Domo, Looker or related tools
- Experience in conducting analysis using financial data
- Experience with Big Data workflows and Cloud technologies such as Azure, Google, Databricks or related tools.

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

English essential

Information on language requirements

ESSENTIAL KNOWLEDGE
- Knowledge of data engineering, preparation and transformation platforms
- Knowledge of current data management and data mining best practices and tools
- Knowledge of BI reporting platforms

ESSENTIAL COMPETENCIES
- Collaboration
- Innovation
- Building Business Relationships
- Critical Thinking
- Excellent Written Communication Skills
- Excellent Oral Communication Skills

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

ASSET KNOWLEDGE
- Knowledge of advanced analytical languages and platforms such as: SQL, R, Python, Scala, SAS, Google Cloud, Microsoft Azure or related tools and technologies.

ASSET COMPETENCIES
- Change Leadership
- 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 REQUIREMENT
- Willingness and ability to travel within Canada occasionally

Conditions of employment

Reliability Status security clearance

- In our current telework environment, the ability to work remotely from home within Canada with access to Internet in one’s residence is a condition of employment.

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é. Failure to provide the above information in the format required may result in your application being rejected from the process.

By providing the required information in the suggested format, you will ensure that the assessors are in a position to assess the depth, complexity and scope of your experience.

A written examination may be administered.

An interview may be administered.

Reference checks may be sought.

The ability to communicate effectively in writing may be assessed using the candidate's application, as well as through the evaluation process.

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 assessment (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 may be applied at any time during the staffing process, including screening. 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 Government of Canada public service jobs website. Do not email, fax, or mail hard copy documents as these will not be accepted. To submit an application online, please click on the "apply now" button.

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.