Strategic Planning & Analytics Manager

Prudential Financial; Letterkenny; On-site; EUR 70,000 - 95,000; Full time

Job summary

PGIM Ireland is seeking a Planning & Analysis Associate Manager to partner with Finance leaders across Real Estate. You will extract and validate large datasets with SQL, build financial models, and translate data into strategic insights for forecasting and investor initiatives.

The role emphasizes collaboration with senior stakeholders, process improvement, and scalable reporting to support business growth in a dynamic environment.

Qualifications

• Undergraduate degree in Accounting, Finance, Data Analytics, or related field.
• 5-7 years of experience in planning and analysis, forecasting, or financial reporting.
• Advanced Excel skills with ability to build and explain financial models.
• Experience with large datasets: extraction, reconciliation, validation, and interpretation.
• Excellent written and verbal communication skills for senior stakeholders.
• Financial services or real estate finance experience preferred.

Responsibilities

• Develop and maintain complex SQL queries for recurring reporting and forecasting.
• Translate large datasets into actionable insights for strategic decisions.
• Support financial modeling, scenario analysis, and business case development with reliable data inputs.
• Improve reporting processes to reduce manual work and increase clarity for partners.
• Provide analytics for investor and borrower marketing metrics across portfolios.
• Support analysis related to mortgage servicing rights and portfolio economics.
• Collaborate with Finance and IT to translate activity and market assumptions into forecasts.
• Develop multi-year forecasts for PGIM Real Estate activity and performance drivers.
• Prepare management reporting packages with actuals, forecasts, and variance analysis.

Skills

Advanced Excel

Data analysis

Financial modeling

SQL querying

Problem solving

Stakeholder communication

Education

Undergraduate degree in Accounting, Finance, Data Analytics

Job description

PGIM Ireland is seeking a Planning & Analysis Associate Manager to partner with Finance leaders across Real Estate. You will extract and validate large datasets with SQL, build financial models, and translate data into strategic insights for forecasting and investor initiatives.

The role emphasizes collaboration with senior stakeholders, process improvement, and scalable reporting to support business growth in a dynamic environment.