Job Description

Job Title:

Data Modeller

Location:

Chennai (On-site only)

Employment Type:

Full-Time

:

We are looking for an experienced

Data Modeller

to join our team and drive data architecture for high-performance OLTP and OLAP systems. The ideal candidate will have deep expertise in data modeling methodologies and performance optimization, with hands-on experience across various GCP data platforms.

Key Responsibilities:

Design and implement data models for both

OLTP (transactional)

and

OLAP (analytical)

systems. Develop and maintain

Conceptual, Logical, and Physical data models

. Apply advanced techniques such as

indexing, data partitioning, and sharding

to optimize performance. Identify and optimize variables affecting

database performance

for real-time reporting and high-throughput applications. Collaborate with stakeholders to translate business requirements into scalable and efficient data structures. Work closely with application developers and data engineers to ensure models are aligned with system architecture.

Required Skills & Experience:

Proven hands-on experience in

data modeling

for complex systems. Strong understanding of

indexing, partitioning, and sharding

strategies with practical implementation exposure. Expertise in performance tuning and designing for

high concurrency and real-time access

. Proficiency in at least one

data modeling tool

, preferably

Erwin

or

DBSchema

. Solid knowledge of

GCP databases

, including:

AlloyDB

(PostgreSQL-compatible)

Cloud SQL

(MySQL/PostgreSQL)

BigQuery

(OLAP)

Preferred Qualifications:

Functional knowledge of the

mutual fund or financial services industry

is a strong advantage. Experience in

cloud-native architecture

and

data governance

practices is desirable.

Additional Details:

Location:

This is a Chennai-based role.

Office presence is mandatory.

Work Type:

Full-time, individual contributor role within the data engineering or architecture team.
Job Types: Full-time, Permanent

Pay: ?514,912.86 - ?1,497,845.15 per year

Benefits:

Health insurance Provident Fund
Work Location: In person