Data Modeler

Hiring Data modeler for one of the global consulting firm for Pan India location.

Experience - 4-10 years

This 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