Fund Accounting- Data analyst

Description for Internal Candidates

• Experience in Fund Accounting, asset servicing, or investment operations.
• Familiarity with NAV calculation, positions, transactions, and accounting hierarchies.
• Experience working with:
• Third‑party accounting platforms
• Vendor‑provided data feeds
• Canonical or enterprise data models

Project Description:

The Fund Accounting Data Project ingests, rationalizes, and publishes fund accounting data from first‑party and third‑party Fund Accounting systems into a centralized Data Platform.

The platform supports two primary outcomes:

• A client‑facing portal with analytics and data visualizations
• The Core Accounting Model, acting as the internal canonical representation of accounting data

The initiative involves:

• SQL Server‑based source systems
• API‑based vendor data feeds
• Cloud‑based processing and transformation (Databricks)
• High requirements for data accuracy, auditability, and lineage

Role Objective Provide a Technical Analyst who can operate within a technical delivery team to define and manage data requirements for ingestion and conversion from Fund Accounting source systems. The analyst is responsible for translating business and accounting concepts into clear, unambiguous technical data artifacts, including detailed documentation of data mappings and transformations. Role Context

Embedded within a data platform / data engineering delivery team.

Works daily with:

• Data engineers
• Platform engineers
• Accounting SMEs
• Product and delivery leads

Operates in an Agile delivery model with incremental releases.

Primary focus is data correctness, consistency, and usability downstream.

Core Responsibilities (What They Will Do)

• Elicit and clarify fund accounting and data requirements from accounting SMEs and business stakeholders.
• Analyze source‑system data structures, schemas, and extracts.
• Define and document:
• Source‑to‑target data mappings
• Transformation and conversion rules
• Data standardization logic
• Produce and maintain:
• Technical data requirements
• Data catalogs
• Data dictionaries
• Definitions of canonical data elements
• Translate business and accounting requirements into technically actionable specifications for data ingestion pipelines.
• Partner closely with data engineers to validate mappings, transformations, and assumptions.
• Use SQL to:
• Profile source data
• Validate transformation logic
• Support reconciliation and data quality checks
• Support downstream consumers by ensuring data is fit for visualization and core accounting model usage.

Explicit Non‑Responsibilities (Important for Profile Filtering)

• Not a project manager or delivery lead.
• Not a visualization or BI developer.
• Not a data engineer writing ingestion pipelines.
• Not a purely functional BA without hands‑on data analysis capability.

Required Experience (Non‑Negotiable)

• 5+ years as a Technical Analyst, Data Analyst, or Technical Business Analyst in data‑centric initiatives.
• Strong SQL skills; able to independently analyze large and complex datasets.
• Direct experience with data ingestion, transformation, or migration projects.
• Experience defining source‑to‑target mappings and data conversion logic.
• Proven track record working closely with engineering teams in Agile environments.
• Ability to operate effectively with incomplete, inconsistent, or evolving source data.

Preferred Background (Strong Signals)

• Experience in Fund Accounting, asset servicing, or investment operations.
• Familiarity with NAV calculation, positions, transactions, and accounting hierarchies.
• Experience working with:
• Third‑party accounting platforms
• Vendor‑provided data feeds
• Canonical or enterprise data models
• Exposure to data governance concepts such as data lineage, ownership, and quality controls.

Success Criteria (How We Will Judge Fit)

A successful Technical Analyst on this project will:

• Produce clear, implementation‑ready data specifications trusted by data engineers.
• Identify data quality issues and inconsistencies early in the ingestion process.
• Reduce rework by eliminating ambiguity in mappings and transformation logic.
• Ensure consistent data definitions across multiple source systems.
• Enable accurate downstream reporting and accounting model consumption.

Seniority Guidance

• Mid‑to‑Senior level individual contributor.
• Expected to work independently with minimal oversight.
• Must proactively drive clarification, documentation, and resolution of data issues.