ETL DATA MODELER

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 All your information will be kept confidential according to EEO guidelines. HSS SOFT is an Equal Employment Opportunity Employer