Finance Analyst – SQL and Alteryx

Finance Analyst – SQL and Alteryx

ProViso Consulting

Summary of day to day responsibilities:

• The client Securities Capital and Liquidity Management Group is part of the Wholesale Banking Finance group and is accountable for all capital reporting/management and capital project initiatives, as well as providing subject matter expertise in liquidity, funding and balance sheet to client businesses to ensure the business is making decisions to optimize the financial resources of the Bank.
• The group is involved in leading consultations and industry discussions regarding current and upcoming OSFI Capital and Liquidity requirements. It is also responsible for allocation of capital for business line measurement and financial statement disclosures, ownership of Capital and Liquidity Management
• Frameworks including establishment of limits, ongoing monitoring and escalation, and leading optimization and cost savings initiatives.

Position Summary:

• The Senior Analyst in this role will be required to provide accurate and timely Wholesale Bank capital reporting in accordance with the OSFI capital guidelines; and present capital results and value-added information enabling senior business leaders to make informed and critical business decisions on capital.
• This includes interpretation of key capital drivers, variance analysis, and making appropriate recommendations where required.
• In addition, the Senior Analyst will address ad-hoc requests relating to capital and leverage requirements, independently gather business requirements, reengineer business processes where necessary, and maintain process documents.
• The analyst will provide meaningful reporting/analysis to influence business behavior, strategic decision making and optimal balance sheet usage.
• The analyst will be required to demonstrate governance, control and risk management behaviours in alignment with client policies and practices.

Job Accountabilities:

• Financial:
o Assist in the development and implementation of new financial models, capital treatment, methodologies, frameworks and paradigms to support on-going business unit reporting and analysis functions
o As the subject matter expert, provide guidance and recommendations to the Business on capital related matters
o Monthly reporting of capital results for derivatives positions in client Securities
o As the subject matter expert for derivatives capital reporting, support the implementation of Basel III Reforms Project
o Analyze the new CVA RWA framework and support its implementation for capital reporting purposes
• Business Operations:
o Prepare analysis of current processes, identify gaps and reengineer processes to improve business operations
o Demonstrate the ability to analyze and prepare presentations to management on the findings
o Contribute to the maintenance and improvement of various technological tools (e.g. Access databases) and process documents
• Customer:
o Partner with various business line and front-office contacts and develop and maintain solid and effective working relationships with various parties
o Compile reports and provide analysis to satisfy ad hoc requests from senior management, front office, and other users
o Work with current process owners to identify control gaps, processes and inefficiencies
o Effectively manage projects through concise and effective communication avenues
• Employee:
o Assist in leading the team by leveraging knowledge and sharing experience with the team
o Contribute to a positive work environment that encourages development, productivity, professionalism and teamwork
o Share knowledge and ensure ongoing and timely communication with the team and management on the status of projects and relevant points of interest
o Adhere to established guidelines of conduct

Qualifications / Skills / Experience:

• Committed to execute with excellence while delivering results within aggressive timelines
• Demonstrated history of being self-motivated, creative, energetic and results-driven
• Experience and comfort in process reengineering and documentation with minimal supervision
• Strong organizational skills with the ability to work in a fast-paced environment and manage multiple deadlines and priorities
• Strong business acumen with a “value-added” mindset – ability to consolidate information into clear and concise analysis
• Strong attention to detail
• Strong communication skills
• Highly motivated individual with willingness to take initiative
• Advanced knowledge of Microsoft Excel
• Knowledge of Microsoft Access & SQL
• Knowledge of Wholesale banking businesses and products

Specific Educational Requirements / Accreditations:

• Degree in Business Management or Finance
• Professional accounting / finance designation (CPA/CFA) or pursuing would be an asset

Must have:

• Very good understanding of wholesale banking products
• Exp in capital markets
• Familiar with products
• Exp in regulatory reporting
• Very good communication skills
• Exp implementing projects (preferably in wholesale banking)
• Strong in Excel and Access (experience with large data sets)
• Strong analytical skills
• Analyze data sets in excel and provide answers

Nice To Have:

• Experience in capital reporting
• Experience with SQL and Alteryx
• CFA, CPA or FRM designation preferred.

Job Details



12 months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend