Data Analyst Investment Operations

Analyze large datasets of security and benchmark data (Equities, Fixed Income, Derivatives, Indices) to identify gaps, duplicates, and inconsistencies prior to migration.

• Perform root-cause analysis on bad data and execute manual or bulk cleanup procedures.

• Map data attributes between the legacy source system and the target platform, ensuring accurate translation of business logic.

• Testing & Validation:

• Lead the reconciliation process between the old and new platforms to ensure data parity.

• Design and execute detailed test cases for security setup, pricing feeds, and benchmark composition.

• Identify, log, and track data defects; work closely with the technical implementation team to resolve migration errors.

• Business Support & Documentation:

• Validate that the new platform meets the consumption needs of downstream systems and consumers.

• Develop and document new processes and operational workflows.

• Document data dictionaries, exception handling procedures, and operational controls.

• Act as a subject matter expert (SME) for business users during the transition period.

We are seeking a highly motivated Operations Analyst who can work independently on complex processes. The ideal candidate will have knowledge of financial products and valuation coupled with a strong background in data management, including experience with SQL, PowerApps, and Python., Bachelor’s degree in Finance, Economics, or a related field

• 5+ years of experience in Data Operations, Data Governance, or Investment Operations within an Asset Manager or Hedge Fund.

• Deep understanding of financial instruments (Equities, Bonds, Futures, Options) and Reference Data (Issuers, Corporate Actions, Ratings, Classifications).

• Familiarity with major index providers (e.g., MSCI, S&P, Bloomberg, FTSE) and how benchmark data is structured (constituents, weights, returns).

• Advanced Excel proficiency (VLOOKUP, Pivot Tables) is required. Proficiency in SQL for data querying and analysis is highly preferred.

Preferred Qualifications

• Familiarity with accounting and valuation of various asset classes including structured products and derivatives

• Experience with Accounting and Trading Systems; APX, CRD, Bloomberg

• Experience with major EDM (Enterprise Data Management) platforms (e.g., GoldenSource, IHS Markit/S&P EDM, SimCorp).

skills:

Trading Systems,large datasets,business logic,Crystal Reports,Data Analysis,Data Governance,Master data,data management,data transformation,Data Operations,data querying,Document data,Enterprise Data Management,VLOOKUP,Advanced Excel proficiency,Pivot Tables,PowerApps,Python,reference data,SQL,Proficiency in SQL,detail-oriented,highly motivated,work independently,UAT,accounting,asset classes,reconciliation process,benchmark data,business knowledge,Business Support,calculations,Composite,Corporate Actions,Economics,EDM,Derivatives,knowledge of financial products,financial instruments,Equities,Fund Performance,Global Investment,Hedge Fund,Investment Operations,financial,Finance,maintenance,Testing & Validation,root-cause analysis,Security,Shareholder,exception handling,pricing,structured products,technical implementation,operational workflows