Financial Reporting Analyst: Reconciliations & Data Insights

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

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