Data Modeler - Erwin/RDBMS (5-10 yrs)

The Data Modeler will play a pivotal role in translating complex business requirements into data models that align with the client's architectural guidelines and industry best practices.

If you possess a blend of analytical prowess, a deep understanding of data structures, and the ability to communicate effectively with both technical and non-technical stakeholders, this role awaits you.

Responsibilities :

- Develop the logical data model based on the understanding of the conceptual model and conduct data profiling with the objective of delivering high-quality data models and high-quality data within the limits of standards defined by the client, and industry.

- In collaboration with the Lead Data Modeler / Architect, analyze the requirements and create a clarification list, if required.

- Define data requirements based on an understanding of the same.

- In collaboration with the Lead, create a conceptual model based on the understanding of the business processes.

- Map KPIs to the conceptual model, if required.

- Validate the conceptual model with Managers, SMEs, etc.

- Create a logical model (capturing the descriptions of entities, tables, columns, etc. ) based on the conceptual model.

- Create tables and relationships between the tables.

- Map conceptual to the logical model to ensure the coverage Identify the entities and their properties.

- Define the attributes and domain (data types).

- Create a physical model based on functional/ non-functional requirements for small and simple projects.

- Seek review inputs from the Lead / Manager / Architect on the logical and physical model.

Define the data dictionary/ business glossary based on the model developed, if required.

- Define the data governance model to ensure the data quality.

- Interact with SMEs (business) and architects to validate whether the data model is aligned with the technology suggested for the project.

- Interact with the Architect to gather reporting requirements and create models based on the same.

- Participate in Data Model Health Assessments.

- Assist Sr. Data Modeler in the creation of questionnaires, analyze the AS-IS data model for data structure, conformance to industry standards, and best practices, and make recommendations for solution/roadmap.

- Provide technical guidance to the design/ development team in understanding the data mode.

Requirements :

- Very Good knowledge of Dimensional/Relation Data Modeling.

- At least 7+ years of Data Modeling experience working in large databases.

- Worked on ERWIN, DeZign, etc modeling tools.

- Knowledge of RDBMS Concepts, Data Analysis, and good SQL knowledge.

- Should be technically strong in relational databases and able to provide design approaches.

- Prior experience in working in a large Enterprise Data Warehouse is expected.

- Experience in Banking, Health, and Life Insurance domain is preferable.

- Ability to coordinate and explain with business users to get the requirements.

- Should have very good and clear communication skills.

- Should have experience of working in an Onsite-offshore model.

- Experience working in projects involving multiple time zones and onsite-offshore models and with

multiple vendors.

- Excellent written and verbal communication skills.