Analyst/Associate, Data Analytics & Governance

PGIM

. Participate in requirements gathering and document questions, users, definitions, calculations and acceptance criteria for data products and reports .

Posted 10/27/2026full-timeUnited StatesJuniorMid-Level💰 $90,000 - $130,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, data governance, and reporting, with proficiency in SQL and advanced Excel. Capable of building analytical datasets, validating data quality, and documenting requirements for AI use cases and data products.

Highest-signal resume keywords

SQL ProficiencyAdvanced Excel SkillsPower BI / Fabric ExperienceData Governance KnowledgeData Quality Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisBusiness AnalysisData Quality RulesData LineageData CatalogingSemantic ModelsRoot Cause AnalysisTest Case PreparationData NormalizationMetrics Reporting

Soft Skills

Attention to DetailEffective CommunicationCollaborative ApproachCuriosityOrganizational Skills

Tools & Technologies

Power BIMicrosoft FabricMicrosoft PurviewAtaccamaData Catalog Tool

Industry Keywords

Data GovernanceCommercial Real EstateInvestment ManagementData Quality MetricsBusiness Glossary

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Participate in requirements gathering and document questions, users, definitions, calculations and acceptance criteria for data products and reports
Trace data lineage from data products to source systems, owners and transformations; document gaps, overlaps and conflicting definitions
Build and maintain analytical datasets and reports using SQL, Power BI / Fabric and Excel
Validate assumptions, reconcile results across funds, systems and reports, and investigate variances and anomalies
Support business testing and validation by preparing test cases, comparing outputs, and tracking issues to resolution
Convert recurring ad-hoc requests into reusable datasets and self-service reports
Prepare and normalize datasets for reporting
Prepare user guides, data dictionaries and training materials
Support AI use cases by documenting requirements and testing AI-generated outputs
Catalog data elements in the firm's data catalog tool
Maintain the business glossary
Establish and automate data quality rules with data stewards and subject-matter experts
Monitor data quality and produce metrics, scorecards and trend reporting
Perform root cause analysis of data quality issues and track remediation through resolution
Support governance processes including change management, data access requests and sensitive-data handling

Requirements

What you’ll need

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
Working proficiency in SQL and advanced Excel
Hands-on experience with Power BI or a similar BI tool; Microsoft Fabric is a plus
Experience with semantic models
Familiarity with data catalogs, business glossaries, data lineage, data quality rules and metrics, and master data management
Experience with Microsoft Purview, Ataccama or similar tools is a plus
Ability to write clear, well-structured documentation, including business requirements, data definitions, lineage maps and test results
Comfort working with large, imperfect datasets and reconciling data across multiple systems
Strong attention to detail and persistence in investigating data discrepancies
Good communication skills and ability to work effectively with business and technical colleagues
Genuine enthusiasm for AI and emerging technologies, demonstrated through hands-on use and self-directed learning
Interest in commercial real estate and investment management; prior exposure is a plus
Collaborative, curious and organized approach with eagerness to learn and grow

Benefits

Comp & perks

Market competitive base salaries
Yearly bonus potential
Medical, dental, vision, life insurance, and disability insurance
Paid Time Off (PTO)
Parental and military leave
401(k) plan with company match up to 4%
Company-funded pension plan
Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs
Work/Life Resources supporting parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development
Education Benefit for approved traditional college enrollment and accredited certificate programs
Employee Stock Purchase Plan with shares purchasable at 85% of the lower of two prices
Eligibility for discretionary annual incentive program
Hybrid work arrangement