Job Description :
Position: Sr. Data Modeler
Location: Clinton, NJ
Duration: Long Term
Start Date: Immediate
Interview: F2F/ In-Person Mandatory

Below skills are mandatory .
1. Hands On – data modeling on SQL, Erwin (or equivalent)
2. Strong in Hadoop (Hortonworks, Cloudera)
3. Insurance domain preferable

Job Description:
Interface with Business teams to understand business strategies, requirements, and pain points that can be aided by business solutions, reports, and analytics
Interface with Technology teams to export, transform and deliver data elements to stakeholders in a timely fashion
Works with Technology teams to identify and implement new data solutions
Execute on various requests and requirements by sourcing raw data from multiple databases, tables and systems
Identify, develop and implement self-service and automated solutions where appropriate
Make recommendations for business rules and communicate solutions to stakeholders
Oversee data quality and ensure data is properly translated for consumption by end business users
Assure project deadlines are met and manage work flows

Requirements:
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
Excellent interpersonal skills necessary
Life insurance experience is a plus.
10 + years experience working with data models using Erwin is a must.
Life insurance knowledge is plus.
Demonstrated time management skills.
Organizational skills and attention to detail.
Experience creating Party model is a plus.
Excellent verbal and written communication skills.
Must be able to work in a fast-paced environment with daily work processing deadlines.
Should be able to work on on-site off-shore model.