The role involves database management, developing front-end tools for automation, ensuring data governance compliance, and maintaining the Treasury's SQL database.
The Work:
The Analytics team within the Treasury group is responsible for the management of the department’s database along with providing analytical support, behavioural modeling and help to achieve operational efficiencies. This role is a multi-faceted one, as responsibilities include database management, development of front-end to the database, reporting automation and deployment of visualization tools.
The Work!
- 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 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 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.
Develop Front-end Tool (40%)
Ensure Compliance to Data Governance (30%)
Maintain and enhance Treasury’s existing SQL database (20%)
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
EQ Bank | Equitable Bank Toronto, Ontario, CAN Office
30 St Clair Avenue West, Suite 700, Toronto, Ontario, Canada, M4V 3A1
Similar Jobs
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
The Director will manage go-to-market strategies for Operational Intelligence products, collaborate with teams, enhance products, and drive market penetration.
Top Skills:
Payments Technology
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
The Director of Government Affairs and Policy leads the strategy for shaping policy and government relations in Canada, advocating legislation to support Mastercard's objectives while engaging with stakeholders.
eCommerce • Fashion • Other • Retail • Sales • Wearables • Design
The Cashier III delivers exceptional customer service at checkout, promotes add-on sales, maintains cash handling accuracy, and assists in training other cashiers.
Top Skills:
Basic Computer SkillsMobile TechnologyPos Systems
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
