Previous Job
Data Profiling Analyst
Ref No.: 18-02683
Location: Hamilton, New Jersey
NTT DATA has an immediate need for a Data Profiling Analyst to support our client in Hamilton, NJ.

To apply for this position, please follow the link below or send your resume directly to For more information please call Shawn Mills at 732-362-2596.

Project description:
The Data Analyst will be part of the State of New Jersey Data Warehouse implementation team which is an enterprise data warehouse that contains information extracted from several state transactional systems, ranging from New Jersey Medicaid / Children's Health insurance Program (CHIP) to NJ Family Assistance Management Information System (FAMIS) all the way to diverse programs such as Heating Assistance. As part of the Replacement Medicaid Management Information System (RMMIS) project, the new Medicaid Warehouse will support Data Warehouse functions for the RMMIS and the also the migrated functions of the existing legacy repository. In addition custom reporting capabilities through Cognos Analytics and Advanced Analytics tools will round out the offering in statistics, healthcare analytics, Fraud and Abuse detection and Management and Reporting products.

  • Collaborate with SME's to generate datasets meeting the use case requirements.
  • Create mapping documents by analyzing the data and SQL queries
  • Profile data and document System behavior, highlight discrepancies if any.
  • Help with SIT testing and collaborate with developers to implement requirements.
  • Identify and document test cases based on requirements.
  • Able to juggle multiple priorities and ensure availability to questions and clarifications from developers, other analysts.
  • Analyze gaps between existing business processes and best practices in order to recommend process improvements.
  • Bachelor's degree in related field or equivalent experience.
  • 7+ years of experience working as a Data analyst in the health care industry, particularly with administrative healthcare claims and provider data, preferably in Medicaid domain.
  • Knowledge of health insurance, HMO and managed care principles including Medicaid and Medicare regulation.
  • Understanding of FFS, Managed Care claims processes.
  • Familiarity with Medicaid Eligibility and Enrollment.
  • Sound grasp of Provider domain in terms of types, specialties, taxonomies etc.
Technical Skills:
  • Experience working with Medicare and Commercial paid claims data sets. Other applicable data sets include Census, Eligibility, and Membership data sets.
  • Experience working with large data repositories and/or relational databases in a Data warehouse environment.
  • Experience profiling data using tools like Informatica IDQ, IBM Infosphere Information Analyzer.
  • Solid experience with Structured Query Language (SQL) required. Ability to learn/adapt to new analytic toolsets (such as Cognos) is a must.
  • Expertise in MS Excel, with proficiency using formulas, PivotTables, linked worksheets, graphing and other reporting and presentation features.
  • Ability to analyze data, and apply investigative skills in resolving issues.
  • Ability to produce clear, written operational instructions and supporting documentation.
  • Knowledge of MDM processes is a nice to have.
  • Ability to work on multiple projects simultaneously with minimal supervision.
  • Excellent computer, organization, and project management skills.
  • Exceptional written and oral communication skills.
  • Highly self-motivated and directed with keen attention to detail.
  • Knowledge of HIPAA compliance and security requirements as it relates to healthcare data.

NTT DATA Services is a leading IT services provider and global innovation partner with 130,000 professionals based in over 50 countries. NTT DATA recently acquired Dell Services. NTT DATA Services emphasizes long-term commitment and combines global reach and local intimacy to provide premier professional services, including consulting, application services, business process, IT outsourcing, and cloud-based solutions. We are a part of NTT Group, one of the world's largest technology services companies, generating more than $100 billion in annual revenues and partner to 80% of the Fortune 100. Visit to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a wide 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.