Job Title

Hiring Data modeler for one of the global consulting firm for Pan India location.Experience - 4-10 yearsThis role works with business analysts, business stakeholders and technical personnel to translate business data requirements into data models and related data artefacts, which will form the basis of solutions which meet and fulfil the business requirements. This role reports to the Lead Data Modeller. Tasks include: ∙Producing Conceptual, Logical and Physical Data Models and related artefacts to specified standards ∙Producing Entity Relationship Diagrams and specifying and documenting the relationships between entities, specifying and documenting the data attributes for each entity ∙Data Vault modelling knowledge and experience ∙Agreeing entity and attribute definitions with the respective stakeholders ∙Producing Data Ontologies and Class Diagrams ∙Generating data model schema scripts, using data modelling tools, from Physical Data Models ∙Simultaneously being part of several project teams in order to allow multiple projects to proceed at pace concurrently ∙Contributing to data modelling framework design discussions regarding items such as the design and use of Reference Data ∙Investigating and providing estimates for data modelling work and, reporting progress to-date ∙Working with Business SME and Technical staff to identify the data sources to be used to meet the business requirements ∙Data mapping: The identification, specification and documentation of data mappings and the associated transformations in order to move data from the source systems, through the data warehouse layers where appropriate and, to present the data to authorised end users ∙The clarification and documentation of business rules and data transformations with technical colleagues and business users (who may be members of senior management) ∙Working with Database Administrators (DBA’s) and information service designers to ensure the physical implementation meets the functional and non-functional requirements Skills & Experience: ∙Build data flows and develop conceptual data models Internal ∙Create logical and physical data models using best practices to ensure high data quality and reduced redundancy ∙Optimise and update logical and physical data models to support new and existing projects ∙Maintain conceptual, logical and physical data models along with corresponding metadata ∙Develop and maintain best practices for standard naming conventions and coding practices to ensure consistency of data models ∙Recommend opportunities for reuse of data models in new environments ∙Perform reverse engineering of physical data models from databases (Oracle, Microsoft Azure) and SQL scripts ∙Good knowledge and experience of metadata management, data modelling, and related tools (Erwin or ERStudio or others) required ∙Good understanding if graph modelling (neo4J, Star Dog or similar) ∙Should have good SQL scripting knowledge to perform reverse engineering activities ∙Examine new application design and recommend correction wherever applicable