Data Product and Engineering Consultant - Total Portfolio Analysis

The United Nations Joint Staff Pension Fund (UNJSPF) is seeking a consultant to support its Office of Investment Management in developing the Total Portfolio View dashboard. The role defines data requirements, semantic layers, source mappings, and dashboard prototypes to support integrated investment and risk management decisions.

Responsibilities:

• Review the existing TPV dashboard plan and data inventory, including approximately 220 proposed data points and metrics, and develop a structured work plan outlining deliverables, milestones, stakeholders, dependencies, risks, and decision points
• Define and document the TPV semantic layer and data dictionary, establishing consistent business definitions, attributes, granularity, calculation logic, data inputs, frequency, historical coverage, ownership, lineage, and decision rules
• Identify opportunities to develop reusable domain data products that support multiple investment, risk, performance, liquidity, and reporting use cases across OIM
• Map data points, metrics, and attributes to authoritative source systems, including Northern Trust, Bloomberg, MSCI Barra One, Burgiss, and internal registers, as applicable
• Assess data availability, completeness, quality, timeliness, granularity, lineage, and accessibility, identifying source conflicts, gaps, overlaps, and data quality concerns
• Prepare Data Points of View (Data POVs) comparing alternative data sources, definitions, calculation methodologies, and source precedence, providing clear recommendations and supporting rationale
• Develop technical requirements and data models for the TPV dashboard and supporting data infrastructure, including transformations, refresh requirements, data quality checks, and implementation dependencies
• Translate business requirements and sourcing decisions into prioritized data platform delivery backlog inputs, developing SQL or Python prototype logic where appropriate to validate technical assumptions
• Review the existing dashboard implementation plan and recommend an incremental delivery approach aligned with the enterprise data platform build-out, identifying early release opportunities, sequencing priorities, and key trade-offs
• Develop or guide the creation of an interactive TPV dashboard prototype using Power BI or Sigma, incorporating dynamic filters, adjustable variables, and drill-down capabilities to validate dashboard requirements and user interactions
• Facilitate stakeholder discussions and working sessions across Investment, Risk, Operations, the TPA dashboard working group, and the Business Intelligence Team, driving alignment on data definitions, source selection, and implementation priorities
• Prepare weekly progress reports, maintain documentation of decisions and risks, and deliver a comprehensive handover and knowledge transfer package containing finalized requirements, data definitions, source decisions, implementation backlog inputs, and recommended next steps

Requirements:

• Advanced university degree (master's or equivalent) in computer science, data science, engineering, finance or a related field
• A first-level degree with additional qualifying experience may be accepted instead
• Minimum 7 years of advanced data engineering, data modelling or data product delivery experience is required
• Direct experience with TPA, total fund, or total portfolio / multi-asset portfolio analytics, including total fund exposure, factor, risk, performance and liquidity views is required
• Experience with investment data at a pension fund, asset owner or large asset manager, covering public and private markets is required
• Proven experience mapping data definitions to source systems and writing technical requirements is required
• Experience translating business use cases into reusable data product requirements, source decisions and implementation priorities is required
• Experience facilitating business and technical alignment across functions where definitions, source choices or implementation priorities require agreement is required
• Experience building or guiding interactive dashboard prototypes (Power BI and/or Sigma) from multiple sources is required
• Ability to work across business lines and explain data topics clearly to non-technical senior stakeholders is required
• SQL and Python; data modelling, semantic layer design, data warehouse and cloud data platform experience is required
• 10 years or more is desirable
• Snowflake is an advantage
• Power BI and/or Sigma is desirable
• Familiarity with Bloomberg, MSCI Barra One, Burgiss, and custodian or accounting data is desirable