Data Modeler

Tekskills; Bengaluru; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Tekskills in Bengaluru seeks an experienced Data Modeler to design robust data models for analytics, translating business requirements into scalable data structures.

You will develop logical and physical models, work with ERwin, SQL Server and Oracle, and leverage cloud analytics stacks like Azure Synapse and Databricks, ensuring data quality and mentoring junior team members.

Qualifications

• Experience translating business requirements into data solutions.
• Strong SQL and NoSQL knowledge.
• Proficient with relational databases (SQL Server, Oracle).
• Exposure to cloud analytics platforms (Azure Synapse, Databricks).
• Experience in ETL and analytics data modeling.
• Experience handling APIs (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

Data modeling

SQL / NoSQL

ETL / analytics modeling

Dimensional modeling

APIs (REST/JSON/XML)

Tools

ERwin

SQL Server

Oracle

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