Real Estate FP&A Analytics Manager

Prudential Annuities Distributors (PAD); Letterkenny; On-site; EUR 80,000 - 120,000; Full time

Job summary

PGIM Ireland is seeking a Planning & Analysis Associate Manager within the Finance team to deliver timely, accurate insights and support senior leadership. The role involves extracting and analyzing large datasets with SQL, transforming data into business intelligence for forecasting, investor and borrower marketing, and performance management.

Collaborate with senior leaders, IT/data teams, and Finance stakeholders to develop multi-year forecasts, produce management reports, and drive process

Qualifications

• Bachelor’s degree in Accounting, Finance, Data Analytics, or related field.
• 5-7 years of planning, forecasting, financial reporting, or analytics experience.
• Advanced Excel and financial modeling skills.

Responsibilities

• Develop and maintain complex SQL queries for reports, forecasting, and performance measurement.
• Translate large datasets into actionable insights for strategic decisions.
• Support financial modeling, scenario analysis, and data inputs for business cases.
• Enhance reporting to reduce manual effort and improve accessibility for partners.
• Provide analytics for investor and borrower marketing with portfolio metrics.
• Analyze mortgage servicing rights, loan economics, and production trends.

Skills

SQL querying

Financial modeling

Forecasting

Data analysis

Executive communication

Problem-solving

Cross-functional collaboration

Data visualization

Education

Undergraduate degree in Accounting, Finance, or Data Analytics

Tools

SQL

Excel

Power BI

Job description

PGIM Ireland is seeking a Planning & Analysis Associate Manager within the Finance team to deliver timely, accurate insights and support senior leadership. The role involves extracting and analyzing large datasets with SQL, transforming data into business intelligence for forecasting, investor and borrower marketing, and performance management.

Collaborate with senior leaders, IT/data teams, and Finance stakeholders to develop multi-year forecasts, produce management reports, and drive process