Senior Analyst (Data Engineering Team)

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:
OSFI believes in offering employees flexibility and in creating a workplace that is productive, engaging, collaborative, and inclusive, all the while being supportive of employees’ wellbeing. As such, OSFI is experimenting with a hybrid work model (a combination of telework and onsite work) that will shape how we use our physical workplace to establish new norms, ways of collaborating, and working together and will adjust its model based on lessons learned.

Due to the nature of the work and operational requirements, this position requires physical presence at the designated work location, and as such, the successful candidate will be required to perform some in-office work at the Toronto business location. The option of teleworking is available on a part-time basis in accordance with OSFI’s Guidelines on Telework. Teleworking arrangements are determined on a case-by-case basis depending on the nature of the work, the operational and business needs, as well as the candidate’s work preferences.

EMPLOYMENT EQUITY:
OSFI is committed to achieving a representative workforce that reflects the diversity of the Canadian population. We are dedicated to building and promoting a diverse, equitable and inclusive workforce, representative of all Canadians regardless of race, ethnicity, colour, religion, sex, age, disability, sexual orientation, gender identity or expression, socio-economic background or lived experience. By embracing diversity and inclusion, our department ensures broader discussions, better decisions, and a more positive workplace.

We invite you to be part of the change by joining an organization where individual differences are recognized, valued and respected. We welcome all candidates to apply and strongly encourage candidates to self-declare if they belong to an Employment Equity designated group: Aboriginal* Peoples, Persons with Disabilities, Women or Visible Minorities (Black people and other racialized groups).

*The term “Aboriginal” is used within this job advertisement as it relates to the Employment Equity Act and other legislative frameworks. The term “Indigenous” is used where possible, in alignment with the United Nations Declaration on the Rights of Indigenous Peoples.

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 or more 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 (Data Engineering Team) 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 Engineering Team) 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.

Who You Are
You should possess the following attributes:
• You are keenly interested in contributing your expertise to promote a safer financial system.
• You have a passion for data and converting raw data into usable information for analytics and business decision-making.
• You have sound knowledge of data engineering practices and tools.
• You are enthusiastic about developing and applying analytical insights into the measurement and management of current and emerging risks.
• You work well with others.
• Your critical thinking skills help to inform your decision-making.

Work environment

Our Role:
OSFI is an independent federal government agency that regulates and supervises more than 400 federally regulated financial institutions and 1,200 pension plans to determine whether they are in sound financial condition. In fulfilling its mandate, OSFI supports the government's objective of contributing to public confidence in the Canadian financial system.
Learn more about us 👉 https://youtu.be/QO_3vnPKuZI

Our People and Culture:
People are the foundation of our organization. You will become part of a diverse community that acknowledges everyone has varied experience and fosters an environment where communication and teamwork amplify our effectiveness. We have several networks dedicated to ensuring that the department continues to grow as an inclusive, accessible, respectful and diverse workplace. All employees are encouraged and welcome to join the following networks and participate in their activities and events.
• Diversity of Thought
• Family Responsibilities
• Gender
• 2SLGBTQIA+
• Mental Health and Accessibility
• Multiculturalism (Affinity Groups: Indigenous, Asian, Black)
• Unconscious Bias
Hear about our people 👉 https://youtu.be/diUspmpYWQI

Our Rewards:
💵 Compensation: OSFI offers a competitive salary, and employees may be eligible for in-range increases and economic adjustments. Salaries are based on qualifications, experience and knowledge. The Public Service Pension Plan is a defined benefit pension plan (indexed for inflation), where both the employer and the employee contribute.

💰 Performance Pay: OSFI employees are eligible for an annual bonus based on their performance throughout the year.

✈️ Vacation and Leave: OSFI employees start with 4 weeks of paid vacation, 2 personal days and 5 days of Family Related Leave with Pay among other various types of paid and unpaid leave.

💻 Flexible Work Arrangements: OSFI offers flexible work arrangements by providing support for compressed work week schedules, flexible work hours and teleworking, in order for employees to achieve their work objectives while achieving balance between work and homelife.

📖 Learning and Development: OSFI offers career advancement opportunities and encourages innovative thinking in its work environment. Employees may be reimbursed for relevant professional association membership fees.

Intent of the process

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

Positions to be filled: Number to be determined

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 with specialization in a quantitative discipline such as computer science, engineering, mathematics, statistics or other relevant field OR an acceptable combination of relevant professional industry experience and education.

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

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

ASSET EDUCATION
• A relevant graduate degree from a post-secondary institution.
• A relevant professional designation.

Degree equivalency

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
• Collaboration
• Innovation
• Interpersonal Communication
• Critical Thinking
• Results Orientation

ESSENTIAL ABILITIES
• Ability to communicate effectively in writing.
• Ability to communicate effectively verbally.

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
• Transparency
• Growth and Developemnt
• Inclusion

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 or more 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.
Ability and willingness to travel internationally and/or domestically when required.

Conditions of employment

• Security – Reliability Status
• In our hybrid workplace environment, the ability to work remotely from home within Canada with access to the Internet in one’s residence is a condition of employment.
• Ability and willingness to travel within Canada when required.

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

For external processes (as indicated by the abbreviation “EA” in the selection process number), only those selected for further consideration will be contacted.

OSFI is a separate agency with its own classification and compensation system. OSFI's staffing is subject to the Public Service Employment Act (PSEA).

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

Assessments (such as written exams, interviews and reference checks) may be conducted virtually through email, telephone and/or videoconference.

Candidates must meet all of the essential qualifications to be appointed; however, one or more asset criteria may be invoked at any stage of the process.

Depending on the number of applicants, volume management strategies such as random selection, top-down approach and/or establishing cut-off scores to determine who will continue in the staffing process, may be used for the purpose of managing applications. Please note that although you may attain the established pass mark on any of the assessments used in this staffing process, management may decide to use a higher cut off score.

Eligible candidates may be considered and offered a deployment or interchange 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.

Email correspondence will be used as the main method of communication with candidates for this selection process, please ensure it accepts messages from unknown users. Please note that you need to provide valid and updated contact information.

All job applications must be submitted through the Government of Canada public service jobs website. Do not email or mail hard copy documents as these will not be accepted. To submit an application online, please click on the "apply now" button. Persons without Internet access may also review jobs open to the public through INFOTEL at 1-800-645-5605.

If you have a limitation that may impact your performance at any step of the assessment process (such as submitting the application, 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 inform us by sending an e-mail to the following address: . All information received in relation to accommodation will be kept confidential.

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.