Treasury Consulting Associate chez EQ Bank | Equitable Bank

The core parts of your role would be to:

• Create current position balance sheet with cash flows for credit union clients and support team members in external regulatory and management reporting
• Work extensively with credit union contacts to develop customized chart of accounts using sophisticated financial modelling software
• Coordinate directly with credit union contacts to collect balance sheet data for simulations; includes verification of loan, investment, deposit and other balance sheet data
• Ensure charts are properly built to capture credit unions unique balance sheet attributes
• Work extensively with spreadsheets and databases to import/export data and prepare the data for use in the simulation software
• Ensure data integrity and accuracy of client information for use in interest rate risk, liquidity and capital metrics
• Timelines and accuracy of results are critical to support accuracy in modeling interest rate risk and other key metrics
• Identify and implement process improvements to automate and streamline data including standardizing approaches for efficiencies in processes


Ensure simulation processes are efficient and accurate, resulting in high quality interest-rate risk reports
• Developing and enhancing databases and spreadsheet templates
• Documenting procedures for running simulations and building models in the balance sheet simulation software
• Applying independent problem-solving skills in identifying errors in reporting and resolving discrepancies
• Maintaining a system of checks and balances to ensure errors/issues are identified before data is passed on to senior level SFM team members
• Continually explore opportunities to enhance existing processes to increase operating efficiencies and shorten reporting timelines.


Ensure the business unit’s processes and data are maintained, up-to-date and accurate
• Building, enhancing, coordinating, and maintaining, /for reporting from other databases used by the business unit (eg. client billing, cost allocations, budget variances etc.)
• Build monthly SFM billing blotters to send to accounts receivable for billing of Treasury Consulting services
• Building and fostering strong long-term client relationships
• Assist senior SFM team members to assemble credit union financial reporting and compile regional trend data on a monthly basis

Let's Talk About You!

• Completion of a post-secondary program in a business related field
• Minimum 3 years’ experience in accounting, finance and financial modeling.
• Advanced technical skills with high proficiency in Excel, PowerBI, and Empyrean
• Strong knowledge of financial reporting and accounting principles
• Strong knowledge of data management systems
• Advanced knowledge of banking financial products
• Working knowledge of financial modeling
• Ability to work independently or collaboratively
• Strong time management skills
• Strong interpersonal skills and ability to work with finance, data and technology contacts.
• Strong attention to detail and organization skills
• Ability to handle multiple competing priorities to ensure that external client deadlines are managed effectively

Job Complexities / Thinking Challenges

• The incumbent is required to work extensively with credit union clients regarding financial chart of accounts using financial software.
• Ensure accuracy and integrity of client data
• Develop & enhance databases, document procedures and possess strong problem-solving skills.
• Possess a proactive approach for process improvement, data models and client interactions and maintaining relationships with key stakeholders. Requires high degree of professional relationship skills as this role works with external facing credit union clients.