Associate, Portfolio Analytics - Pipeline

BNY

Lake Mary (CA)

On-site

USD 75,000 - 110,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

BNY is seeking a candidate to support reporting services for complex real estate funds, consolidating financial and non-financial data. You will automate reporting processes across funds, extract data from source files into client templates, and coordinate data flow among analytics, accounting, and client services.

The role emphasizes strong Excel skills and the drive to automate current reporting, empowering ideas to shape the automation initiative with Real Estate stakeholder teams.

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 with working knowledge of advanced functionality.
  • Real estate fund experience preferred.

Responsibilities

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

Skills

Data analysis

Education

Bachelor’s degree in accounting, finance or related

Tools

Excel

Job description

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 therefor 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

Please be advised that this is a pipeline requisition. Applying to this position demonstrates interest in current and future openings within the real estate portfolio analytics team.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate, Portfolio Analytics - Pipeline
Associate, Portfolio Analytics - Pipeline

BNY • Florida

On-site
USD 52,000 - 72,000
Real Estate Portfolio Analytics: Automation & Reporting
Real Estate Portfolio Analytics: Automation & Reporting

BNY • Lake Mary (CA)

On-site
USD 75,000 - 110,000
Senior Associate, Fund Accounting & Finance
Senior Associate, Fund Accounting & Finance

Coda Search • New York (NY)

On-site
USD 90,000 - 170,000
Senior Accountant, CRE Portfolio Finance & Reporting
Senior Accountant, CRE Portfolio Finance & Reporting

Leeds Professional Resources • Florida

On-site
USD 85,000 - 110,000
Real Estate Performance Associate
Real Estate Performance Associate

TA Realty • Boston (MA)

On-site
USD 90,000 - 140,000
Portfolio Analytics Lead - Valuations, Reporting & Insights
Portfolio Analytics Lead - Valuations, Reporting & Insights

Atlantic Group • New York (NY)

On-site
USD 100,000 - 130,000
Associate, Portfolio Management, Student Housing (Based in Dallas)
Associate, Portfolio Management, Student Housing (Based in Dallas)

Mapletree • Dallas (TX)

On-site
USD 80,000 - 110,000
Manager Fund Accounting
Manager Fund Accounting

rialtocapital • Miami (FL)

On-site
USD 90,000 - 120,000
Real Estate, Asset Management, Analyst
Real Estate, Asset Management, Analyst

Coda Search • New York (NY)

On-site
USD 70,000 - 90,000
Analyst
Analyst

H5 Data Centers, LLC • United States

On-site
USD 65,000 - 90,000