Senior Analyst (RE-05), 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

POSITION LOCATION:
This position is located in Ottawa; however, the successful candidate may work from one of the OSFI offices across Canada (Toronto, Montreal, Ottawa, or Vancouver).

As a result of the global pandemic, OSFI employees are currently working from home. Should the current telework environment no longer apply, and contingent on the operating model adopted by OSFI, you may be required to report into and work onsite from one of the following offices: Toronto, Montreal, Ottawa, or Vancouver. As our telework arrangements are evolving, we encourage you to apply.

VACCINATION REQUIREMENT:
On October 6, 2021, the Government of Canada announced details of its plans to require vaccination across the federal public service.
• https://www.canada.ca/en/treasury-board-secretariat/news/2021/10/backgrounder-covid-19-vaccine-requirement-for-the-federal-workforce.html

As per OSFI’s Policy on COVID-19 Vaccination, employees must attest to their vaccination status. The requirement for employees to be fully vaccinated applies whether they are teleworking, working remotely or working on-site. This is a condition of employment and it applies to indeterminate (permanent), determinate (term), casual, and student hiring. Should you reach the point in the selection process where it is necessary to verify terms and conditions of employment, then a human resources representative will contact you in order to complete an attestation.

EMPLOYMENT EQUITY:
Achieving a representative and diverse workforce has been identified as an organizational need for OSFI and may be applied at any time during 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. As such, first consideration for an appointment may be given to candidates who self-declare as belonging to one of the four designated employment equity groups (Persons with a disability, Aboriginal people, Members of a Visible Minority, or Women).

In order to self-declare, please ensure to check off the appropriate box within the online application under the Employment Equity section. We encourage you to consult theses links to learn more about employment equity and self-declaration:
• https://www.canada.ca/en/public-service-commission/jobs/services/gc-jobs/employment-equity.html
• https://www.canada.ca/en/public-service-commission/jobs/services/gc-jobs/applying-government-canada-jobs-how-to-apply.html#EE

Duties

The Senior Analyst, Risk Data & Analytics (RDA) will play an important role within the RDA Data Engineering 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 Senior Analyst/Data Engineer will:

- Elicit, analyze, interpret business and data requirements to develop and maintain complete business solutions including data models (entity relationship diagrams, dimensional data models), ETL processes, pipelines, business rules, data life cycle management, governance, lineage, metadata and reporting elements.
- Monitor and investigate data quality issues and engage with business SMEs to establish DQ checks and facilitate quality improvement.
- Work closely with stakeholders to ensure successful data asset design and development and facilitate UAT and final solution delivery.
- Apply automation and innovation on new and on-going data platforms for development projects aligned to business or organizational strategies.
- Identify, design and implement process improvements: automating manual processes, optimizing data delivery and re-designing processes and infrastructure for greater scalability.
- Conduct ad-hoc analysis and deep dives on large volumes of data and provide impactful stories and insights.
- Managing competing priorities simultaneously and driving projects to completion.
- Provide status updates, presentations, recommendations and respond to enquiries from division management.

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.

Working at OSFI offers the following:

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

The immediate need to is to staff 3 English essential positions on an indeterminate basis.

A pool of qualified or partially qualified candidates may be created to staff similar or identical positions with various linguistic profiles and requirements, security profiles and/or various tenures within the Office of the Superintendent of Financial Institutions, which may vary according to the position being staffed.

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)

ESSENTIAL EDUCATION
- A degree from a post-secondary institution specializing in a quantitative discipline such as computer science, engineering, mathematics, statistics or another specialty relevant to the position.

Degree equivalency

ESSENTIAL EXPERIENCE
- Recent* and significant** experience with databases and query authoring in SQL.
- Recent* and significant** experience in relational and dimensional data Modeling.
- Recent* and significant** experience with one or more of the following programming languages: Python, Scala, R or Spark.
- Recent* and significant** experience managing, assembling large complex volumes of data in a data lake/lake house/data warehouse environment.
- Recent* work experience with one or more of the following Cloud data platforms and tools: Azure Synapse, BigQuery, Redshift or Snowflake.

*Recent refers to relevant experience acquired in the past five (5) 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 working with cloud technologies such as Azure ML Studio, Azure DevOps and CI/CD concepts.
- Experience working with modern business intelligence tools such as: PowerBI, Tableau, Qlik or related tools.
- 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 developing automated workflows for data management and analytical purposes.
- Experience in conducting risk analysis using financial data.
- Experience working with multiple data science languages and platforms.
- Experience working in cloud-based and web-based software development using programming languages such as JavaScript, Java, PHP, Node.js, or JSON.

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 programming languages: Python, Scala or Spark.
- Knowledge of BI reporting platforms.
- Knowledge of Data Engineering and Data Warehousing with Cloud.

ESSENTIAL COMPETENCIES
- Professional Judgment
- Collaboration
- Innovation
- Building Business Relationships
- 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 data science and machine learning techniques.
- Knowledge of relevant global risk management and accounting principles and standards (e.g., Basel Committee, International Association of Insurance Supervisors, and International Accounting Standards Board) and their application to both large and small financial institutions.
- Knowledge of governance and risk management practices currently employed in financial institutions to measure and manage current and emerging risks.
- Knowledge of the performance indicators in the banking sectors.
- Knowledge of the performance indicators in the insurance sectors.
- Knowledge of actuarial and finance models used by the insurance industry and applicable regulatory requirements.
- Knowledge of mathematical concepts and analytics used to measure risk in credit or market risk models.
- Knowledge of advanced analytical languages and platforms such as: R, Java, SAS, Julia, MATLAB, RapidMiner, DataRobot or related tools and technologies.

ASSET COMPETENCIES
- Impact and Influence
- Developing Others
- Working as a Team

ORGANIZATIONAL NEEDS
OSFI is committed to having a skilled and diverse workforce representative of the Canadian population. In order to meet our employment equity objectives, selection for this position may be made from among qualified candidates who self-declare as belonging to one of the following Employment Equity groups: Persons with a disability, Aboriginal people, Members of a Visible Minority, or Women. OSFI is committed to diversity and inclusion and we strongly encourage candidates to self-declare if they belong to one of these designated employment equity groups.

OPERATIONAL REQUIREMENTS
- Ability and willingness to work overtime as required.
- Availability and willingness to travel on occasion, both domestically and/or internationally.

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.

All employees of the Office of the Superintendent of Financial Institutions (OSFI) are required to be fully vaccinated against COVID-19 unless accommodated based on a medical contraindication, religion, or another prohibited ground for discrimination as defined under the Canadian Human Rights Act.

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.

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.

Candidates invited to an interview will be required to provide 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.

Internal employees of OSFI at the same group and level may be considered and offered a deployment or assignment before considering other applicants.

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 without Internet access may also review jobs open to the public through INFOTEL at 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: .

If you have a limitation that may impact your performance at any steps of the assessment process (such as during a written test or an interview), you may request an accommodation. Assessment accommodations are designed to remove barriers, and to ensure that candidates with limitations can fully demonstrate their abilities. Should you wish to be accommodated, please direct your inquiry to the contact identified at the bottom of this poster. All information received in relation to accommodation will be kept confidential.

OSFI's Ottawa location is downtown with easy access to shopping, restaurants, gyms, financial institutions and more. The building is less than a five-minute walk from LRT and STO stops.

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 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.