Hello ,
Please find the below requirement details
Position: Data Architect / Modeler
Location: 100% Remote
Duration: 8 Months
Client: Vantage
Vendor: Apex
Visa: Only USC/GC/ H4EAD/GC EAD
Required Skills
Must have experienced building an Enterprise Data Warehouse from scratch Cloud experience (they are working on Azure synapse, but any cloud is fine) Kimball and Imnon modeling experience
INSURANCE, COMMERCIAL PNC OR SPECIALITY, NOT HEALTHCARE EXPERIENCE IS REQUIRED
Snowflake is preferred, but SQL works too!
Job Description
Build out enterprise data warehouse that will feed their financials and other types of management/biz info for biz users in general
Prior models that she has seen built out are specific to insurance and depict how a policy/claim is structured
So in identifying a candidate as their enterprise data arch to build this DW, it is advantageous for them to understand P/C commercial insurance
DW experience and building out a model in amends (?) style format or any formats actually
Understand/experience within the cloud- Azure or whatever cloud
Snowflake, Azure synaps
Completely from the ground up
Types of DB? Single EDW so only one DB platform, DB built on snowflake
SQL will be able to pick up snowflake quickly
Will need to work with the business
Business needs to be comfortable with what is being built
Will also be doing the modeling – should have Kimball or Inman style. Have knowledge in one of those and built out one of them for an insurance or reinsurance
Access to the accord model, not likely they will use it but it will help and guide that person