Employer Active
Title : Data Modeler
Client : Vanguard.
Location: Malvern, PA
Responsibilities:
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.
Must have skills:
Erwin
SQL
Experience on working with relational and other databases.
Documentation using Confluence and SharePoint
Collibra
Deep understanding of Data warehouse, 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
Full Time