REMOTE Data Vault Engineer

Post Date

May 26, 2023

Location

West Des Moines,
Iowa

ZIP/Postal Code

50266
US
Jun 22, 2025 Insight Global

Job Type

Contract

Category

Data Warehousing

Req #

DSM-626964

Pay Rate

$57 - $86 (hourly estimate)

Job Description

Insight Global is looking to bring on a contract Data Engineer at one of our large financial clients. This large Financial and Insurance company is growing quickly and has several large initiatives going into 2023. This candidate will have experience in designing and implementing Data Vault models. This resource will play a key role on the team iterating and maturing Data Vault patterns at Sammons Financial. Play a lead role in design, modeling and documentation of the raw and business data vault. Provide data modeling expertise including establishing standards and best practice procedures. Must have created flexible and scalable model using Data vault 2.0 modelling methodologies. Must be able to create fully attributed and documented conceptual, logical and physical models for reporting and analytics. Will be empowered to create value-based solutions within an Agile Scrum Team.

Required Skills & Experience

* 8 years IT development experience

* Must have 2 years of hands-on experience in building raw Data Vault modelling.

* Must have strong Dimensional Modeling/Star Schema experience

* Snowflake Experience

* Required experience with Data Modeling tools like Hacolade, Power Designer or ER/Studio

* Certified Data Vault 2.0 Practitioner (CDVP2) -- preferred

* Strong SQL skills

Nice to Have Skills & Experience

* Insurance background

* Knowledge of SQL and NoSQL databases

* Knowledge of the ACORD reference model

* Experience with SalesForce data/integration

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.