Enterprise Data Architect

VMC Soft Technologies, Inc; Chennai District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

VMC Soft Technologies, Inc. seeks a Data Analyst / Data Modeler contractor to support the Data Integration Hub (DIH). You will bridge business requirements, data modelling, and engineering delivery to provide clean, reconciled data for analytics platforms.

You will operate within the Data Architecture & Engineering function, leveraging strong SQL, ETL/ELT skills and PySpark knowledge to handle complex data environments and deliver implementation-ready specifications.

Qualifications

• Strong experience in data modelling (conceptual, logical, physical).
• Proven capability in data analysis and source-to-target mapping.
• Advanced SQL skills for profiling, validation, and complex queries.
• Experience defining transformation logic / pseudo-code for data pipelines.
• Good understanding of data warehousing and ETL/ELT processes.
• Strong problem-solving and data debugging skills.
• Experience working in complex, multi-system data environments.
• Knowledge of PySpark, SparkSQL advantageous to the role.

Responsibilities

• Analyse complex datasets to understand structures, relationships, and data quality issues.
• Define source-to-target mappings and detailed transformation logic.
• Develop and maintain conceptual, logical, and physical data models.
• Translate requirements into clear pseudo-logic and implementation-ready specifications.
• Perform data reconciliation and variance analysis between legacy and new platforms.
• Identify and resolve data issues through structured root cause analysis.
• Support testing and validation activities during key delivery and go-live phases.
• Work closely with Data Engineers, Architects, and business stakeholders to ensure delivery of high-quality data.

Skills

Data modelling

SQL

Data analysis

Source-to-target mapping

ETL/ELT

PySpark / SparkSQL

Data governance

Problem solving

Tools

PySpark

SparkSQL

Job description

Must-Have** We are looking for a highly capable Data Analyst / Data Modeler contractor to support a major enterprise data transformation programme, the Data Integration Hub (DIH).

This role sits within a high-performing Data Architecture & Engineering function and will play a key part in delivering clean, reconciled, and business-ready data into our analytical platforms.

You will work at the heart of the programme, bridging business requirements, data modelling, and engineering delivery.

• Strong experience in data modelling (conceptual, logical, physical)
• Proven capability in data analysis and source-to-target mapping
• Advanced SQL skills for profiling, validation, and complex queries
• Experience defining transformation logic / pseudo-code for data pipelines
• Good understanding of data warehousing and ETL/ELT processes
• Strong problem-solving and data debugging skills
• Experience working in complex, multi-system data environments
• Knowledge of PySpark, SparkSQL advantageous to the role

Good-to-Have

• A hands-on, detail-oriented data specialist who thrives in complex environments
• Someone who can bridge business and engineering with clarity and structure
• Strong communicator, comfortable working with distributed teams within Data Architecture & Engineering function and across external functions
• Experience in data reconciliation, quality, and governance-driven programmes is highly desirable

SN Responsibility of / Expectations from the Role

• Analyse complex datasets to understand structures, relationships, and data quality issues
• Define source-to-target mappings and detailed transformation logic
• Develop and maintain conceptual, logical, and physical data models
• Translate requirements into clear pseudo-logic and implementation-ready specifications
• Perform data reconciliation and variance analysis between legacy and new platforms
• Identify and resolve data issues through structured root cause analysis
• Support testing and validation activities during key delivery and go-live phases
• Work closely with Data Engineers, Architects, and business stakeholders to ensure delivery of high-quality data