Data Modeler

Data ModelerResponsibilities :Engage the business users to assess their BI and Analytics needs.Review the business process and conceptualize the entities that interoperate within the business process.Determine how the various entities are related and develop entity relationship diagrams that represent the connections among the entities.Identify each entity's characteristics and properties and ensure that the entities can be differentiated within the model.Develop a logical data model and validate the model to ensure that it serves the needs of the business application and its consumers.Transform the logical representation of the model into a physical representation and work with database administrators to instantiate and manage the data.Collaborate with the BI and Analytics teams on creating the optimized, reusable dimensional model, complete with metadata and lineage information.Optimize the model to ensure predictable performance.Maintain the metadata -- the "data about the data" describing the data model, its structure, and semantics.Recommend and establish standards, guidelines, and procedures for design and maintenance.Build models using Erwin and maintain these models in the Erwin mart.Qualification and Experience :Min 7-8 years of proven data modeling experience in an enterprise environment developing relational databases (Sql Server, Teradata) and cloud DWH databases like Synapse (preferred), Redshift etc.Proficient in industry standard techniques for data modeling.The Data Modeler must be proficient in 3NF relational and Dimensional modeling.Proven experience developing models for Business Intelligence solutionsStrong analytical, data profiling and problem-solving skillsStrong verbal and written communication skillsAdvanced SQL skills- analysis, DDL, DML.Hands on experience with Erwin or an equivalent tool for building and maintaining ER diagrams.In depth knowledge of modeling methodologies and techniques.In depth knowledge of facilitation and conflict resolution processes.Experience with Business Intelligence productsExcellent teaming and communication skills.