Treasury Analyst

Pyramid, Inc

Plano, TX

JOB DETAILS
JOB TYPE
Full-time
SKILLS
Accounting, Analysis Skills, Asset Management, Balance Sheet, Banking Services, Budgeting, Business Administration, Capital Markets, Chartered Financial Analyst (CFA), Communication Skills, Cross-Functional, Data Analysis, Database Programming Languages, Documentation, Economics, FTP (File Transfer Protocol), Finance, Financial Liability, Financial Modeling, Financial Planning and Analysis (FP&A), Financial Risk Management, Fixed Income Investments, Forecasting, Funding, Funds Transfer Pricing, General Ledger Accounting, Interest Rates, Liquidity, Management Reporting, Mathematics, Microsoft SQL Server, Microsoft Visual Basic for Applications (VBA), Oracle Database, Pricing, Problem Solving Skills, Profit & Loss Analysis, Programming Languages, Reconciliation, Risk Management, SQL (Structured Query Language), Sales Operations, Spreadsheets, Team Player, Treasury
LOCATION
Plano, TX
POSTED
4 days ago
Immediate need for a talented Treasury Analys with experience in the Banking and Financial Industry. This is a 6+ Months contract opportunity with long-term potential and is located in Plano, TX. Please review the job description below. Job ID: 18-14493 Key Responsibilities: Asset Liability Management (“ALM”): Provide balance sheet and net interest income outlook for various interest rate scenarios. Liquidity Risk Management: Examine adequacy of liquid assets to meet funding needs under different scenarios. Funds Transfer Pricing (“FTP”): Analyze product-level market cost of funds to assist in pricing, planning and profitability analyses. Position Responsibilities: Load data to SQL server and reconcile to general ledger using SmartView. Maintain and execute financial models in ALM system and Excel. Analyze and confirm reasonability of output/results. Collaborate with FP&A team to execute and enhance annual budgeting and rolling forecasting process. Maintain complex spreadsheets and reporting packages, modifying associated SQL and VBA code as needed. Provide support for senior management forums including Asset/Liability Committee (“ALCO”) decisions. · Contribute to management reporting for financial decision-making. Develop solid understanding of ALM, liquidity and funds transfer pricing concepts. Grow financial and fixed-income capital markets knowledge by collaborating with front office. Maintain comprehensive documentation of all recurring processes. Working in upgrades and enhancements Monthly process: running VBA an SQL code and must be able to modify that (programming experience a plus) Use Bancware system to run monthly reports to show changes in interest rates, then working to reconcile these changes Key Requirements and Technology Experience: Four-Year College Degree (BA or BS) in Economics, Finance, Mathematics or equivalent field Knowledge and expertise with Treasury ALM systems (Bancware, QRM or equivalent) Banking industry experience needed! Data and analytical skills using database platforms such as SQL or Oracle (specific knowledge of query language) VBA programming experience (or other programming language) Strong communication skills Operates with a sense of urgency Strong strategic and problem-solving skills – extract key messages from range of data Collaborative and able to interact with various cross-functional groups within the Client Bank (Sales, Operations, Accounting, IT, Executive team, etc.) People-person/personable Flexible and adaptable Preferred Advanced Degree (MBA or Master’s Degree in Economics, Finance, Mathematics or equivalent field) CFA or FRM (financial risk management) · Programming experience a plus Our client is a leading Banking and Financial Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

About the Company

P

Pyramid, Inc