Data Modeler

Tekskills; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Benefits offered by this job

Gen AI exposure

BFSI domain experience

Job summary

Tekskills in Hyderabad, India is seeking an experienced Data Modeler who can translate business requirements into robust data structures and analytics solutions. The role centers on designing logical and physical data models, developing dimensional models (Star Schema, Snowflake, 3NF), and ensuring data quality across on-premise and cloud platforms (SQL Server, Oracle, Azure Synapse, Databricks).

You will collaborate with business and technical teams, document data dictionaries, and mentor

Qualifications

• Experience with ERwin or similar data modeling tools.
• Strong SQL and NoSQL knowledge.
• Experience with relational databases such as SQL Server and Oracle.
• Exposure to cloud data platforms like Azure Synapse or Databricks.
• Experience in ETL and analytics data modeling.
• Experience handling API data (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.
• Collaborate with business and technical teams.
• Mentor junior team members.

Skills

ERwin

SQL/NoSQL

Relational databases

Azure Synapse / Databricks / Cloud

ETL and analytics data modeling

API data handling

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