Treasury Data and Governance Intern

The Work!

Develop Front-end Tool (40%)

• Support the manager in identify tools/platforms that will assist with process enhancement for areas within Treasury (e.g. front end to SQL database, cash/ liquidity management platform, IRR management tool, trading etc.) using AI and related tools
• Work with the treasury team to understand departmental needs (as it relates to automation).
• Provide technical support in evaluating and coordinating the initiatives with regards to front-end application tools.

Ensure Compliance to Data Governance (30%)

• Ensure all processes and associated controls are documented.
• Maintain a code library for regular/routine queries.
• Ensure compliance to change management guidelines.
• Develop business rules working with the business unit

Maintain and enhance Treasury’s existing SQL database (20%)

• Maintain and enhance existing Treasury’s databases.
• Ensure daily and monthly ETL processes run seamlessly.
• Complete database issue fixes on a timely basis.
• Develop new tables / processes for data related to new products or those that are not currently in the database.

Departmental Data Support (10%)

Liaise with internal (treasury) and external partners (within the Bank) in identifying data needs and ensure high level of service is maintained at all times

Let's Talk About You!

• University education (undergraduate), with a focus on math and/or computer science
• 3M to 6M+ programming experience in Python and SQL 
• High level of Proficiency at SQL and Python is required
• Minor experience in database management and/or data analytics
• Knowledge and experience of visualization tools, such as Tableau, Power BI will be an asset
• Knowledge and experience of Data Governance will be an asset
• Hands on experience of ETL tools (e.g. SSIS)
• Strong skills in problem solving, logical thinking, process building and analytics
• Demonstrated understanding of financial market instruments is an asset
• 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
• Strong believer in quality and excellence