Data Modeler

Tekskills Inc.; Kolkata District; On-site; INR 650,000 - 1,100,000; Full time

Job summary

Tekskills Inc. in Kolkata seeks an experienced Data Modeler to design logical and physical data models and translate business requirements into scalable data structures for analytics initiatives.

You will develop dimensional models, ensure data quality, perform profiling, create data dictionaries and ER diagrams, and collaborate with business and technical teams while mentoring junior colleagues.

Qualifications

• Experience with data modeling tools like ERwin.
• Strong SQL and NoSQL knowledge.
• Experience with relational databases (SQL Server, Oracle).
• Knowledge of Azure Synapse or Databricks.
• Experience with ETL and analytics data modeling.
• Experience with API data handling (REST, JSON, XML).

Responsibilities

• Design logical and physical data models.
• Translate business requirements into data solutions.
• Develop dimensional models (Star Schema, Snowflake, 3NF).
• Ensure data quality and consistency.
• Perform data profiling and validation.
• Create data dictionaries and ER diagrams.
• Work with business and technical teams.
• Mentor junior team members.

Skills

SQL

NoSQL

Dimensional modeling

Data profiling

Data dictionaries

ER diagrams

Tools

ERwin

Azure Synapse

Databricks

Job description

We are looking for an experienced Data Modeler with strong skills in designing data models and supporting analytics solutions. The candidate should be able to understand business requirements and convert them into effective data structures.

Key Responsibilities

• Design logical and physical data models
• Translate business requirements into data solutions
• Develop dimensional models (Star Schema, Snowflake, 3NF)
• Ensure data quality and consistency
• Perform data profiling and validation
• Create data dictionaries and ER diagrams
• Work with business and technical teams
• Mentor junior team members

Required Skills

• Experience with ERwin or similar data modeling tools
• Strong SQL / NoSQL knowledge
• Relational databases (SQL Server, Oracle)
• Azure Synapse / Databricks / Cloud exposure
• ETL and analytics data modeling
• API data handling (REST, JSON, XML)

Good to Have

• Gen AI exposure
• BFSI domain experience