Fund Reporting Analyst — Private Equity (Hybrid)

AEW; Boston (MA); Hybrid; USD 75,000 - 85,000; Full time

Benefits offered by this job

Health insurance

401K with match

Tuition relief

Parental leave

Flexible time off

Hybrid work

Job summary

AEW Capital Management seeks a reporting and analysis analyst to support Portfolio Management and Fund Operations, including quarterly investor reporting.

The role focuses on monthly/quarterly analyses and close collaboration with IT to improve reporting tools. Strong Excel and data-analysis skills are essential, with 1–2 years of modelling experience and a BS in Accounting or Finance.

Qualifications

• BS in Accounting or Finance required.
• 1–2 years of financial modelling experience preferred.
• Real estate industry experience a plus but not required.
• Solid quantitative financial analysis skills.
• Experience interacting with corporate data models via Excel or similar tools.
• Experience with advanced Excel functions (pivot tables, lookups, index match, array formulas).
• Strong attention to detail and communication skills.
• Ability to work in a team and meet deadlines.
• Ability to input on improving existing processes.

Responsibilities

• Prepare and analyze monthly and quarterly analyses for Portfolio Management and Fund Operations teams.
• Prepare quarterly and ad hoc reporting to investors.
• Collaborate with IT to enhance reporting and analytics tools.
• Assist with updating investor records in CRM.
• Work on ad hoc fund team projects.

Skills

Financial modelling

Data analysis

Advanced Excel

Attention to detail

Communication skills

Team collaboration

Deadline-driven

Process improvement input

Real estate experience

Education

Bachelor's degree in Accounting or Finance

Tools

MS Excel

Job description

AEW Capital Management seeks a reporting and analysis analyst to support Portfolio Management and Fund Operations, including quarterly investor reporting.

The role focuses on monthly/quarterly analyses and close collaboration with IT to improve reporting tools. Strong Excel and data-analysis skills are essential, with 1–2 years of modelling experience and a BS in Accounting or Finance.