Data Modeler

Project Role : Data Modeler


Project Role Description : Work with key business representatives, data owners, end users, application designers and data architects to model current and new data.


Must have skills : Data Modeling Techniques and Methodologies


Good to have skills : Teradata BI, Snowflake Data Warehouse
Minimum
7.5 year(s) of experience is required


Educational Qualification : 15 years full time education


Summary:
As a Data Modeler, Supports the onshore Data Modeler in designing and refining enterprise data models by contributing to detailed schema definitions, field-level mappings, and source-to-target conversion documentation. Collaborates closely with cross-functional teams to ensure alignment between business requirements and technical data structures, with a strong focus on cloud-based data platforms.


Roles Responsibilities:

Expected to be an SME, collaborate and manage the team to perform.

Assist in developing logical and physical data models, including schema design for reporting and analytical platforms

Perform detailed field mapping between source and target systems to support data migration, integration, and transformation efforts

Document and maintain source schema definitions, conversion rules, and data lineage artifacts

Create and update Entity-Relationship Diagrams (ERDs) to represent data relationships in the Reporting Data Model

Develop and maintain comprehensive data dictionaries, including business definitions, data types, constraints, and metadata attributes

Leverage strong exposure to AWS Data Services such as Amazon S3, Glue, Redshift, Athena, and EMR to support cloud-based data modeling and transformation requirements

Ensure data consistency, quality, and governance standards are adhered to across all modeling and documentation activities

Partner with SMEs, developers, and business stakeholders to validate data structures and mapping logic

Support impact analysis and change management for schema updates and enhancements


Professional Technical Skills:


Must To Have Skills:

Proficiency in Data Modeling Techniques and Methodologies.

Good To Have Skills: Experience with Snowflake Data Warehouse, Teradata BI.

Strong knowledge of relational and dimensional data modeling concepts.

Ability to design scalable and maintainable data models that support complex business requirements.

Experience in collaborating with cross-functional teams to gather and analyze data requirements.

Familiarity with data governance principles and best practices to ensure data quality and consistency.

The candidate should have minimum 7.5 years of experience in Data Modeling Techniques and Methodologies.

This position is based at our Bengaluru office.

A 15 years full time education is required.


Qualification 15 years full time education