Treasury Analyst: 13-Week Cash Flow & VBA Automation

Tatum by Randstad; King of Prussia (PA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Annual bonus

Job summary

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.

Qualifications

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

Responsibilities

• 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.

Skills

Advanced proficiency in Microsoft Excel

VBA macros proficiency

Cash flow modeling

Analytical skills

Education

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

Job description

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.