Role Overview
- 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
Requirements
- 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
Tech Stack
- ETL
- Python
- SQL
- SSIS
- Tableau