Azure Data Architect: Lakehouse & ERP Data Engineer

Tata Consultancy Services Limited; 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

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.