Data Modeler

Tekskills Inc.; Chennai; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Tekskills Inc. in Chennai is seeking an experienced Data Modeler to design robust data models for analytics. You will translate business requirements into optimized data structures, ensuring consistency and quality across data assets.

The role involves building dimensional models (Star Schema, Snowflake, 3NF), data profiling, dictionaries, and ER diagrams, while mentoring junior teammates and collaborating with business and tech teams.

Qualifications

• Proven experience designing logical and physical data models.
• Strong SQL and NoSQL proficiency for analytics.
• Experience with data profiling, validation, and data dictionaries.

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.
• Create data dictionaries and ER diagrams.
• Mentor junior team members.
• Work with business and technical teams.

Skills

Data modeling

SQL/NoSQL

Data quality

Mentoring

Tools

ERwin

SQL Server

Oracle

Azure Synapse

Databricks

ETL

REST APIs

JSON

XML

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