Data Modeler

Job Title

Experience designing dimensional/star schema and normalized data models from scratch

Experience using Erwin Data Modeler

Understanding how to work within data modeling and metadata standards frameworks (i.e. naming standards, class word standards, writing clear, concise, unambiguous definitions. This is huge as it is the most time-consuming piece of the data modeling effort but also one of the things regulators will look at in ensuring we DO understand our data and are using it appropriately. From a resume perspective, someone with experience developing modeling standards would be expected to have that knowledge, or if they explicitly call out data naming and metadata standards in their resume.

Strong communications skills, verbal and written:

• Have to be able to illicit information on data needs from business users who do not understand our role/goal
• Must be able to speak to their design/modeling decisions (specifically to the DRB but also within the team)
• Must be willing/able to communicate/escalate issues found while developing their data models.

S2T mapping experience is a plus especially within marts/dimensional models as this is foundational to lineage.

Flexibility in approach to achieving goals when the “right” solution is not achievable in the short term. This is one we probably won’t see on a resume but need to get to in an interview. I have run into many people where perfection is the ONLY acceptable outcome.