PGIM Real Estate - Analyst/Associate, Data Analytics & Governance

Prudential Ins Co of America; Newark (NJ); Hybrid; USD 70,000 - 110,000; Full time

Job summary

PGIM, the global asset management arm of Prudential, seeks an Analyst/Associate in Data Analytics & Governance to join the Real Estate team. You will help deliver trusted data products and implement governance across the investment lifecycle, working with stakeholders, data stewards, and Technology partners.

This hybrid role is based in Newark, NJ or New York, NY, offering collaboration on data lineage, quality rules, and AI-use case testing within a modern AI-enabled data environment.

Qualifications

• Bachelor's degree in information systems, finance, economics, real estate, data/analytics or a related field.
• 1–3 years of experience in data analysis, business analysis, data governance, data quality or reporting.
• Proficiency in SQL and advanced Excel; hands-on with Power BI or Microsoft Fabric and semantic models.
• Familiarity with data governance concepts, data catalogs, business glossaries, data lineage and data quality.

Responsibilities

• Gather requirements with business stakeholders and define questions, users, definitions, calculations and acceptance criteria for new data products and reports.
• Trace data lineage for data products from source systems to outputs, documenting gaps and conflicting definitions.
• Build and maintain datasets and reports using SQL, Power BI/Fabric and Excel from multiple sources.
• Validate data by comparing against source/historical data and investigate variances and anomalies.
• Prepare test cases, support testing, and track issues to resolution for new data products.
• Convert recurring ad-hoc requests into reusable datasets and self-service reports.
• Prepare and normalize data sets for reporting and create data dictionaries and training materials.
• Support governance processes, including change management for definitions and datasets, data access requests and handling of sensitive data.

Skills

SQL

Advanced Excel

Power BI

Microsoft Fabric

Data governance concepts

Education

Bachelor's degree in information systems, finance, economics, real estate, data/analytics or a related field

Tools

Microsoft Purview

Job description

Job Classification: Technology - Data Analytics & Management

A GLOBAL FIRM WITH A DIVERSE & INCLUSIVE CULTURE

As the Global Asset Management business of Prudential, we're always looking for ways to improve financial services. We're passionate about making a meaningful impact - touching the lives of millions and solving financial challenges in an ever-changing world.

We also believe talent is key to achieving our vision and are intentional about building a culture on respect and collaboration. When you join PGIM, you'll unlock a motivating and impactful career - all while growing your skills and advancing your profession at one of the world's leading global asset managers!

If you're not afraid to think differently and challenge the status quo, come and be a part of a dedicated team that's investing in your future by shaping tomorrow today. At PGIM, You Can!

What you will do

PGIM is seeking an Analyst or Associate, Data Analytics & Governance to join our Global Business Enablement team within Real Estate. This role supports two closely connected priorities: delivering trusted data products and analytics that inform decisions across the real estate investment lifecycle, and putting into practice the data governance that keeps that information accurate, well-defined and reusable.

Working alongside other team members, business stakeholders, data stewards and Technology partners, the Analyst/Associate will document business requirements, trace data back to its sources, catalog and define data elements, and build, monitor and report on data quality rules. This is a hands-on role for an early-career professional who enjoys getting into the data, wants to understand how a global real estate investment business operates, and is excited to grow in a modern, AI-enabled data environment.

This is a hybrid role (on-site 3 times a week) based in Newark, NJ or New York, NY.

What you can expect

Data Analytics

• Participate in requirements gathering sessions with business stakeholders and document the questions, users, definitions, calculations and acceptance criteria for new data products and reports.
• Trace the full data lineage for each new data product, mapping every required data element back to its source system, owner and transformations, and documenting gaps, overlaps and conflicting definitions.
• Partner with Technology team members to build and maintain analytical datasets and reports using SQL, Power BI / Fabric and Excel, combining data from multiple internal and external sources.
• Work directly with source data to validate assumptions, reconcile results across funds, systems and reports, and investigate variances and anomalies.
• Support business testing and validation of new data products by preparing test cases, comparing outputs to source and historical data, and logging and tracking issues to resolution.
• Help convert recurring ad-hoc requests into reusable datasets and self-service reports, reducing manual effort and one-off spreadsheet builds.
• Prepare and normalize data sets for reporting.
• Prepare user guides, data dictionaries and training materials that explain what each data product contains and the questions it can answer.
• Support AI use cases across the team by documenting requirements, testing AI-generated outputs for accuracy and reasonableness.

Data Governance

• Catalog data elements in the firm's data catalog tool (e.g., Microsoft Purview), capturing business definitions, owners, source systems, classifications and lineage.
• Maintain the business glossary to keep terminology, calculations and definitions consistent across teams and regions.
• Partner with data stewards and subject-matter experts to establish data quality rules (e.g., completeness, validity, consistency, timeliness and accuracy) and encode them as automated, repeatable checks.
• Monitor data quality and produce regular data quality metrics, scorecards and trend reporting for stakeholders and governance forums.
• Perform root cause analysis of data quality issues, tracing them back to their source, and refer them to the appropriate data stewards for remediation; track issues through to resolution and confirm fixes are made at the source rather than in downstream reports.
• Support governance processes, including change management for definitions and datasets, data access requests and the appropriate handling of sensitive data.

What you will bring

• - Bachelor's degree in information systems, finance, economics, real estate, data/analytics or a related field.
• - 1-3 years of experience in data analysis, business analysis, data governance, data quality or reporting, ideally in commercial real estate, investment/asset management or financial services.
• - Working proficiency in SQL and advanced Excel; hands‑on experience with Power BI or a similar BI tool (Microsoft Fabric a plus) and with semantic models.
• - Familiarity with data governance concepts, including data catalogs, business glossaries, data lineage, data quality