Data Analyst, Transaction Management

PIMCO•Newport Beach, CA

About The Position

We are seeking a detail-oriented Transaction Management Data Analyst & Controls professional to support the firm’s global transaction management transformation. This role focuses on data analysis, reconciliation frameworks, and certification criteria used to validate transaction accuracy, lifecycle completeness, and migration readiness as trade processing workflows move from legacy to strategic platforms. The analyst serves as a critical quality control checkpoint, ensuring transaction data is complete, accurate, and production-ready before downstream consumers—including accounting, position management, performance, and risk—are migrated or reliant on new workflows.

Requirements

5+ years of experience in trade management, transaction processing, investment data reconciliation, or operational controls within asset management, investment banking, or prime brokerage environments.
Strong analytical skills with hands-on experience performing transaction-level reconciliations across multiple systems and asset classes.
Solid understanding of trade lifecycle events, including allocations, confirmations, settlements, amendments, resets, novations, and FX impacts.
Familiarity with migration certification, UAT methodologies, and parallel testing for trade or middle-office platforms.
Proficiency with data analysis tools (e.g., Python, SQL, Excel) and experience developing exception reports or reconciliation dashboards.
Strong written communication skills, with the ability to produce audit-ready documentation and clear certification summaries for senior stakeholders.

Responsibilities

Design and execute end-to-end reconciliation frameworks to compare transaction lifecycle data across legacy and target platforms, including trade capture, confirmation, and settlement states.
Define and maintain certification criteria and acceptance thresholds to validate transaction completeness and accuracy across asset classes, regions, and booking entities.
Perform detailed root-cause analysis on transaction breaks, mismatches, and lifecycle discrepancies, distinguishing among system behavior differences, control gaps, timing issues, and data quality failures.
Develop and maintain controls, exception reporting, and monitoring dashboards to support continuous validation throughout migration and stabilization periods.
Partner closely with the Transaction Management transformation lead, Technology, Accounting, and Operations teams to document and remediate upstream data and workflow issues.
Support testing cycles (UAT, parallel runs, migration rehearsals) by validating transaction logic, lifecycle progression, and reconciliation outcomes.
Prepare clear, evidence-based certification and signoff materials for senior stakeholders, audit teams, and migration governance forums.
Monitor transaction-related exceptions during test and migration phases, escalating material issues and driving resolution within defined SLAs.