Senior Data Modeler - CHN

Location: Chennai Experience: 6-9 Years Job Summary: We are looking for a highly skilled Senior Data Modeler with extensive experience in data modeling, SQL, metadata management, and data governance . The ideal candidate will have expertise in relational, dimensional, and analytic data modeling with hands-on experience in databases like Oracle, PostgreSQL, Snowflake, and Teradata . Strong knowledge of data governance, data cataloging tools (Alation, Collibra), and metadata repositories is essential. Key Responsibilities:

Design, develop, and maintain relational, dimensional, and analytical data models for large-scale OLTP and analytical systems .

Perform hands-on data modeling, ER diagramming, and enterprise software design for diverse data ecosystems.

Define and enforce data modeling standards and best practices for scalable and high-performance solutions.

Work with SQL databases such as Oracle, PostgreSQL, Snowflake, and Teradata , optimizing performance and query tuning.

Collaborate with cross-functional teams (engineers, architects, product managers) to translate business requirements into effective data models .

Implement metadata management, data lineage, and data cataloging using tools like Alation and Collibra .

Ensure data accuracy, completeness, and consistency across data models and maintain comprehensive documentation.

Support history handling, time-series data warehousing, and complex data transformations .

Assist teams in adopting data modeling best practices for global, large-scale data-driven implementations.

Contribute to data governance initiatives and establish a centralized metadata repository .

Work in a fast-paced, agile environment with short release cycles and iterative development methodologies.

Required Skills:

7+ years of experience in relational, dimensional, and analytical data modeling.

Strong SQL skills with hands-on experience in Oracle, PostgreSQL, Snowflake, and Teradata .

Experience with data modeling tools (Erwin, ER Studio, or similar).

Expertise in data governance processes and metadata repositories .

Knowledge of semantic data modeling concepts and multi-fact model designs.

Strong verbal and written communication skills to interact with engineers, architects, and product managers .

Ability to work on multiple projects/products simultaneously with minimal specifications.

Experience in Alation and Collibra for data cataloging and data lineage tracking .

Good to Have:

Knowledge of Python for data processing.

Experience with Informatica for ETL and data integration.