Data Integrity Associate

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

About Aquarian

Aquarian Holdings ("Aquarian") is a diversified global holding company with a strategic portfolio of insurance and asset management solutions.

Aquarian Insurance Holdings acquires and operates insurance companies with a focus on life and annuity underwriting, deploying strategies to grow balance sheet profitability by writing new insurance/reinsurance, improving investment income, and optimizing operations. After launching in 2017, Aquarian finalized its first investment in 2018 in Investors Heritage, a regional life insurer domiciled in Kentucky that focuses on pre-need policies. Working closely with management, Aquarian helped the company grow with expanded product offerings and distribution channels, building on its 60-year track record of exceptional client service.

Aquarian continued to deepen its expertise and grow its existing offerings in insurance and reinsurance through its acquisitions of Hudson Life and Annuity Company in 2021 and Somerset Re in 2022.

Aquarian Investments complements the insurance operations , combining best practices from the world's leading financial services firms with its own distinct strategy, approach, and organizational culture. Aquarian has continued to expand into alternative assets and private credit through the launches of Aquarian Liquid Credit, Aquarian Strategic Opportunities, Aquarian Private Credit, and Aquarian Real Estate Partners.

Aquarian has since grown its business to approximately $25.8 billion in AUM, with 40 investment professionals, multiple funds, and insurance and reinsurance companies, all committed to providing meaningful investment opportunities to millions of people.

In November 2025, Aquarian announced the signing of a definitive merger agreement under which an affiliate will acquire Brighthouse Financial in an all-cash transaction valued at approximately $4.1 billion. Brighthouse is one of the largest providers of annuities and life insurance in the U.S., with approximately $208 billion of AUM. Following the anticipated close of the transaction in 2026, Brighthouse Financial will operate as a standalone entity within the Aquarian portfolio.

Role Summary

We are seeking a skilled and detail-oriented Middle Office / Data Integrity Associate to join our dynamic team. The ideal candidate will have a passion for data management, strong analytical skills, and the ability to turn complex datasets into actionable insights. As a Middle Office / Data Associate, you will play a key role in helping our organization make data-driven decisions by collecting/organizing, maintaining, and interpreting data across various functions. The Operations team at Aquarian collaborates with many different teams firmwide including Investments, Finance, Compliance, and Senior Leadership. This position offers an opportunity to work in a fast-paced environment and contribute to the overall success of our investment strategies.

Key Responsibilities

• Data Collection and Management:

  • Gather, organize, and maintain large datasets from multiple sources.
  • Ensure data integrity, quality, and consistency through regular validation and reconciliation/cleaning processes.
  • Perform daily and monthly reconciliation of cash and positions with custodians and internal systems, ensuring discrepancies are identified and resolved in a timely manner.
  • Update and maintain security and pricing data
  • Develop and manage data pipelines and ETL processes.
• Compliance Support: Assist in compliance monitoring by ensuring all operational processes align with regulatory requirements and internal policies.
• Process Improvement: Identify areas for operational efficiencies and implement process enhancements to streamline workflows and reduce risks.
• Collaboration: Build and maintain relationships with clients, counterparties, third party vendors, and internal stakeholders to facilitate effective communication and problem resolution.

Qualifications

• Education: Bachelor's degree.
• Experience: 2-4 years of experience in Investment Operations, Data Integrity, or related experience within asset management or broader financial services.
• Technical Skills:
• Proficiency in Microsoft Office suite
• Expert with spreadsheet tools, specifically Microsoft Excel.
• Knowledge of statistical and analytical methods.
• Analytical Skills: Strong analytical and problem-solving abilities, with attention to detail and accuracy.

Aquarian is an equal opportunity employer. Aquarian is committed to creating and maintaining a workplace in which all employees have an opportunity to participate and contribute to the success of the business and are valued for their skills, experience and unique perspectives. Aquarian does not discriminate on the basis of race, color, creed, religion, sex, national origin, veteran status, mental or physical handicap or disability, age, citizenship status, alienage, ancestry, marital status, sexual orientation, gender identity or expression or any other criteria prohibited under applicable federal, state or local law. Aquarian makes reasonable accommodations for applicants and employees with disabilities in accordance with applicable law.