Job TitleMust Haves: 5+ years of hands on data modeling experience with an emphasis in data warehousing and analytics. Must have expert level SQL skills with a preference for candidates with Python/Pyspark, SAS, an/or Big Data experience.***Candidates with Capital One experience in McLean VA, followed by any Capital One, Fannie Mae, or Freddie Mac experience will be considered first.***1. For new project, DM should model the whole structure of all tables including:Identify which table is parent and which table is child, what’s relationship between themIdentify primary key, foreign key, null and not null on each columnCreate logical/physical data model2.
For existing project, DM should be understand new requirement and analyze the existing table structure and consider all factors on upgrade.