Middle Office Reconciliation & Data Analyst

Phaxis; Boston (MA); On-site; USD 65,000 - 90,000; Full time

Job summary

Phaxis seeks a professional to perform daily reconciliations and data analysis within a Middle Office setting. The role emphasizes working with an operations background, handling repetitive tasks, managing data, and supporting senior colleagues.

The position focuses on reconciling internal systems with external data sources, maintaining Excel files, and aiding reporting and process improvements. Candidates should be adept at distilling complex data into concise summaries.

Qualifications

• 1–3 years in operations or reconciliations in financial services.
• Experience in asset management, banking operations, or financial services.
• Proficient in Excel including pivot tables, lookups, and formulas.
• Ability to summarize complex data into clear summaries.

Responsibilities

• Conduct routine and special reconciliations between internal systems and external data.
• Extract and verify data from custodians, vendors, and online sources.
• Maintain and update reconciliation and control files in Excel.
• Identify, analyze, and document discrepancies, escalating when necessary.
• Support operational control processes at the start and end of the day.
• Assist senior staff with reporting, data management, and process improvement.

Skills

Data analysis

Excel

Pivot tables

Lookups

Formulas

Data handling

Clear summaries

Tools

DUCO

Bloomberg

Job description

Phaxis seeks a professional to perform daily reconciliations and data analysis within a Middle Office setting. The role emphasizes working with an operations background, handling repetitive tasks, managing data, and supporting senior colleagues.

The position focuses on reconciling internal systems with external data sources, maintaining Excel files, and aiding reporting and process improvements. Candidates should be adept at distilling complex data into concise summaries.