Data ArchitectData Modeler

Tekskills Inc.; Hyderabad; On-site; INR 2,200,000 - 4,200,000; Full time

Job summary

Tekskills Inc. in Hyderabad, India seeks a Senior Data Architect to lead data modeling and architecture efforts across enterprise platforms. You will design conceptual, logical, and physical models, define mappings, and ensure data governance and quality.

The role requires 10+ years in data architecture with strong SQL, PySpark, and DW/ETL expertise. You will collaborate with data engineers, architects, and business stakeholders to deliver scalable data solutions.

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 working 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

SQL Proficiency

Source-to-Target Mapping

Data Warehousing

ETL/ELT

PySpark

Spark SQL

Analytical Skills

Enterprise Data

Tools

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.