Data Modeler with Collibra or Sharepoint
Location: Malvern, PA (Hybrid)
Position type: Contract
shyam@hanstaffing.com
· This role designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases.
· These solutions support IIG's Full service and Investments only business with data analytics, reporting, business intelligence, machine learning, data science, and other business interests.

Tools and Skills (must have)
· Erwin
· SQL
· Experience on working with relational and other databases.
· Documentation using Confluence, Sharepoint
· Collibra
· Deep understanding of Datawarehouse, Datamart and Data lake
· Good Data Profiling skills
· Hands on experience with AWS databases – such as HIVE, Redshift, and Aurora.
· Deep understanding of OLTP and OLAP system
· Deep understanding of Dimensional Modelling , Star schemas , Snowflake schemas
· Good understanding of ETL VS ELT