Data Modeller

Job Title: Data Modeller

Location: Chennai (On-site only)
Employment Type: Full-Time

Job Description:

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