Sr Technical Lead-Data Engg

Birlasoft; Telangana; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

Birlasoft Hyderabad is seeking an experienced Data Modeler with 8–12 years of experience to design, develop, and maintain enterprise data models that support analytics, reporting, and data integration on AWS-based platforms. Responsibilities include conceptual, logical, and physical modeling, Star/Snowflake/Data Vault schemas, Redshift/RDS optimization, metadata management, and governance.

Mandatory expertise in Erwin Data Modeler and collaboration with data architects to define target-state

Qualifications

• 8-12 years of experience in Data Modelling.
• Experience with AWS-based data platforms and Redshift.
• Strong knowledge of data modeling methodologies, governance, and metadata.
• Hands-on Erwin Data Modeler is mandatory.
• Ability to design conceptual, logical, and physical models.

Responsibilities

• Design, develop, and maintain enterprise data models.
• Create dimensional models (Star, Snowflake, Data Vault).
• Collaborate with data architects and ensure governance.
• Maintain data dictionaries and metadata repositories.
• Optimize models for Redshift and cloud analytics.

Skills

Erwin Data Modeler

Data Warehousing Concepts

Star Schema

Snowflake Schema

Data Vault Modeling

Metadata Management

Data Governance

Data Lineage

Amazon Redshift

Amazon RDS

Job description

Select how often (in days) to receive an alert:

Location: INDIA - HYDERABAD - BIRLASOFT OFFICE

Title: Sr Technical Lead-Data Engg

Description:

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.