Planning & Analytics Manager - Real Estate Finance & Data

PGIM Ireland; Ireland; On-site; EUR 70,000 - 95,000; Full time

Job summary

PGIM Ireland is seeking a Planning & Analysis Associate Manager within the Finance team. The role delivers timely financial and operational insights by extracting, analyzing, and validating large datasets through SQL and BI tools.

You will influence strategic decisions, investor and borrower marketing, forecasting, and performance management. The position requires a blend of technical data expertise, financial acumen, and strong business partnership skills to support senior leadership and

Qualifications

• Undergraduate degree in Accounting, Finance, Data Analytics, or related field.
• 5-7 years of planning and analysis, forecasting, financial reporting, business analytics, or a similar finance role.
• Advanced Excel skills with the ability to build and explain financial models.
• Experience working with large datasets, including data extraction, reconciliation, validation, and interpretation.

Responsibilities

• Develop and maintain complex SQL queries to support recurring reporting, ad hoc analyses, forecasting, and business performance measurement.
• Translate large and complex datasets into actionable insights that support strategic business decisions.
• Support financial modeling, scenario analysis, and business case development by providing accurate data inputs.
• Drive reporting and analytical improvements that enhance transparency and reduce manual effort.
• Provide analytical support for investor and borrower marketing initiatives with production, portfolio, market, and performance metrics.
• Support analysis related to mortgage servicing rights, loan and portfolio economics, trends, and other metrics.
• Partner with Finance stakeholders to translate operational activity and market assumptions into financial projections and executive commentary.
• Develop and enhance multi-year forecasts for PGIM Real Estate activity across revenue, expenses, production, and performance drivers.
• Prepare clear analysis and management reporting packages for senior management discussions including actuals, forecasts, and variance analysis.

Skills

Advanced SQL

Analytical thinking

Communication skills

Data visualization

Education

Bachelor's degree in Accounting/Finance/Data Analytics or related field

Tools

SQL

Excel

Business intelligence tools

Job description

PGIM Ireland is seeking a Planning & Analysis Associate Manager within the Finance team. The role delivers timely financial and operational insights by extracting, analyzing, and validating large datasets through SQL and BI tools.

You will influence strategic decisions, investor and borrower marketing, forecasting, and performance management. The position requires a blend of technical data expertise, financial acumen, and strong business partnership skills to support senior leadership and