Senior Data Modeler / Data Architect

Talent Corner Hr Services; Bengaluru; On-site; INR 3,500,000 - 6,500,000; Full time

Job summary

Talent Corner Hr Services is seeking a seasoned Data Architect with 10-15 years of experience to design conceptual and logical data models for large-scale enterprise data warehouses. You will work with Erwin/ER Studio, develop ETL processes, and craft dimensional models to support BI initiatives.

Collaborate with stakeholders to capture requirements, create optimized SQL queries, troubleshoot performance, and ensure adherence to DWH standards and best practices in data modeling.

Qualifications

• 10-15 years of experience in Data Modeling/Data Architecture roles.
• Strong expertise in Conceptual Data Modeling, Advanced SQL, Dimensional Modeling, LDW, Data Marts, Redshift AWS.
• Experience on large-scale Enterprise Data Warehousing projects involving multiple databases.

Responsibilities

• Design and develop conceptual data models for large-scale enterprise data warehouses.
• Create logical data models, ETL processes, and dimensional models to support BI initiatives.
• Collaborate with stakeholders to gather requirements and translate them into technical designs.
• Develop complex SQL queries to optimize database performance and troubleshoot issues.
• Ensure compliance with industry standards and best practices for data modeling.

Skills

Data Modeling

Data Architecture

Conceptual Data Modeling

Advanced SQL

Dimensional Modeling

LDW

Data Marts

Redshift AWS

Erwin

ER Studio

Tools

Erwin

ER Studio

Job description

Roles and Responsibilities

• Design and develop conceptual data models using Erwin/Er Studio for large-scale enterprise data warehouses.
  
• Create logical data models, ETL processes, and dimensional models to support business intelligence initiatives.
  
• Collaborate with stakeholders to gather requirements and translate them into technical designs that meet business needs.
  
• Develop complex SQL queries to optimize database performance and troubleshoot issues.
  
• Ensure compliance with industry standards (e.g., DWH) and best practices for data modeling.
  

Desired Candidate Profile

• 10-15 years of experience in Data Modeling/Data Architecture role.
  
• Strong expertise in Conceptual Data Modeling, Advance SQL, Dimensional Modeling, Logical Data Warehouse (LDW), Data Marts, Redshift AWS.
  
• Experience working on large-scale Enterprise Data Warehousing projects involving multiple databases.