Financial Reporting Analyst - Reconciliations

Lenmar Consulting Inc; Boston (MA); Hybrid; USD 58,000 - 83,000; Full time

Job summary

Lenmar Consulting Inc. in Boston, MA is seeking a Financial Reporting Analyst to support daily reconciliations and data analysis within a Middle Office environment.

The role requires strong Excel skills, data-driven thinking, and the ability to translate complex inputs into clear outputs. Responsibilities include daily reconciliations, pulling data from custodians and vendors, maintaining Excel reconciliation files, investigating breaks, and assisting senior operations staff with reports and

Qualifications

• 1-3 years of experience in operations or middle office.
• Experience in asset management or financial services.
• Strong Excel skills (pivot tables, lookups, formulas).
• Strong data analysis and attention to detail.

Responsibilities

• Perform daily and ad-hoc reconciliations between internal systems and external data sources.
• Pull and validate data from custodians, vendors, and external websites.
• Update and maintain Excel-based reconciliation files.
• Identify, investigate, and document breaks and exceptions, escalating as appropriate.
• Support start-of-day and end-of-day operational control processes.
• Assist senior operations staff with reporting, data cleanup, and process support.
• Analyze high-volume operational data and translate inputs into outputs.
• Synthesize key findings into clear, well-organized summaries.

Skills

Excel proficiency

Data analysis

Attention to detail

Communication

Tools

DUCO

Bloomberg

Job description

Job Overview

Location: Boston, MA

Rate: $51/hr W2

Duration: 12-month contract

Schedule: Hybrid - 3 days in the office

Job Overview

We are looking for a Financial Reporting Analyst to support daily reconciliations and data analysis within a Middle Office environment. This role is ideal for someone with an operations background who is comfortable working with data, executing repeatable processes, investigating discrepancies, and supporting senior operations team members.

Key Responsibilities

• Perform daily and ad-hoc operational reconciliations between internal systems and external data sources.
• Pull and validate data from custodians, vendors, and external websites.
• Update and maintain Excel-based reconciliation and control files.
• Identify, investigate, and document breaks and exceptions, escalating as appropriate.
• Support start-of-day and end-of-day operational control processes.
• Assist senior operations staff with reporting, data cleanup, and process support.
• Analyze high-volume operational data and translate varied inputs into standardized outputs.
• Synthesize key findings and concepts into clear, well-organized summaries.

Requirements

• 1-3 years of experience in operations, middle office, reconciliations, or a similar support role.
• Experience or exposure to asset management, banking operations, or financial services.
• Strong Microsoft Excel skills, including pivot tables, lookups, and formulas.
• Strong data analysis skills with experience working across diverse datasets.
• Strong attention to detail and ability to identify and investigate discrepancies.
• Ability to organize and communicate findings clearly.

Nice to Have

• Experience with DUCO or other reconciliation platforms.
• Experience with Bloomberg.
• Knowledge of financial concepts such as:
  • Portfolio accounting and valuation
  • Security master
  • Corporate actions