Treasury Analyst

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

This range is provided by Tatum by Randstad. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$90,000.00/yr - $130,000.00/yr

Additional compensation types

Annual Bonus

We are seeking a highly motivated and technically proficient Treasury Analyst to play a critical role in managing the company's liquidity, risk exposure, and working capital. The ideal candidate will be an analytical self-starter with a strong foundation in finance and a proven ability to build and automate financial models. A cornerstone responsibility of this role will be building, maintaining, and automating a robust 13-week direct cash flow forecast from scratch using Excel macros (VBA). This position directly impacts strategic decision-making and global operations.

Key Responsibilities:

• 13-Week Cash Flow Model Development: Design and build a 13-week rolling direct cash flow model from the ground up. This includes establishing inputs, defining assumptions, and validating outputs across all operational and financial streams.
• Macro Automation: Utilize Excel Visual Basic for Applications (VBA) macros to automate data extraction, aggregation, reconciliation, and reporting processes within the cash flow model, significantly reducing manual effort and increasing accuracy.
• Variance Analysis: Conduct detailed daily and weekly variance analysis comparing actual cash flow to forecast, identifying key drivers of deviations, and reporting insights to senior management.
• This role will assist AP and AR is making payments to various vendors including M&A on boarding new companies.
• Long-Range Forecasting: Support the annual budget and longer-term strategic financial planning processes by providing accurate cash flow inputs and liquidity projections.
• Daily Liquidity Management: Manage daily cash position, optimize short-term borrowing/investment decisions, and ensure sufficient liquidity to meet operational needs.
• Bank Relations: Manage banking relationships, administer bank accounts, and oversee the implementation of banking products and services (e.g., electronic funds transfers, wires, ACH).
• Working Capital: Monitor and optimize working capital components, specifically supervising the daily reconciliation of Accounts Receivable (AR) and Accounts Payable (AP) processes to refine cash flow inputs.

Qualifications:

• Education: Bachelor’s degree in Finance, Accounting, Economics, or a related quantitative field.
• Experience: 5+ years of hands‑on experience in a corporate treasury.
• Technical Expertise (Mandatory): Advanced proficiency in Microsoft Excel, including the demonstrated ability to write, implement, and troubleshoot VBA macros for financial modeling and reporting automation.
• Cash Flow Modeling: Proven, hands‑on experience building complex direct cash flow models (preferably 13-week rolling forecasts) from a foundation/scratch level.

For immediate consideration please send your resume to: [e-mail]