Data Architect

Tata Consultancy Services; Edison (NJ); On-site; USD 110,000 - 125,000; Full time

Benefits offered by this job

Annual incentive

Medical coverage

Parental leaves

Insurance options

Commuter benefits

Certification reimbursement

401K plan

Student loan refinancing

Job summary

Tata Consultancy Services Limited in Edison, New Jersey, is seeking a data engineering architect to design and implement large-scale data lake and lakehouse solutions using Microsoft Fabric / Azure data stack. The role emphasizes ETL/ELT pipelines, Spark SQL, and governance across SAP ERP data ingestion.

You will work with data security, RBAC, Purview, and CI/CD for data pipelines, with a strong focus on attribute-level mapping, data quality, and validation.

Qualifications

• Hands-on experience in Microsoft Fabric / Azure Data Engineering stack.
• Extensive knowledge of ETL/ELT frameworks and pipeline orchestration.
• Proficient in PySpark / Spark SQL / Advanced SQL.
• Experience in Data Lake / Lakehouse / DWH concepts.
• Experience as an Architect for Data Lake / Data Warehouse implementations.
• Experience in data governance, security & access control (RBAC, Purview).
• CI/CD & DevOps for Data Engineering.
• Hands-on SAP experience and ERP data ingestion.
• Data mapping, ERP data structures, data analysis and validation.

Skills

ETL/ELT frameworks

PySpark / Spark SQL

Lakehouse concepts

Data security concepts

Data governance

CI/CD for Data Eng

ERP data ingestion

Data mapping

ERP data structures

Data analysis

Data validation techniques

Microsoft Fabric / Azure Data Eng

Pipelines / Notebooks

Tools

Purview

SAP

OneLake

Microsoft Fabric

Job description

• Strong hands-on experience in Microsoft Fabric / Azure Data Engineering stack
  • Lakehouse, OneLake, Pipelines, Notebooks
• Strong knowledge of:
  • ETL/ELT frameworks and pipeline orchestration
  • PySpark / Spark SQL / Advanced SQL
  • Data Lake / Lakehouse / DWH concepts
  • Data security (row/column level security concepts
• Strong experience in Data Lake / Data Warehouse implementations as an Architect
• Experience in data governance, security & access control (RBAC, Purview, etc.)
• Experience in CI/CD & DevOps for Data Engineering
• Hands-on experience working with SAP and multiple ERP systems (Sales & Finance modules preferred) for data ingestion
• Good understanding of:
  • Data mapping (source-to-target at attribute level)
  • ERP data structures (master & transactional data)
  • Data analysis and data validation techniques

Base Salary Range: $110,000 - $125,000 per annum

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.