Employer: Merrick Bank Corporation
Location of Employment: 10705 South Jordan Gateway, Suite 200, South Jordan, UT 84095 Required to be in South Jordan Office at least 2 days per week. Must live in commuting distance of South Jordan, Utah.
Job Title: Sr. Treasury Analyst
Job Duties:
Perform historical and statistical analyses using Excel spreadsheets to develop and prepare informative forecasts and reporting for multiple areas of treasury management such as asset, liability, and capital management.
Responsible for understanding the inflows and outflows of the Bank's cash activity and use this knowledge to develop cash forecasts using Excel spreadsheets to support the Bank's liquidity planning.
Work with multiple areas of the Bank in identifying all sources of the Bank's cash flows.
Ensure new sources of cash flow are identified and tracked appropriately using Excel spreadsheets.
Responsible for the daily reconciliation of the Bank's cash position using Excel spreadsheets.
Identify unreconciled cash activity and work with multiple areas of the Bank to reconcile the activity.
Develop and prepare liquidity reporting using Excel spreadsheets to ensure the Bank is compliant with liquidity policies.
Develop and prepare liquidity sensitivity analyses using Excel spreadsheets to ensure the Bank maintains an adequate level of liquidity during multiple economic scenarios.
Develop funding strategies and calculate present value analyses utilizing the discounted cash flow methodology function in Excel.
Develop funding strategies for current needs and contingency purposes.
Develop assumptions for use in the modeling of interest rate risk through the interpretation of financials and historical datasets, analyses of micro and macro-economic trends and the development and/or preparation of multiple statistical models.
Interpret results of interest rate risk modeling performed by a third party in order to understand and report on the Bank's risk related to changes in net interest margin and present value of equity.
Develop and prepare investment analyses and senior management reporting using Excel spreadsheets.
Develop and prepare capital management analyses and or senior management reporting using Excel spreadsheets and the knowledge of interpreting financial statements.
Analyze and develop hedging strategies for asset and liability risk mitigation.
Analyze and develop automated processes for the purpose of process improvement.
Review department-related invoicing for accuracy of terms and expense.
Maintain bank account records and act as a liaison between the Bank and its correspondent banking partners.
Prepare department-related documentation in support of internal and external audits.
Work from home benefit available.
Degree Required: Master's in Business Administration, Finance, or closely related field.
Experience Required:
4 years as a Treasury Analyst, Treasury Manager, or closely related occupation.
Skill set Requirements (Special Requirements):
Must be highly proficient in the use of Excel spreadsheets.
Demonstrable knowledge of:
Asset and liability management
Capital management analyses
Calculating present value analysis using the discounted cash flow methodology
Developing funding strategies for current needs and contingency purposes
Interpreting financial statements
Analyzing micro and macro-economic trends
Using hedging strategies for asset and risk mitigation
Location: Required to be in South Jordan Office at least 2 days per week. Must live in commutingdistance of South Jordan, Utah.
Travel: No travel required.
#FinanceBanking