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
• Minimum of two years of 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

This role requires candidates to work from a TCW office a minimum of four days a week. Flexibility for remote work is offered on one day, depending on business needs.

Estimated Compensation:

Base Salary: For a NY based positions, the base salary range is 90k-115k. This represents base salary range only.

Other Compensation:In addition to the base salary, this position will be eligible to be considered for an annual discretionary bonus.

Benefits: Eligible for TCW’s comprehensive benefits package. 

#LI-JS1 #LI-Hybrid