Data Modeler
Sr. Data Modeler
Location: Westlake, Or Smithfield,RI ( 2 weeks every month onsite)
BU: WI TechnologyEquity and finance reporting. Associate will need to look at the data and understand how the data is going to be consumed and model the data accordingly. BA will give requirement and the specs, and then the modeler will have to figure out how the data can be modeled to make sure multiple reports can use the data.
Required skills: Data Modeling Data Analysis Data Engineering Finding patterns and 1:1 Commonalities SQL querying Nice to have: Power Designer OLTP – Online Transaction Processing No domain experience required Enterprise experience – they will be collaborating with many different people to get what they need and need to be intuitive about there process. I
nterview Two Steps - Candidate will also be given a data set and asked to create a model prior to the interview.
Your Expertise
• Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level
• Dimensional Modeling with experience in crafting conformed dimensions that can be used across Business Units.
• Data Modeling Tool such as Powerdesigner, Oracle Designer or Erwin
• Experience working with Data Engineering and Data Analytics teams
• Ability to write SQL to query data (ideally ANSI SQL)
• General working knowledge of AI technologies, techniques, and trends
The Skills You Bring
• Strong analytic skills
• Excellent written and oral communication skills
• Ability to explain Data structures to a non-technical audience
• Good interpersonal, negotiating, and influencing skills