Data Management Analyst

Position Summary

The Data Management Analyst performs support for the day-to-day operations in setting up accurate and timely security master reference data for all investment products. This position will require a broad functional understanding of domestic and global securities including complex structured fixed income products and derivatives. The Analyst should be familiar with system architecture, data flow, and workflow to support the Security Master. This position will work closely with the Investment Management Team, and will liaise with other key groups within the firm, including Risk Management, Investment Control, Settlements, Derivative Operations, Information Technology and Portfolio Reconciliation.

Essential Duties

• Responsible for the set-up of all securities purchased by the investment teams. Securities including but not limited to securitized (ABS & MBS products), treasuries, corporates, bank loans, exchange-traded derivatives, OTC derivatives and Emerging Markets timely.
• Perform analysis including cleansing, transforming, validating or modeling data for improving data quality, design and presenting. Knowledge and experience in project life cycle and the testing process are required.
• Monitor CRD (Charles River) and SMS Proprietary system for data quality.
• Support the security maintenance on all Securities held in SMS Proprietary System and CRD is accurate and completed in a timely manner.
• Support the real time quality assurance (QA) review for new CUSIP set-up and maintenance to existing CUSIPs, utilizing a rule based process.
• Support the processing and research for Factor and Coupon Mass Corrections.
• Responsible for supporting the daily identification and processing the Liquidity Alerts.
• Track securities that require manual updates; develop data sources and perform timely maintenance to enable accurate data output for Reconciliation, Trading, and Settlements.
• Work closely with Investment Management, Compliance, Client Service, Risk, Operations and IT/Technology.
• Serve as company-wide resource for data inquiries; research asset discrepancies and defaulted securities by using Bloomberg, contacting trustees, and communicating with brokers and vendors.
• Interface with Bloomberg and Data License/Bloomberg on data issues.
• Participate in special projects and research for systems enhancement, automation, and efficiencies as requested by management.
  
  

Required Qualifications

• Bachelor’s Degree in Finance, Mathematics, Economics or a similar field
• 2-5 years’ experience managing Security Master data for Investment Management.
• Asset management industry experience with broad understanding of trading, compliance, settlement and accounting processes and associated data management needs
• Experience in maintaining data, defining operational processes, and partnering across departments
• Solid working knowledge of fixed income and equity securities - domestic and global securities, ABS, MBS, Bank Loans, Swaps, Futures, and Options
  
  

Professional Skills Qualifications

• Strong communications skills; ability to effectively communicate with peers and management
• Rigorous attention to detail; extreme accuracy with numerical calculations
• Excellent time management and organizational skills; ability to prioritize and complete all assigned tasks
• Strong analytical and problem-solving capabilities
• Research skills, resourcefulness, and ability to take/interpret instruction
• Works well in a team environment
• Flexible in working any schedule requested to meet the needs of the department
• Responsive, possess strong written and verbal communication skills
  
  

Desired Qualifications

• Knowledge of Aladdin, CRD, SharePoint, Microsoft Visual Studio (TFS) and K2
• Strong computer skills with demonstrated proficiency in Microsoft Excel, SQL, Word, and Bloomberg/Bloomberg API
  
  

Estimated Compensation

Base Salary: For NY based position, the base salary range is $ 90k to $110k This is an anticipated range only.

Other Compensation : Eligible to be considered for an annual discretionary bonus

Benefits : Eligible for TCW’s comprehensive benefits package. See more information here .