Data Analyst

Role Purpose

The Data Analyst will play a critical role in the delivery of Intraday Liquidity (IDL) Reporting Uplift programme, supporting compliance with APRA APS210 obligations and enhancing the intraday liquidity monitoring, forecasting, reporting and risk management capabilities.

The role will work across Treasury, Risk, Operations, Finance and Technology teams to analyse complex data sets, define business and data requirements, perform source-to-target mapping, assess data quality, support testing activities and ensure accurate regulatory and management reporting outcomes.

Key Responsibilities Data Analysis & Requirements

• Elicit, document and validate business, functional and data requirements.

• Analyse complex cash, liquidity, payments and settlement data across multiple source systems.

• Document data lineage, source-to-target mappings and transformation requirements.

• Facilitate workshops with Treasury, Risk, Operations and Technology stakeholders.

• Translate regulatory and business requirements into actionable data and reporting specifications.

Data Quality & Validation

• Perform data profiling and quality assessments.

• Identify data gaps, anomalies and reconciliation issues.

• Define data quality controls and remediation requirements.

• Support reconciliation of liquidity positions, balances, transactions and intraday metrics.

• Establish validation processes for key regulatory reporting outputs.

Regulatory Reporting Support

• Support development of APS210 Intraday Liquidity reporting requirements.

• Assist in defining calculations and reporting requirements for:

  • Largest Negative Net Cumulative Position (LNNCP)

  • Intraday liquidity utilisation

  • Payment inflows and outflows

  • Settlement obligations

  • Forecast versus actual liquidity positions

• Ensure reporting requirements are traceable to regulatory obligations and business needs.

Testing & Delivery Support

• Develop test scenarios and support SIT, UAT and parallel-run testing activities.

• Validate regulatory reporting calculations and dashboard outputs.

• Support defect triage and resolution activities.

• Assist with go-live readiness and post-implementation validation.

Stakeholder Engagement

• Work closely with:

  • Treasury

  • Markets Risk

  • Finance

  • Operations

  • Data Engineering teams

  • Reporting teams

  • Vendors and delivery partners

• Communicate analysis outcomes, issues and recommendations clearly to both technical and business audiences.

Key Deliverables

• Business Requirements Documents (BRDs)

• Functional and Data Specifications

• Data Dictionaries and Mapping Documents

• Reconciliation and Validation Reports

• Regulatory Reporting Requirements

• Test Scenarios and Traceability Matrices

• Reporting and Dashboard Requirements

• Defect and Issue Analysis Documentation

Essential Skills and Experience Data & Analytics

• Strong SQL and data analysis capability.

• Experience analysing large and complex financial datasets.

• Data profiling, reconciliation and data quality assessment experience.

• Strong understanding of data lineage and source-to-target mapping.

Banking & Treasury Domain Knowledge

• Experience within Treasury, Finance, Risk or Regulatory Reporting environments.

• Understanding of:

  • Liquidity management

  • Cash management

  • Payments and settlement processes

  • Regulatory reporting

• Knowledge of APRA, Basel or prudential reporting requirements advantageous.

Preferred Experience

• Intraday Liquidity Management (IDLM) or Liquidity Risk projects.

• Treasury/Markets/Payments platforms such as Murex, RITS, GPP, NPP, Austraclear.

• Data or ETL platforms such as Abinitio

• Regulatory reporting and financial data warehousing.