Data Product and Engineering Consultant - Total Portfolio Analysis

United Nations; New York (NY); On-site; USD 96,000 - 165,000; Part time

Job summary

United Nations Joint Staff Pension Fund – Office of Investment Management is seeking a Data Product and Engineering Consultant to lead the TPV analytics build. You will define the semantic layer, data dictionary, source POVs, and technical data model, and deliver a dynamic dashboard prototype to validate directions with stakeholders.

The role emphasizes incremental delivery, clear ownership, and documented decisions, with close collaboration across data stewards and business users to align on

Qualifications

• Deliverables defined: Work plan and operating cadence with scope, timeline, stakeholders, decision points, risks, and escalation path.
• TPV semantic layer and data dictionary with definitions, attributes, grain, formula, inputs, lineage, and ownership.
• Source assignment and Data POVs linking data points to authoritative sources, with data quality assessment and decision rationale.
• Technical requirements and data model backlog-ready covering data model implications, transformations, refresh, quality checks, dependencies, and prototype logic.
• Dynamic TPV dashboard prototype with interactive capabilities and data source validation.

Responsibilities

• Review current TPV dashboard plan and propose incremental delivery aligned with the data platform.
• Define source system mappings and Data POVs with ownership.
• Capture technical requirements and data model backlog for implementation.
• Develop dynamic TPV dashboard prototype and validate user interactions.
• Prepare handover pack and knowledge transfer for the OIM team.

Job description

This is the main content of our website.

Data Product and Engineering Consultant - Total Portfolio Analysis

Job Opening

Job Opening ID: 286407

Job Network : -

Job Family : Information Management Systems and Technology

Category and Level : Affiliate Personnel – Consultants/Individual Contractors , CON

Recruitment Type : Consultant

Department/Office : United Nations Joint Staff Pension Fund – Office of Investment Management

1. Work Plan and Operating Cadence
   • Deliverable: Work plan and operating cadence.
   • Expected output / acceptance criteria:
     • Confirmed scope, timeline, stakeholders, decision points, risks, and escalation path.
     • Review of the current TPV dashboard plan and recommendation for an incremental delivery approach aligned with the data platform build-out.
     • Identification of key trade-offs, risks, and dependencies.
     • Weekly status updates covering progress, open decisions, blockers, and next steps.
     • Review and approval: Chief of Data.
2. TPV Semantic Layer and Data Dictionary
   • Deliverable: TPV semantic layer and data dictionary.
   • Expected output / acceptance criteria:
     • Agreed definitions for each TPV data point and metric.
     • Documentation of attributes, grain, formula, inputs, frequency, history, owner, lineage, and business context.
     • Definitions that are clear and actionable for both business users and engineers.
     • Review and approval: Chief of Data; TPA dashboard working group.
3. Source Assignment and Data POVs
   • Deliverable: Source assignment and Data POVs.
   • Expected output / acceptance criteria:
     • Each mapped data point, metric, and attribute linked to an authoritative source system, dataset, and field.
     • Documentation of competing sources, gaps, overlaps, conflicts, and data quality issues through Data POVs.
     • Recommended source precedence and documented decision rationale.
     • Review and approval: Chief of Data; source owners.
4. Technical Requirements and Data Model
   • Deliverable: Technical requirements and data model.
   • Expected output / acceptance criteria:
     • Backlog-ready requirements covering:
       • Data model and domain data product implications.
       • Data transformations.
       • Data refresh requirements.
       • Data quality checks.
       • Dependencies and implementation priorities.
       • SQL/Python prototype logic, where useful.
     • Review and approval: Chief of Data.
5. Dynamic TPV Dashboard Prototype
   • Deliverable: Dynamic TPV dashboard prototype.
   • Expected output / acceptance criteria:
     • Interactive prototype developed in Power BI or Sigma.
     • Use of source data from individual systems where available.
     • Validation of dashboard direction and user interactions.
     • Validation of drill-down paths.
     • Identification and prioritization of production build requirements.
     • Review and approval: Chief of Data; dashboard leadership.
6. Handover Pack and Knowledge Transfer
   • Deliverable: Handover pack and knowledge transfer.
   • Expected output / acceptance criteria:
     • Documentation of key deliverables and decisions.
     • Consolidated list of open decisions and risks.
     • Implementation backlog inputs.
     • Recommended next steps for the OIM team.
     • Completion of knowledge transfer sessions.
     • Review and approval: Chief of Data.

Cross-Cutting Requirement

• Review the current TPV dashboard plan, data inventory, and delivery assumptions.
• Recommend an incremental delivery approach aligned with the data platform build-out.
• Identify:
  • Early release opportunities.
  • Dependencies and sequencing choices.
  • Key trade-offs.
  • Priority adjustments, where needed.