Purpose of Job
The Treasury Modelling team within the Treasury group is responsible for the management of the department’s programmed modelling solutions along with providing analytical support, behavioural modeling and help to achieve operational efficiencies. This role is a multi-faceted one, as responsibilities include supporting Treasury’s programming and quantitative analysis. The incumbent will be instrumental in automating complex departmental models.
The Work!
Build programmed solutions and processes based on requirements from the Treasury and Capital Markets team.
Automate existing spreadsheet-based analysis and to replicate results from other platforms.
Efforts will focus on funds transfer pricing models/ margin reporting, hedge accounting report, duration calculation, liquidity matching, stress testing, liquidity regulatory reporting etc.
The incumbent will ensure all processes are documented as per the Bank documentation standards.
The position supports and provides analytical support to Treasury team members (Liquidity, IRR, etc.) with (customer) behavioral analysis of various asset and liability products.
Review existing behavioural analysis and enhance analysis where beneficial (i.e. initial focus is most highly sensitive assumptions). Streamline analysis processes.
Develop new behavioural analysis as required. Requires the review of existing data and expanding where needed. Requires understanding of result sensitivity to assumptions and of drivers of customer behaviour.
Document all analysis methods and present analysis for approval by Senior Management (i.e. ALCO). Integrate assumptions into IRR/liquidity modeling.
Platform expected to be used are SQL and Python.
Support other Treasury, Finance and corporate requests. This includes the following:
Support Treasury function with additional development. Provide reports for ALCO and ERM meetings. This includes liquidity or interest rate analysis as required (product volume, yields, spreads, option costs).
Support accounting, capital markets and investor relation functions with required analysis and reporting.
Provide support as a subject matter expert on programing / coding.
Ensure all models, processes, and associated controls are documented.
Assist in Model Validation process for new and existing models.
Perform regular performance monitoring as per model requirements
Develop efficient processes for quantitative models (30%)
Develop complex behavioural models (30%)
Departmental Analytics Support (20%)
Ensure Compliance to Model Governance (20%)
Your Experience!
Undergraduate degree with a focus on math and/or computer science.
3 to 5 years of experience in financial model programming.
Strong programming experience and database management knowledge using SQL and Python are needed.
Strong skills in problem solving, logical thinking, process building and analytics.
Awareness of machine learning (including deep learning) and underlying models (LSTM, convolution, deep and shallow layers)
Keen interest in financial markets and financial engineering, strong desire and ability to learn new financial concepts.
Demonstrated understanding in fixed-income financial concepts (i.e. bonds, mortgages, derivatives and yield curves) is an asset.
Knowledge of Liquidity risk, Interest rate risk and hedge accounting will be helpful.
Ability to collaborate with various functional support groups.
Excellent interpersonal and communication skills both written and verbal.
Ability to pay attention to details.
Possess good business acumen.
Skills Required
- Undergraduate degree with a focus on math and/or computer science
- 3 to 5 years of experience in financial model programming
- Strong programming experience and database management knowledge using SQL and Python
- Awareness of machine learning and underlying models
- Demonstrated understanding in fixed-income financial concepts
What We Do
MakeBank on everyday banking: Earn high interest on every dollar Say no to fees No minimum balances Powered by Equitable Bank, a Schedule I Canadian Bank EQB Inc. (formerly Equitable Group Inc.) trades on the Toronto Stock Exchange (TSX: EQB and EQB.PR.C), directly serves over 607,000 Canadians through its wholly owned subsidiary Equitable Bank, Canada's Challenger Bank™, and serves over 200 Canadian credit unions that serve over 6 million of their members with products and services. Equitable Bank has grown to become Canada's 7th largest independent Schedule I bank with over a $119 billion in assets under management and assets under administration, and a clear mandate to drive real change in Canadian banking to enrich people's lives. At Equitable Bank, we are as invested in our employees as we are in our business. That’s why we are consistently recognized as one of Canada's Top Employers – a rating that comes from our 1,800 employees. Equitable Bank’s inclusive, welcoming, and pride-inducing workplace earned it the honour of being recognized as one of the top 50 organizations on the 2023 list of Canada’s Best Workplaces™. Founded over 50 years ago, Equitable Bank provides diversified personal and commercial banking, and through its EQ Bank platform (eqbank.ca), which has been named #1 Bank in Canada for three consecutive years on the Forbes World's Best Banks list for 2021, 2022, and 2023. Equitable Bank website: www.equitablebank.ca EQ Bank website: www.eqbank.ca Specialties Lending, Mortgages, Residential Lending, Commercial Lending, Reverse mortgages, Insurance lending, Equipment leasing , Credit Union, Trust, and Funds Management







