HiPortfolio Data Analyst - Investment Accounting

The Aquarium; Sydney; On-site; AUD 110,000 - 160,000; Full time

Job summary

The Aquarium is seeking an experienced Data Analyst with strong HiPortfolio (HiPort) expertise to join a leading global financial services organisation in Sydney. You will analyse, transform, load and reconcile investment data across external sources and the HiPortfolio platform.

You will work with investment operations, fund accounting, technology and project delivery teams to ensure data is migrated, validated and reconciled.

Qualifications

• Experience with HiPortfolio within investment accounting or fund administration.
• Strong knowledge of equities and fixed-income securities.
• Ability to map, transform and load third‑party investment data.
• Experience extracting data from HiPortfolio for analysis.
• Excellent data reconciliation and problem-solving skills.
• Experience supporting complex investment migrations.

Responsibilities

• Analyse investment data from third-party providers, custodians and external systems.
• Understand securities structures including equities, fixed income and other instruments.
• Configure, map and validate security master data and instrument setups within HiPortfolio.
• Interpret source data and transform formats for loading into HiPortfolio.
• Extract investment and accounting data from HiPortfolio for analysis, validation and reconciliation.
• Perform source-to-target reconciliations and identify discrepancies between external data and HiPortfolio.
• Investigate reconciliation differences arising from accounting methodologies or system configurations.
• Develop data mapping specifications, transformation rules and reconciliation processes.
• Work with stakeholders to resolve data quality issues and support migration outcomes.

Skills

HiPortfolio

Investment data

Data mapping

Data reconciliation

Data migration

Stakeholder comms

Job description

The Aquarium is seeking an experienced Data Analyst with strong HiPortfolio (HiPort) expertise to join a leading global financial services organisation in Sydney. You will analyse, transform, load and reconcile investment data across external sources and the HiPortfolio platform.

You will work with investment operations, fund accounting, technology and project delivery teams to ensure data is migrated, validated and reconciled.