The role sits in the Global Business Enablement team within the real estate business of a global asset manager, which is part of a larger financial services group.
The team pursues two linked goals: building trusted data products and analytics for each stage of the real estate investment cycle, and running the data governance that keeps that data accurate, clearly defined and reusable.
The real estate business manages $207.9 billion in gross assets ($133.8 billion net) across equity, debt, agriculture and impact strategies, and has local professionals in 32 cities.
The role suits an early-career professional who likes working directly with data and wants to learn how a global real estate investment business operates.
Responsibilities
Run requirements sessions with business stakeholders and record the questions, users, definitions, calculations and acceptance criteria for new data products and reports.
Trace lineage for each new data product by mapping every required element to its source system, owner and transformations, and note any gaps, overlaps and conflicting definitions.
Work with technology colleagues to build and maintain analytical datasets and reports in SQL, Power BI, Fabric and Excel, drawing on internal and external sources.
Check source data against assumptions, reconcile results across funds, systems and reports, and investigate variances and anomalies.
Help test new data products by writing test cases, comparing outputs with source and historical data, and logging issues until they are closed.
Turn recurring ad hoc requests into reusable datasets and self-service reports to reduce manual work and one-off spreadsheets.
Prepare and normalize datasets for reporting.
Write user guides, data dictionaries and training material that explain what each data product holds and which questions it answers.
Document requirements for AI use cases and test AI-generated outputs for accuracy and reasonableness.
Catalog data elements in the data catalog tool (for example Microsoft Purview), recording definitions, owners, source systems, classifications and lineage.
Maintain the business glossary so terms, calculations and definitions stay consistent across teams and regions.
With data stewards and subject-matter experts, set data quality rules for completeness, validity, consistency, timeliness and accuracy, and turn them into automated, repeatable checks.
Track data quality and produce regular metrics, scorecards and trend reports for stakeholders and governance forums.
Carry out root cause analysis of quality issues, trace them to source, pass them to the right data steward, and confirm fixes are made at source rather than in downstream reports.
Support governance processes, including change management for definitions and datasets, data access requests and handling of sensitive data.
Requirements
Bachelor's degree in information systems, finance, economics, real estate, data/analytics or a related field.
1, 3 years in data analysis, business analysis, data governance, data quality or reporting, ideally in commercial real estate, investment or asset management, or financial services.
Working proficiency in SQL and advanced Excel, plus hands-on experience with Power BI or a similar BI tool and with semantic models.
Microsoft Fabric is a plus.
Understanding of data governance concepts such as catalogs, glossaries, lineage, 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 covering business requirements, data definitions, lineage maps and test results.
Comfort working with large, imperfect datasets and reconciling data across multiple systems.
Careful attention to detail, a habit of questioning figures that look wrong, and persistence until you find the cause.
Good communication skills and the ability to work well with both business and technical colleagues.
Real enthusiasm for AI and emerging technology, shown through hands-on use of current tools and self-directed learning.
Interest in commercial real estate and investment management is a plus.
A collaborative, curious and organized approach, with an eagerness to learn and grow.
The company welcomes applicants who do not meet every requirement and encourages you to apply if your skills fit the role.
Conditions
Hybrid role with on-site work three times a week, based in Newark, NJ or New York, NY.
Base salary range is $90,000 to $130,000, with the exact pay varying by factors such as location, experience and skills.
The role may also be eligible for additional compensation or benefits.
Identity verification technologies may be used during hiring, and your consent is obtained before any verification takes place.
Benefits
Competitive base salary with yearly bonus potential at every level.
Medical, dental, vision, life insurance and disability insurance, plus paid time off and leave such as parental and military leave.
401(k) plan with company match up to 4%.
Company-funded pension plan.
Wellness reimbursement up to $1,600 a year for items that support personal wellbeing.
Work/life resources covering parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development.
Education benefit to help finance traditional college enrollment toward an approved degree and many accredited certificate programs.
Employee stock purchase plan: shares can be bought at 85% of the lower of the beginning or end price of the purchase period.
Discretionary annual incentive program, where any award depends on the program rules and on individual and organizational performance, among other factors.
Some benefits may not apply to part-time employees scheduled to work fewer than 20 hours a week.