ETL DATA MODELER

HSS Soft; Fort Mill (SC); On-site; USD 90,000 - 120,000; Full time

Job summary

HSS Soft recherche un Data Modeler pour fournir des recommandations architecturales et soutenir les activités de modélisation de données dans le domaine des réclamations. Le candidat idéal aura une solide expérience en DWBI et en modélisation, avec des compétences en outils comme ERWIN, et des connaissances en matière de gestion de l'information. Ce rôle exige également une bonne communication et des compétences analytiques dans le secteur des assurances.

Qualifications

• 6-8 ans d'expérience en DWBI, avec au moins 3-4 ans en modélisation de données.
• Expérience avec des outils de modélisation de données et plusieurs bases de données.
• Connaissance des normes et politiques de gestion des données.

Responsibilities

• Responsable de la traduction des exigences fonctionnelles en modèles logiques.
• Traduire le modèle logique en un design physique.
• Adhérer aux normes d'audit et de gestion des données.

Skills

Data Modeling

SQL

Dimensional Modeling

Analytical Skills

Education

4-year degree in a related field

Tools

ERWIN

Teradata

Oracle

Job description

HSS SOFT is an Equal Employment Opportunity Employer

Job Description

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:

• 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

Additional Information

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