Job Information
WASHINGTON TRUST BANK Securities and A/L Analyst in Spokane, Washington
Description In a multi-company environment, assists the Investment and Wholesale Funding Manager and Director of Finance in conducting the activities of the Funds Management Department. Key responsibilities include settling investment securities and wholesale funding transactions, preparing liquidity and asset/liability (A/L) reports, and administering the investment portfolio financial reporting system. Essential Functions: Investment Securities Assists the Investment and Wholesale Funding Manager in conducting securities transactions (purchases, sales, calls and maturities). Responsible for the accurate and timely processing of all transactions for the investment securities portfolio including accruals, posting of receipts and reconciliations. Posts securities transactions to the general ledger and to the Prologue system; balances the Prologue system and reconciles it to the general ledger. Performs market research and investment analysis using Bloomberg terminal. Prepares routine and ad hoc analyses of the investment portfolio for monthly and annual financial reporting, regulatory reporting, and supporting regulatory examinations. Administers the operation of the Prologue investment securities application system including routine reporting and report development, interfacing with the G/L system, and adapting the system to new investment instruments and transactions. Interfaces with the system vendor to resolve problems and obtain information. Oversees development of application support plan and execution of system backup and business continuity procedures for the system. Tests and implements system upgrades. Confirms securities trades with broker/dealers and coordinates settlement of transactions with safekeeping agents. Assists in researching and prepares analyses for the Bank's A/L Committee ("ALCO") regarding proposed and completed investment securities transactions and strategies. Monitors the securities portfolio to ensure compliance with the Bank's ALCO and investment policies and pledge requirements. Maintains complete and up-to-date files of securities transactions and credit information on securities issuers. Liquidity/Wholesale Funding Prepares reports and analyses for the ALCO including liquidity positions, advance pricing, market values and pledging availability. Updates monthly cash flow forecasts, for use in the A/L model and management reporting. Monitors collateral balances, facilitates pledging of assets to safekeepers, and completes regulatory reporting for maintaining borrowing lines. Posts funding transactions to the general ledger and to the Prologue system; balances the Prologue system and reconciles it to the general ledger. Asset/Liability Reporting Performs monthly stress test on the bond portfolio, using a variety of interest rate scenarios. Conducts market research and aggregates a variety of market data inputs to prepare monthly investment portfolio and market reports. Qualifications: Experience with securities transactions and securities accounting systems and controls preferred. Strong accounting aptitude required; college-level coursework in accounting or finance preferred. Demonstrated analytical / problem solving ability, strong detail orientation with high level of organizational skills. Experience with computer-assisted financial analysis and financial models especially spreadsheet applications (Microsoft Excel) Has sufficient knowledge of and experience with accounting computer systems to identify problems when they occur and correct problems not requiring program modifications. Sufficient knowledge of and experience with division computer systems to recognize opportunities to automate and/or streamline department activities. Uses the computer solutions as tools to enhance decision-making abilities and improve workflow efficiency. Frequent contacts by telepho