ETL DATA MODELER
At a glance
Mid-level Data Engineering role at HSSSoft. Fort Mill · full-time · no salary stated · we estimate $112,500–$160,000 across the United States.
HSSSoft has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Turn information needs and recurring patterns into logical data models for claims data warehouse and BI work
- Convert logical models into physical database designs that support application access and performance
- Work with data architects on physical model builds, refining and tuning designs for data access and use
- Apply modeling and data management standards while helping shape end-to-end data strategy
What you bring
- Six to eight years in data warehousing and BI, including at least three to four years focused on data modeling
- Hands-on experience building data models and using Abinitio, plus modeling tools such as ERWIN
- Practical work with Teradata or Oracle and SQL, including stored procedures and marts or views
- A related four-year degree or equivalent experience, with insurance-domain experience
Who this fits
This mid-level role suits someone who can translate business information needs into logical and physical models and work across a highly matrixed organization. The position is onsite in Fort Mill.
From the employer
HSS SOFT is an Equal Employment Opportunity Employer
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.
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.