Data Modeler -Data Vault (Anyoffshore Location)

Extract logic from reports and SSIS / SQL code to build data lineage by evaluating existing data systems

Work with SMEs to model all layers of the Warehouse using DVM and Kimball

Data Vault layers Raw data vault Business Data vault

Consumption layers Kimball DIMs Facts along with Data Marts

Model using best practices

Document logical physical metadata models along with data mappings across layers of the warehouse

Setup standards for mappings data types naming standards etc

Primary Skills :

Strong modeling experience in DVM 20 and Kimball of at least 3 yrs

Strong SQL skills

Working knowledge of MDD for Saama resources

Working knowledge using Erwin

Hands on knowledge with Metadata management

Secondary Skills :

Experience of working with Insurance Domain

Soft Skills :

Excellent written and verbal communication skills, experience working with cross-functional teams, and presenting to leadership.

Strong ability to work with client stakeholders.