Job Title: Senior Treasury Risk Analyst (ALM)

Location: Plano, TX

Duration: 12 Months + Contract

Rate: $60 Hourly

HYBRID Opportunity (3 days a week Onsite)

Description:

Job Title: CW Senior Treasury Risk Analyst (ALM)

ALM: Asset Liability Management

Contract duration: 12 Months with a possibility of extension or potentially to convert full-time as well.

Location: Plano, TX

Please submit Local candidates

Hybrid: 3 days a week (No specific days.)

Overtime: As per business needs

Experience level: 3-5 years

let's look for people with

High financial modeling skills (forecasting, cash flow forecasting, etc)

Highly advanced Excel skills

Highly advanced SQL skills

Advance PowerPoint skills

Technical skills (Must Have):

SQL 3 years.

Excel 3+ years (Advanced) (Complex formulas)

VBA: Macros

Must Have's:

Medium treasury experience

Strong ALM experience

Strong Financial reporting

Strong financial experience (Financial modeling)

Strong Exposure to fixed income finance instruments

Strong in Managing financial instrumental data

Bachelor's degree is not mandatory

NOTE:

PLEASE DO NOT LOOK FOR SOMEONE WITH PROGRAMMING LANGUAGES MENTIONED IN THE JOB DESCRIPTION AS IT'S NOT REQUIRED

JOB DESCRIPTION

What are the key objectives for this resource (project summary):

The primary responsibility of this role is to provide critical thought-leadership using data and analytics on Interest Rate Risk (IRR), Liquidity Risk, Funds Transfer Pricing (FTP), Valuation, and Financial Forecasting utilizing measures such as Net Interest Income (NII), Earnings at Risk (EAR), Economic Value of Equity (EVE), and other Key Risk Indicators. The candidate will help maintain and automate financial analytical reports and dashboards with deep understanding of data and databases.

What you'll be doing What are the Roles and Responsibilities of this role:

Develop complex financial Asset Liability Management (ALM) models in Empyrean/ Excel/SQL to be used as the primary source for TMCC/client/Other AOR SFC Asset/Liability Management program.

Develop, maintain, and grow automated processes leveraging Excel, VBA, Tableau, Power BI, python, Snowflake, .Net, C# etc.

Advise finance subsidiaries on treasury management activities, practices and procedures ensuring compliance with policies and guidelines and review and provide input on funding forecasts and associated funding programs

Provide analytical support for management forums including Asset/Liability Committee (ALCO) decisions by conducting robust and comprehensive market and financial analysis to support strategy, proposals, and market transactions.

Conduct balance sheet analysis, analyze economic impact and build ALM strategies.

What specific clients departments will they interact with: Treasury, FP&A, Risk, Profitability

What we're looking for:

Analytical & Treasury experience

Strong proficiency with Excel modeling

Hands on experience with SQL

User of SmartView/Essbase

Added bonus if you have (Preferred):

Experience with ALM Tools Empyrean/Bancware/QRM