Sr Technical Lead-Data Engg

Area(s) of responsibility

Data Modeler (Data Engineering - AWS)

Experience: 8-12 Years

Job Summary

We are seeking an experienced Data Modeler with strong expertise in AWS-based Data Engineering platforms. The ideal candidate will be responsible for designing, developing, and maintaining enterprise data models that support analytics, reporting, and data integration initiatives. The role requires deep knowledge of data modeling methodologies, cloud data warehousing, metadata management, and governance standards.

8-12 years of experience in Data Modelling

Design and maintain Conceptual, Logical, and Physical Data Models for enterprise data platforms.

Develop dimensional models including Star Schema, Snowflake Schema, Data Vault, and Hybrid Modeling approaches.

Create scalable data models optimized for Amazon Redshift and cloud-native analytics workloads.

Define data standards, naming conventions, metadata standards, and modeling best practices.

Perform data analysis and profiling to understand source systems and business requirements.

Collaborate with data architects to define target-state data architecture.

Design data models supporting AWS-based data platforms leveraging: Amazon Redshift, Amazon RDS

Maintain enterprise data dictionaries and business glossaries.

Manage metadata repositories and lineage documentation.

Ensure compliance with data governance standards.

Strong hands-on experience with:

Erwin Data Modeler (Mandatory)

Technical Skills

• Erwin Data Modeler (Mandatory)
• Data Warehousing Concepts
• Star Schema & Snowflake Schema
• Data Vault Modeling
• Metadata Management
• Data Governance & Data Lineage
• Amazon Redshift
• Amazon RDS

Preferred Skills

• Experience working on AWS Data Lake and Modern Data Platform architectures.
• Exposure to ETL/ELT frameworks and Data Engineering practices.
• Knowledge of Agile/Scrum delivery methodologies.
• Strong communication and collaboration skills.

Mandatory Skill: Erwin Data Modeler.