ETL DATA MODELER

Additional Information

All your information will be kept confidential according to EEO guidelines.

Company Description

HSS SOFT is an Equal Employment Opportunity Employer

Job Description

Requisition Details:

Overview:

A Data Modeler with a primary focus of this position to provide architectural guidance and technological recommendations that support the Data Modeling activities in support of DW/BI solutions in Claims area.

Requirements:

Candidate must be experienced working in creation and implementation of Data Models and Abinitio. Other ideal qualifications include experiences in:

• Data Management 

• SQL (Teradata / SQL Server / Oracle)

• Data Modeling tool like ERWIN

• Dimensional modeling (3NF)

• Completes, tunes, refines, and successfully partners with DA for the physical data model build in the database environment for access and data consumption.

• Contributes and abides by Data Management and Information Architecture Standards, Guidelines and Policies.

• Should have Insurance domain experience

Responsibilities:

• Accountable for translating information function requirements and patterns into Logical Data Models

• Accountable to adhering to prevailing corporate audit, data management, information architecture, and modeling standards

• Responsible for translating logical model into a physical design that supports application access and performance requirements

• Responsible for data modeling and model management principles, guidelines, and best practices

• Responsible for ensuring insight provided into the End to End Data Strategy

Skills:

• 6-8 years of work experience in DWBI with atleast 3-4 years in Data Modeling

• Good experience with Data Modeling tools (ERWIN)

• Good hands-on for multiple databases like Teradata & Oracle

• Good analytical and logical skills in writing SQLs, Stored Procedures and creating Marts/Views

• Strong experience in Dimensional Modeling

• Awareness of Data Management and Information Architecture Standards, Guidelines and Policies

• 4-year degree in a related field (or equivalent experience)

• Experience working within a highly-matrixed organization

• Strong communication and presentation skills

EOE/Minority/Female/Veteran/Disabled