Associate Manager, Planning & Analysis

Prudential Ins Co of America

Ireland

On-site

EUR 70,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

PGIM Ireland, within the Finance/Planning & Analysis team, seeks a Planning & Analysis Associate Manager to deliver timely financial insights and robust data support. The role focuses on forecasting, actuals analysis, and management reporting, translating data into actionable business intelligence for leadership and partners.

The ideal candidate will operate across Finance and business units, using advanced SQL and Excel to drive modeling, scenario analysis, and performance metrics that guide

Qualifications

  • Undergraduate degree in Accounting, Finance, Data Analytics, or a related field.
  • 5-7 years of experience in planning and analysis, forecasting, financial reporting, business analytics, or a comparable finance role.
  • Advanced Excel skills with demonstrated ability to build, maintain, 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 and reliable data inputs.
  • Drive reporting and analytical enhancements that improve transparency, reduce manual effort, and make financial information easier for business partners to use.
  • Provide analytical support for investor and borrower marketing initiatives by delivering production, portfolio, market, and performance metrics.
  • Support analysis related to mortgage servicing rights, loan and portfolio economics, production trends, unpaid principal balance, flows, and other business-specific metrics.
  • Partner with business and Finance stakeholders to translate operational activity, pipeline trends, and market/business assumptions into financial projections and executive-ready commentary.
  • Develop, maintain, and enhance multi-year forecasts for PGIM Real Estate business activity, including revenue, expenses, production, portfolio, and related financial performance drivers.
  • Prepare clear analysis and management reporting packages for senior management discussions, including actuals reporting, forecast updates, variance analysis, and business performance insights.

Skills

SQL querying
Advanced Excel
Data analysis
Financial modeling
Executive communication
Process documentation

Education

Bachelor's degree in Accounting/Finance/Data Analytics

Tools

SQL

Job description

What to Expect

PGIM has an opportunity within the Finance team for a Planning & Analysis Associate Manager. This role supports senior leadership and business partners across PGIM Real Estate by delivering timely, accurate, and actionable financial and operational insights. A key component of this position is the ability to independently extract, analyze, and validate large datasets through advanced SQL querying and analytical tools. The individual will transform complex data into meaningful business intelligence that supports strategic decision-making, investor and borrower marketing efforts, forecasting, financial modeling, and operational performance management. This role requires a unique blend of technical data expertise, financial acumen, and business partnership skills to help leaders make informed decisions and identify growth opportunities.

Team

Finance / Planning & Analysis

Primary Focus

Multi-year forecasting, actuals analysis, management reporting, and process improvement

Key Partners

PGIM Real Estate business leaders, senior leadership, Loan Services, IT / data teams, and Finance stakeholders

Core Capabilities

Financial modeling, data analysis, executive communication, process documentation, and reporting automation

What you will Do

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 and reliable data inputs.

Drive reporting and analytical enhancements that improve transparency, reduce manual effort, and make financial information easier for business partners to use.

Provide analytical support for investor and borrower marketing initiatives by delivering production, portfolio, market, and performance metrics.

Support analysis related to mortgage servicing rights, loan and portfolio economics, production trends, unpaid principal balance, flows, and other business-specific metrics.

Partner with business and Finance stakeholders to translate operational activity, pipeline trends, and market/business assumptions into financial projections and executive-ready commentary.

Develop, maintain, and enhance multi-year forecasts for PGIM Real Estate business activity, including revenue, expenses, production, portfolio, and related financial performance drivers.

Prepare clear analysis and management reporting packages for senior management discussions, including actuals reporting, forecast updates, variance analysis, and business performance insights.

What you will Bring

Undergraduate degree in Accounting, Finance, Data Analytics, or a related field.

5-7 years of experience in planning and analysis, forecasting, financial reporting, business analytics, or a comparable finance role.

Advanced Excel skills with demonstrated ability to build, maintain, and explain financial models.

Strong analytical and problem-solving skills, with the ability to connect detailed data to broader business implications.

Experience working with large datasets, including data extraction, reconciliation, validation, and interpretation.

Provide analytical support for investor and borrower marketing initiatives by delivering production, portfolio, market, and performance metrics.

Excellent written and verbal communication skills, including the ability to present financial analysis and key takeaways to senior stakeholders.

Detail-oriented, self-motivated, and proactive, with the ability to manage multiple priorities in a fast-paced environment.

Ability to work independently while also partnering effectively across Finance, business, operations, and technology teams.

Financial services experience preferred; real estate finance, mortgage loan, servicing, agency lending, or portfolio reporting experience strongly preferred.

What Success Looks Like

Be recognized as a trusted data and analytics partner to business leaders.

Bridge the gap between raw data and business strategy by helping leaders understand the story behind the numbers.

Produce accurate, well-supported forecasts and reporting deliverables that senior leaders can rely on for decision-making.

Improve efficiency, scalability, and documentation of recurring Finance processes.

Build trusted relationships with business partners by bringing a balanced mix of financial discipline, analytical curiosity, and practical business judgement.

- PGIM Ireland is proud to be an equal opportunity employer and is committed to equal employment opportunity regardless of applicants' gender, civil status, family status, sexual orientation, religion, age, disability, race or membership of the traveler community. PGIM Ireland's aim is to hire the best people for the open roles and all appointments will be made on merit.

Any offer of employment made by PGIM Ireland will be contingent on rec

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate Manager, Planning & Analysis
Associate Manager, Planning & Analysis

Prudential Financial, Inc. • Ballyboe Glencar

On-site
EUR 85,000 - 120,000
Associate Manager, Planning & Analysis
Associate Manager, Planning & Analysis

PGIM Ireland • Ireland

On-site
EUR 70,000 - 95,000
Senior Financial Planning & Analysis Specialist (FP&A)
Senior Financial Planning & Analysis Specialist (FP&A)

PGIM • Letterkenny

On-site
EUR 80,000 - 120,000
Planning & Analytics Manager - Real Estate Finance & Data
Planning & Analytics Manager - Real Estate Finance & Data

PGIM Ireland • Ireland

On-site
EUR 70,000 - 95,000
Senior FP&A & Analytics Lead, Real Estate Finance
Senior FP&A & Analytics Lead, Real Estate Finance

PGIM • Letterkenny

On-site
EUR 80,000 - 120,000
Forecasting & Analytics Manager - Real Estate Finance
Forecasting & Analytics Manager - Real Estate Finance

Prudential Financial, Inc. • Ballyboe Glencar

On-site
EUR 85,000 - 120,000
Strategic Planning & Analysis Associate Manager
Strategic Planning & Analysis Associate Manager

Prudential Ins Co of America • Ireland

On-site
EUR 70,000 - 110,000
Financial Accounting Specialist - PGIM
Financial Accounting Specialist - PGIM

Prudential Ins Co of America • Letterkenny

Hybrid
EUR 65,000 - 90,000
Health Insurance
Annual Leave 23 days
Pension scheme
+3
Accounting Specialist | PGIM Ireland
Accounting Specialist | PGIM Ireland

Prudential Financial • Letterkenny

Hybrid
EUR 45,000 - 65,000
Health Insurance
23 days annual leave
Pension scheme
+3
Financial Accounting Specialist | PGIM
Financial Accounting Specialist | PGIM

PGIM • Letterkenny

Hybrid
EUR 65,000 - 80,000
Health Insurance
Annual Leave 23 days
Pension Scheme
+3
Top locations