Role: Sr. Data Modeler
Location: Philadelphia, PA
Duration: Contract-Long term
End Client: GSK
- A seasoned Sr. Data Modeler with overall 15+ years of experience and 8 to 10 years of relevant experience
- Analyzes database and business systems requirements in order to perform data modeling (high level conceptual business/data models, entity-relationship and dimensional logical data models, and detailed physical database design models).
- Responsible for applying divisional enterprise business metadata standards to data and object models
- Ensures that the enterprise data dictionary is maintained for the changes associated with their data models updates.
- Expert knowledge of data modeling tool ERWIN and its connectivity with various other tools like (Talend, Collibra, Azure (ADLS) etc…)
- Gather and Publish Data Dictionaries: Maintain data models in ER/win. Capture data models from existing databases, and record descriptive information into Erwin.
- Has expert knowledge of all DB design patterns (E/R vs Dimensional & generic vs specific) as they apply to the type of application (OLTP, Data mart , Data warehouse)
- Experience working with cross-functional teams in a dynamic environment
- Assist the technical experts in providing understanding of the various data elements
- Provide data warehousing / dimensional modeling and OLTP modeling expertise
- Closely work with the Business Analysts and Technical Architects to ensure the effective translation of Business and Technical requirements into the logical/Physical data model to enable Self Service
- Good knowledge of Dynamic Data Modelling techniques
- Good background of working with data cutting across ERP systems (like SAP), WorkDay, CRM systems (like Veeva ) etc…
- Manage multiple tasks & assignments as a team player with effective communication skills and stakeholder management