This company is committed to hiring Veterans

Capital Markets Data-Business Analyst

This job is no longer active. View similar jobs.

POST DATE 8/12/2016
END DATE 10/12/2016

NTT Data Consulting Inc. Charlotte, NC

Charlotte, NC
AJE Ref #
Job Classification
Full Time
Job Type
Bachelors Degree



At NTT DATA Consulting, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees have been key factors in our company’s growth and market presence. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work here.

NTT DATA Consulting currently seeks an AML Data Analyst to join our team in New York City, NY.

AML Data Analyst

Pursuant to maintaining compliance with Anti-Money Laundering / Bank Secrecy Act requirements, the Client requires business / data analysts to help conduct gap analysis on Global Markets transactional data subject to suspicious activity monitoring. MANTIS is the activity monitoring platform used by Global Financial Crimes Compliance that receives the various data feeds (transactional, positional and any other activity) on which it runs algorithms to determine alignment with compliance requirements. The main objective will be to engage with business owners and technology to investigate sources of transactional data and underlying feeds to identify root cause for the observed anomalies in the data (completeness, accuracy, failure to meet tolerances, etc.)

The resources will work from an existing list of gaps (based on a previous internal review) specifically noting the current state data flows, source-to-target mapping and any other interaction that leads to resolution of the data gap. In defining the current state and working with GFCC to explain the nature of the data feeds, it may be determined the perceived gap is not a gap at all, but was a lack of understanding the actual securities’ reference data elements from the individuals who compiled the list of data gaps. Knowledge of various types of securities (equities, fixed income, derivatives and FX) and the ability to do forensic research on the transactional or positional data is imperative. In the case that a true gap is determined / confirmed, the resource will work directly with business leaders / technology leads to devise a resolution plan that will include either:
1) Tactical approach: changes to existing feeds

2) Strategic approach: changes to planned new / in-flight data input sources to feed MANTIS: QzTrade or REG W Trade Repository.

Basic Qualifications:
-5-7 years’ experience with data analysis skills and experience with relational databases (some SQL is a plus)
-Security Master / Product and Pricing Reference Data
-Full life cycle of a trade and all data elements that compose a trade / transaction
-Must be local to NY, NJ, Connecticut and be on site daily to work at either a Downtown NYC or Jersey City location or potentially a combo of both

Skills required/desired:
-Knowledge of capital markets business with various types of securities (equities, fixed income, derivatives and FX)
-For Derivatives (there is an underlying security) and FX (there is an underlying currency): Familiarity with transaction data attributes and structure (ex: multi-leg deals), OTC Bi-lateral & Listed products is a plus
-Ability to face off with business partners to understand the data gap and work with technology to fix it. And the ability to articulate the source of the data gap and how to resolve it or the ability to articulate clearly to the business why this data gap is not a gap, but the nature of the way the security trades.
-Must be able to work independently (hit the ground running) or as part of a collaborative team across multiple FTE and vendors
-Must have strong Excel in relation to large data sets (i.e., v-lookup, pivot tables, use of aggregate functions) and Visio workflow ability
-Must be familiar with data modelling concepts
Global CCAR experience
-Experience at a Top 5 Investment Bank is ideal, (Merrill Lynch, Morgan Stanley, Goldman, JPMorgan, etc.)
-Ability to read/write Data Model and Data Mapping documents
-Have a general understand Database structures
-Ability to generate reports using basic queries
-Strong skills in Excel & SQL
-Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
-Interpret data, analyze results using statistical techniques and provide ongoing reports
-Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
-Acquire data from primary or secondary data sources and maintain databases/data systems
-Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems
-Work closely with management to prioritize business and information needs
-Locate and define new process improvement opportunities
-Technical expertise regarding data models, database design development, data mining and segmentation techniques
-Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks)
-Knowledge of statistics and experience using statistical packages for analyzing large datasets (Excel, SPSS, SAS etc)


NTT DATA is your Innovation Partner anywhere around the world. With business operations in more than 35 countries, we put emphasis on long-term commitment and combine global reach and local intimacy to provide premier professional services from consulting, system development, business process and IT outsourcing to cloud-based solutions.

Visit to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a range of businesses and government agencies.

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

Job Benefits

  • Dental Insurance
  • Health Insurance
  • Holidays
  • Life Insurance
  • 401K / Retirement Plan
  • Sick Leave
  • Vacation
  • Vision Insurance