Data Analyst/Data Modeler-Pennington, NJ

Data Analyst/Data Modeler

Location: 1700 American Blvd, Pennington, NJ 08534 Duration: 10 months Rate: DOE US Citizens and Green cards are Preferred. No 3rd party C2C

Job Description:

1. Work with the BAs and Business to understand the requirements

2. Create the source to target mapping that documents the business name, definitions, business and data quality rules, RDM, source and target and transformation logic.

3. Ability to create and update models, generate data dictionaries, DDL using best practices in ER studio.

4. Proficient in SQL to query data to research data in the data platform.

5. Very good understanding of Insurance domains (Clinical Data; Claims, Enrollment, provider, etc.).

6. Has experience and understanding of best practices, guidelines and standards for Data Governance, Data Quality and Data Integrations.

7. Development of best practices, guidelines and standards for Data Governance, Data Quality and Data Integration Knowledge:

1. Experience with Healthcare data formats such as X12, HL7, NCPDP, etc.

2. Experience with Industry Data Models such as ADRM, IBM IIW/HPDM or Teradata Healthcare Data Model

3. Experience with Metadata management processes and tools (Glossary, Lineage, Mapping, etc.)

4. Knowledge of, and experience, with database management system (DBMS) physical implementation, including tables, joins and views, specifically Oracle and Redshift

5. Knowledge of NoSQL data stores such as MongoDB, Neo4J, Cassandra, Redis, etc.

6. Experience with Data Warehouse and Data Marts