Previous Job
Lead Data Modeler with Hadoop Exp
Ref No.: 18-01517
Location: jersey city, New Jersey
Job Title: Lead Data Modeler with Hadoop Exp
Location: Clinton, NJ
Duration: 6 months

Hands-On – data modeling on SQL, Erwin (or equivalent) Strong in Hadoop (Hortonworks, Cloudera)
Job Description
  • The Enterprise Data Management (EDM) team provides transformative data capabilities and solutions that serve as the core data, reporting, and analytics platform for the Insurance & Agency Group
  • The Data Modeler is responsible for creating data models and rules for the corporate projects, systems implementations, and new application development.
  • The Data Modeler will possess the necessary analytical and technical skills required for supporting and accomplishing the modeling efforts.
  • They may perform some or all of the following functions: Interviews of technical and business Subject Matter Experts; Systems analysis; Data flows; Data profiling; developing the data models, creating STM (Source to Target Mappings) for applications.

  • 10+ years in Data Modeling role proficient with entity relation diagrams, logical/physical data models creation, review, and analysis and issue resolution
  • Work independently and with Business Analysts and SMEs to gather, document and explain requirements
  • Ability to apply modeling standards to logical and physical ERDs
  • Ability to work with the Development team
  • Experience with data mapping (ETL data mapping with defined technical and business rules
  • Complex logic, not only 1:1 data mapping) Experience with data modeling concepts (conceptual/logical/physical/semantic, multi-dimensional models (star, snowflake), normalized/denormalized models)
  • Experience with understanding data - profile and analysis (metadata (formats, definitions, valid values, and boundaries), relationship/usage)
  • Experience with data warehousing
  • Experience driving data design and end to end processing Experience with moderate SQL scripts (creating, reading, running, customizing) Work independently with minor oversight
  • 10 + years experience working with data models using Erwin is a must.
  • Life insurance knowledge is plus.