Operations Analyst - Middle Office

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

We seek a professional to conduct daily reconciliations and data analysis within a Middle Office setting. This position is ideal for individuals with an operations background who excel at repetitive tasks, data handling, and supporting senior colleagues.

Job Overview

We seek a professional to conduct daily reconciliations and data analysis within a Middle Office setting. This position is ideal for individuals with an operations background who excel at repetitive tasks, data handling, and supporting senior colleagues.

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.

Requirements

• 1-3 years in operations, middle office, reconciliations, or similar roles.
• Experience in asset management, banking operations, or financial services.
• Proficient in Microsoft Excel, including pivot tables, lookups, and formulas.
• Strong skills in data analysis, handling large datasets, and standardizing diverse inputs.
• Ability to distill complex information into clear, concise summaries.

Preferred Qualifications

• Familiarity with DUCO or similar reconciliation tools.
• Experience using Bloomberg.
• Understanding of financial concepts such as portfolio accounting, security master, and corporate actions.