Data Analyst Investment Operations

Job Summary

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.

location: Boston, Massachusetts

job type: Contract

salary: $40 - 45 per hour

work hours: 9am to 5pm

education: Bachelors

Responsibilities

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.

Qualifications

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).

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

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.