Associate, Portfolio Analytics - Pipeline

BNY; Florida; On-site; USD 52,000 - 72,000; Full time

Job summary

BNY in Florida is seeking a reporting analyst to support complex real estate fund reporting. You will extract and analyze performance data, automate standard reports, and coordinate data flows between analytics, accounting, and client services.

The role requires strong Excel skills, 1–3 years of experience, and a degree in accounting or finance. You will design efficient solutions, document requirements, and provide end-user training as the automation project advances.

Qualifications

• Bachelor's degree in accounting, finance or equivalent experience.
• 1–3 years of total work experience preferred.
• Strong Excel skills with advanced functionality.
• Real estate fund experience preferred.

Responsibilities

• Coordinate project tasks and maintain timelines and updates.
• Document requirements for reporting and processing changes.
• Design and implement efficient reporting solutions based on requirements.
• Identify opportunities for process efficiency improvements.
• Lead user testing and provide end-user training.
• Plan and execute data migration tasks.
• Reconcile migrated data and reports.
• Provide functional user support during implementation.
• Act as a system super user and establish best practices.

Skills

Advanced Excel

Data coordination

Reporting automation

Project management

Education

Bachelor's degree in accounting/finance

Job description

The candidate conducts reporting services on behalf of assigned clients on complex real estate funds including aggregation of both financial and non-financial data. Responsibilities include extracting and analyzing performance attribution on both levered and unlevered basis, fund diversification including but not limited to regional, sector and risk profile levels and tenant related reporting. Effective at extracting specific data elements from various source files into specific client based templates and databases in an efficient and streamlined manner. Responsible for the coordination of data between portfolio analytics, accounting, client services and the client.

In addition, the candidate needs to possess strong technical skills. Current reporting is performed using excel and our initiative is to automate all the reporting across all funds. The candidate is responsible for executing project work streams as agreed with the stakeholders and team management. You will work closely with the Real Estate stakeholder teams to successfully automate business processes and calculation models using modern technology and languages. We are in the infancy stage of this initiative therefore this candidate will be empowered to bring ideas that will help shape the automation.

Responsibilities Include:

• Coordinate project tasks and streams, developing and maintain project timelines and management updates
• Document business requirements for reporting and processing changes
• Design, build and implement the most efficient solution based on the business requirements gathered
• Identify opportunities for process efficiency improvements
• Drive and coordinate user testing activities and providing training to end users
• Plan and execute data migration tasks
• Reconcile and validate migrated data and reports
• Provide functional user support on a day-to-day basis during implementation
• Act as a system "super user" helping others to leverage systems more effectively and establishing best practices across processes

Qualifications:

• Bachelor's degree in accounting, finance or the equivalent combination of education and experience is required.
• 1-3 years of total work experience strongly preferred
• Strong Excel skills required with working knowledge of advanced excel functionality
• Real estate fund experience preferred