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