Job Description
Role Overview
As a Treasury Reporting Analyst, you will be the primary architect of our financial visibility. You won’t just be reporting on where the money is; you’ll be analyzing how it moves and predicting how it will behave under pressure. This role requires a blend of financial acumen and technical proficiency to automate reporting workflows and provide the Treasurer with a real-time pulse on company liquidity.
Key Responsibilities
- Daily Treasury Reporting: Own the production of accurate daily liquidity reports, ensuring 100% accuracy across all fiat accounts and wallets. You will be the first to identify, report and explain balance fluctuations.
- Dashboard Maintenance: Build and manage automated Treasury dashboards. You will ensure that data flowing from various APIs (Exchanges, Custodians, and banks) is clean, reconcilable, visualized, and actionable.
- Cash Flow & Stress Testing: Play a lead role in cash flow forecasting. You will design and run various “Black Swan” stress testing scenarios (e.g., 50% market drawdowns, sudden withdrawal spikes) to ensure the firm’s resilience.
- KPI & Early Warning Tracking: Monitor and maintain a suite of Key Performance Indicators (KPIs) and Early Warning Indicators (EWIs). You will alert leadership to breached thresholds regarding collateral ratios, exchange counterparty risk, and liquidity buffers.
- Ad-hoc Treasury Analytics: Conduct deep-dive analyses into customer behaviour. You will analyze how users move between fiat and digital assets to help the firm better predict liquidity needs and “stickiness” of assets.
Required Skills
Advanced Google Sheets expertise, including knowledge of Apps Script for automating data fetches and report distribution.
Proven experience with BI platforms ( Metabase, Big Query) to build self-service treasury tools. Understanding financial control and data validation.
Functional knowledge of SQL (for querying financial databases) and Python or JavaScript (for interacting with Web3 APIs and automating workflows).
Experience in behavioral modeling—understanding how macro trends impact micro-user movements.
A solid grasp of both TradFi treasury (ALM, liquidity coverage ratios) and staking, custody, etc.
Perks:
- Competitive salary package
- HMO on day 1
- Remote setup
