Treasury Analyst: 13-Week Cash Flow & VBA Automation

Tatum by Randstad; King of Prussia (PA); In loco; USD 90.000 - 130.000; Tempo pieno

Vantaggi offerti da questo lavoro

Annual bonus

Descrizione del lavoro

A financial services company is seeking a highly motivated Treasury Analyst to manage liquidity and risk exposure. Responsibilities include building a 13-week cash flow model, automating processes with Excel VBA, conducting variance analysis, and managing banking relations. The ideal candidate will possess a Bachelor's degree in Finance or related field and have 5+ years of treasury experience. This role offers competitive compensation in King of Prussia, Pennsylvania.

Competenze

• 5+ years of hands-on experience in a corporate treasury.
• Proven experience building complex direct cash flow models from scratch.

Mansioni

• Design and build a 13-week rolling direct cash flow model from the ground up.
• Utilize VBA to automate data extraction and reporting processes.
• Conduct daily and weekly variance analysis of cash flow.
• Support annual budgeting and long-term strategic financial planning.
• Manage daily cash position and optimize short-term borrowing decisions.
• Oversee bank relations and banking product implementations.
• Monitor and optimize working capital components.

Conoscenze

Advanced proficiency in Microsoft Excel

VBA macros proficiency

Cash flow modeling

Analytical skills

Formazione

Bachelor’s degree in Finance, Accounting, Economics, or a related field

Descrizione del lavoro

A financial services company is seeking a highly motivated Treasury Analyst to manage liquidity and risk exposure. Responsibilities include building a 13-week cash flow model, automating processes with Excel VBA, conducting variance analysis, and managing banking relations. The ideal candidate will possess a Bachelor's degree in Finance or related field and have 5+ years of treasury experience. This role offers competitive compensation in King of Prussia, Pennsylvania.