Data Modeler

Data Modeler

Responsibilities :

• 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 solutions
• Strong analytical, data profiling and problem-solving skills
• Strong verbal and written communication skills
• Advanced 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 products
• Excellent teaming and communication skills.