Job Title: Financial Data Analyst
Location: Hybrid Boston, MA (Hybrid)
Type: Contract with potential for conversion
We are seeking a highly detail-oriented and experienced Data Analyst for a critical data transformation project. This role focuses on the migration of Benchmark (Index) and Security/Issuer Master data from a legacy system to a new data platform.
Unlike a pure engineering role, this position requires a high degree of business knowledge. The ideal candidate understands the complexities of financial reference data and can bridge the gap between technical migration and business utility. You will be responsible for ensuring the integrity of our data through rigorous cleanup, reconciliation, and UAT.
Responsibilities
- Data Analysis & Cleanup:
- 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.
Candidate
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.
Required Qualifications
- 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).