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
