Data Integrity & Middle Office Analyst

Aquarian; New York (NY); On-site; USD 75,000 - 120,000; Full time

Job summary

Aquarian is seeking a skilled Middle Office / Data Integrity Associate in New York to join the Investments and Operations teams. The role focuses on collecting, organizing, and maintaining large datasets, ensuring data quality, and supporting reconciliations with custodians and internal systems.

The ideal candidate has 2-4 years in investment operations or data integrity and strong Excel/Office skills, with a solid analytical mindset to drive data-driven decisions across teams.

Qualifications

• Bachelor's degree required.
• 2-4 years of experience in Investment Operations, Data Integrity, or related fields.
• Proficiency with Microsoft Office suite.
• Advanced Excel skills.
• Knowledge of statistical and analytical methods.

Responsibilities

• Data Collection and Management: gather, organize, and maintain large datasets from multiple sources.
• Ensure data integrity, quality, and consistency through validation and reconciliation/cleaning processes.
• Perform daily and monthly reconciliation of cash and positions with custodians and internal systems.
• Update and maintain security and pricing data; develop ETL/data pipelines.

Skills

Microsoft Office

Excel

Statistics

Analytical skills

Education

Bachelor's degree

Tools

Data integrity tools

Job description

Aquarian is seeking a skilled Middle Office / Data Integrity Associate in New York to join the Investments and Operations teams. The role focuses on collecting, organizing, and maintaining large datasets, ensuring data quality, and supporting reconciliations with custodians and internal systems.

The ideal candidate has 2-4 years in investment operations or data integrity and strong Excel/Office skills, with a solid analytical mindset to drive data-driven decisions across teams.