Data Analyst/Data ModelerLocation: 1700 American Blvd, Pennington, NJ 08534 Duration: 10 months Rate: DOE US Citizens and Green cards are Preferred. No 3rd party C2CJob Description:1. Work with the BAs and Business to understand the requirements2. 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 Integrations7. 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 Model3.
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 Redshift5. Knowledge of NoSQL data stores such as MongoDB, Neo4J, Cassandra, Redis, etc.6.
Experience with Data Warehouse and Data Marts