Data ArchitectData Modeler

Tekskills Inc.; Mumbai; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Tekskills Inc. in Mumbai seeks a senior data architect/analyst to lead data modeling, warehousing, and ETL/ELT efforts across enterprise environments.

The role requires 10+ years of experience and deep SQL, PySpark, and Spark SQL skills, with collaboration across data engineers, architects, and stakeholders to ensure data quality and governance.

Qualifications

• 10+ years of experience in Data Architecture, Data Modeling, or Data Analysis.
• Strong expertise in conceptual, logical, and physical data modeling.
• Advanced SQL skills for profiling, validation, and complex queries.
• Experience with source-to-target mapping and transformation logic.
• Strong understanding of Data Warehousing and ETL/ELT concepts.
• Hands-on experience in PySpark and Spark SQL.
• Excellent analytical, debugging, and problem-solving skills.
• Experience in complex enterprise data environments.

Responsibilities

• Analyze complex datasets to understand data structures, relationships, and quality issues.
• Design and maintain conceptual, logical, and physical data models.
• Define source-to-target mappings and transformation logic for data pipelines.
• Develop implementation-ready specifications and pseudo-code for engineering teams.
• Perform data reconciliation, variance analysis, and root cause analysis.
• Support testing, validation, and production go-live activities.
• Collaborate with Data Engineers, Architects, and business stakeholders.
• Ensure data quality, governance, and compliance with enterprise standards.
• Contribute to enterprise data architecture and integration initiatives.

Skills

Data Architecture

Data Modeling

Data Analysis

Advanced SQL

Source-to-Target Mapping

Data Warehousing

ETL/ELT

PySpark

Spark SQL

Job description

Key Responsibilities

• Analyze complex datasets to understand data structures, relationships, and quality issues.
• Design and maintain conceptual, logical, and physical data models.
• Define source-to-target mappings and transformation logic for data pipelines.
• Develop implementation-ready specifications and pseudo-code for engineering teams.
• Perform data reconciliation, variance analysis, and root cause analysis.
• Support testing, validation, and production go-live activities.
• Collaborate with Data Engineers, Architects, and business stakeholders.
• Ensure data quality, governance, and compliance with enterprise standards.
• Contribute to enterprise data architecture and integration initiatives.

Required Skills

• 10+ years of experience in Data Architecture, Data Modeling, or Data Analysis.
• Strong expertise in conceptual, logical, and physical data modeling.
• Advanced SQL skills for profiling, validation, and complex queries.
• Experience with source-to-target mapping and transformation logic.
• Strong understanding of Data Warehousing and ETL/ELT concepts.
• Hands-on experience in PySpark and Spark SQL.
• Excellent analytical, debugging, and problem-solving skills.
• Experience working in complex enterprise data environments.