Treasury Consulting Associate

Equitable Bank; Regina; On-site; CAD 125,000 - 150,000; Full time

Job summary

A leading financial institution in Canada is seeking an experienced financial analyst specialized in client interactions and financial modeling for credit unions. The ideal candidate will have a post-secondary education in business and at least 3 years of experience in finance. Responsibilities include developing balance sheets, ensuring data accuracy, and fostering client relationships. Benefits include competitive bonuses, comprehensive health plans, and a focus on professional development.

Benefits

Competitive discretionary bonus

Market leading RRSP match program

Medical, dental, vision, life, and disability benefits

Generous vacation policy and personal days

Professional development programs

Qualifications

• Minimum 3 years’ experience in accounting, finance, and financial modeling.
• Strong knowledge of financial reporting and accounting principles.
• Ability to work independently or collaboratively.

Responsibilities

• Create current position balance sheet with cash flows for credit union clients.
• Coordinate with credit union contacts for balance sheet data collection.
• Identify and implement process improvements for data accuracy.

Skills

Advanced technical skills in Excel

Financial modeling

Interpersonal skills

Attention to detail

Time management skills

Education

Completion of a post-secondary program in a business related field

Tools

PowerBI

Empyrean

Job description

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.

What we offer [For full-time permanent roles]

• Competitive discretionary bonus
• Market leading RRSP match program
• Medical, dental, vision, life, and disability benefits
• Employee Share Purchase Plan🏽
• Maternity/Parental top-up while you care for your little one
• Generous vacation policy and personal days
• Virtual events to connect with your fellow colleagues
• Professional development and comprehensive Career Development program
• A fulfilling opportunity to join one of the top FinTechs and help create a new kind of banking experience