Treasury Data Analyst, Treasury Analytics and Modeling
Toronto
Equitable Bank
At Equitable Bank, we specialize in providing branchless financial services that meet the unique needs of all Canadians. Our range of mortgages, savings accounts and investment options are designed to offer the right solutions to match any...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 2022 and 2021 lists.
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
- Main Activities:
- Maintain and enhance Treasury’s existing SQL database (40%)
- 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 stored procedures and task automation ensuring functionality for Treasury team.
- Work with EDM team for creation of new processes or troubleshooting of any issues.
- Develop Automated Data Reporting Processes (20%)
- Deploy data visualization tools (i.e., Tableau, Power BI) for reporting automation.
- Conduct analysis, design, and implement stored procedures for the structure required for data visualisation tools.
- Develop Front-end Tool (20%)
- 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.).
- 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 (10%)
- Ensure all processes and associated controls are documented.
- Maintain a code library for regular/routine queries.
- Ensure compliance to change management guidelines.
- Follow appropriate approval process for providing database access privileges.
- 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
- Strong programming experience in SQL, Python and so on
- High level of Proficiency at SQL is required
- 1 to 3 years of experience in database management and/or data analytics
- Knowledge and experience of visualization tools, such as Tableau, Power BI and Google Data Studio 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
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!
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Banking Computer Science Data Analytics Data governance Data Studio Data visualization ETL Mathematics Power BI Python SQL SSIS Tableau
Perks/benefits: Career development Competitive pay Equity Health care Salary bonus Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Sr. Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Business Data Analyst jobs
- Open ETL Developer jobs
- Open Principal Data Scientist jobs
- Open Data Product Manager jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open GCP-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Java-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open PhD-related jobs
- Open NLP-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Airflow-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open Data warehouse-related jobs