Data Modeler

Tekskills Inc.; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Gen AI exposure

BFSI domain experience

Job summary

Tekskills Inc. in Mumbai, India is seeking an experienced Data Modeler to translate business requirements into scalable data structures and analytics-ready models.

You will design logical and physical data models and collaborate with both business and technical teams to ensure data quality. The role involves building dimensional models (Star Schema, Snowflake), maintaining data dictionaries, mentoring junior engineers, and leveraging ERwin, SQL/NoSQL, and cloud platforms such as Azure Synapse or

Qualifications

• Must design data models translating business requirements into data solutions.
• Experience with data modeling tools and data architectures.
• Strong SQL/NoSQL knowledge across relational and non-relational stores.

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

ERwin

SQL

NoSQL

Relational DBs

Azure Synapse

Databricks

ETL modeling

APIs (REST/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