Treasury Reporting Analyst

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