Treasury Analytics Intern, Summer 2024

Join a Challenger
Being a traditional bank just isn't our thing. We are big believers in innovating the banking experience because we believe Canadians deserve better options, and we challenge ourselves and our teams to creatively transform what's possible in banking. Our team is made up of inquisitive and agile minds that find smarter ways of doing things. If you're not afraid of taking on big challenges and redefining the future, you belong with us. You'll get to work with people who will encourage you to reach new heights. We like to keep things fun, ask questions and learn together.
We are a big (and growing!) family. Overall we serve more than 370,000 people across Canada through Equitable Bank, Canada's Challenger Bank™, and have been around for more than 50 years. Equitable Bank's wholly-owned subsidiary, Concentra Bank, supports credit unions across Canada that serve more than 5 million members. Together we have over $100 billion in combined assets under management and administration, with a clear mandate to drive change in Canadian banking to enrich people's lives. Our EQ Bank platform (eqbank.ca) has been named the top Schedule I Bank in Canada on the Forbes World's Best Banks 2023, 2022, and 2021 lists.
Work Term: May 2024 to August 2024
Purpose of the Job
We are looking for an intern to assist in data analysis in Treasury Analytics team. There are two directions the incumbent can choose. The first is a model development role, in which the incumbent is primarily responsible for assisting in developing and backtesting various cashflow projection models. The second is report development role, in which the incumbent is primarily responsible for assisting in developing various PowerBI reports. The incumbent can choose either direction but not both.
Main Activities:

• 70% model development (For model development role)

Treasury Analytics team manages Treasury's data warehouse and provides data services to all Treasury & Capital Market (TCM) teams. Among these services are numerous analytics models automated on our server. The incumbent is to assist in updating and redeveloping the models, and in conducting regular back-testing of the models. The incumbent is also required to draft or update the model documentations and to draft the model backtesting reports.

• 70% PowerBI report development (For the report development role)

Treasury Analytics team manages Treasury's data warehouse and provides numerous regular reports to various stakeholders. The team is in a process of upgrading the current SQL automated reporting system to a PowerBI based reporting system. The incumbent is to assist in the upgrading process. The incumbent is expected to develop data models for PowerBI reports and to develop assigned PowerBI reports.

• 20% Other Analysis

Assist with daily Treasury Analytics operations, such as updating rate database, supporting with portfolio trades, process documentation and daily valuations reports.

• 10% Learning of EQB Treasury function
• The incumbent will be an integrated member of TCM at EQB and will learn how a typical bank Treasury department works and more, such as banking, financial market, and financial products, from primarily a data-analytics lens.

Knowledge/Skill Requirements:

• Pursuing a master's degreein science, mathematics and/or engineering
• An open mind
• Strong willingness, and eagerness to learn
• Strong programming experience in SQL, Python and so on
• High level of Proficiency at SQL is a plus
• Experience with PowerBI or Tableau
• Good data analytics skills and strong data sense
• Good knowledge of statistics and machine learning techniques would be a plus
• Knowledge of financial markets and financial products would be a plus

How to Correctly Submit Your Application

• All applications must be submitted through our company website: https://jobs.lever.co/eqbank . Search for: Treasury Analytics Intern, Summer 2024
• Please note that you must be an active student going back to school. Applications from students who have already graduated will not be accepted unless you need to do a co-op placement in order to graduate.
• Please scan together and submit ONE DOCUMENT that includes your transcripts, resume and cover letter. Please note that if the application is not completed properly, it will not be accepted.

What we offer [For full-time permanent roles]
Competitive discretionary bonus
Market leading RRSP match program
Medical, dental, vision, life, and disability benefits
Employee Share Purchase Plan
Maternity/Parental top-up while you care for your little one
Generous vacation policy, personal days and even a moving day
Virtual events to connect with your fellow colleagues
Annual professional development allowance and a comprehensive Career Development program
A fulfilling opportunity to join one of the top FinTechs and help create a new kind of banking experience
The incumbent will be working hybrid and in office time will be spent working from Equitable Bank's additional office space located at 351 King Street East, Toronto, ON.
Equitable Bank is deeply committed to inclusion. Our organization is stronger and our employees thrive when we honour and celebrate everyone's diverse experiences and perspectives. In tandem with that commitment, we support and encourage our staff to grow not just in their career path, but personally as well.
We commit to providing a barrier-free recruitment process and work environment for all applicants. Please let us know of any accommodations needed so that you can bring your best self to the application process and beyond. All candidates considered for hire must successfully pass a criminal background check and credit check to qualify for hire. While we appreciate your interest in applying, an Equitable recruiter will only contact leading candidates whose skills and qualifications closely match the requirements of the position.
We can't wait to get to know you!