Data Modeller – GCP & Cloud Databases

6 - 9 years

0 Lacs

Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Contractual

Job Description

Job Title:

Data Modeller – GCP & Cloud Databases

Location:

Chennai (Work From Office)

Experience Required:

6 to 9 Years

Role Overview

We are looking for a hands-on Data Modeller with strong expertise in cloud-based databases, data architecture, and modeling for OLTP and OLAP systems. You will work closely with engineering and analytics teams to design and optimize conceptual, logical, and physical data models, supporting both operational systems and near real-time reporting pipelines.

Key Responsibilities

  • Design conceptual, logical, and physical data models for OLTP and OLAP systems
  • Develop and refine models that support performance-optimized cloud data pipelines
  • Collaborate with data engineers to implement models in BigQuery, CloudSQL, and AlloyDB
  • Design schemas and apply indexing, partitioning, and data sharding strategies
  • Translate business requirements into scalable data architecture and schemas
  • Optimize for near real-time ingestion, transformation, and query performance
  • Use tools such as DBSchema or similar for collaborative modeling and documentation
  • Create and maintain metadata and documentation around models

Must-Have Skills

  • Hands-on experience with GCP databases: BigQuery, CloudSQL, AlloyDB
  • Strong understanding of OLTP vs OLAP systems and respective design principles
  • Experience in database performance tuning: indexing, sharding, and partitioning
  • Skilled in modeling tools such as DBSchema, ERWin, or similar
  • Understanding of variables that impact performance in real-time/near real-time systems
  • Proficient in SQL, schema definition, and normalization/denormalization techniques

Preferred Skills

  • Functional knowledge of the Mutual Fund or BFSI domain
  • Experience integrating with cloud-native ETL and data orchestration pipelines
  • Familiarity with schema version control and CI/CD in a data context

Soft Skills

  • Strong analytical and communication skills
  • Detail-oriented and documentation-focused
  • Ability to collaborate across engineering, product, and analytics teams

Why Join

  • Work on enterprise-scale cloud data architectures
  • Drive performance-first data modeling for advanced analytics
  • Collaborate with high-performing cloud-native data teams
Skills: olap,normalization,indexing,gcp databases,sharding,olap systems,modeling,schema definition,sql,data,oltp systems,alloydb,erwin,modeling tools,bigquery,database performance tuning,databases,partitioning,denormalization,dbschema,cloudsql

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You