Senior Data Engineer

Tata Consultancy Services; Irving (TX); On-site; USD 120,000 - 130,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage: Medical & Health, +

Family Leaves

Auto & Home Insurance

Commuter Benefits

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services in Irving, Texas is seeking a data-focused engineer to design and optimize relational database solutions using SQL Server and Azure SQL, develop ETL/ELT processes, and build scalable data pipelines.

The role requires strong T-SQL, Python, Databricks/Spark, and experience in Azure, with collaboration across data science, BI, and engineering teams. Authorization to work in the United States without sponsorship is required.

Qualifications

• Experience developing and supporting database solutions using SQL Server/Azure SQL.
• Strong proficiency in T-SQL including query development and tuning.
• Hands-on Python for data processing and analytics workflows.
• Experience with Databricks or Apache Spark.
• Understanding of data warehousing, dimensional modeling, and ETL/ELT.
• Experience with Azure cloud environments.
• Proficiency in .NET/C#, Angular, and AI/ML preferred.
• Strong analytical, problem-solving, and communication skills.
• US work authorization now and in the future.

Responsibilities

• Design, build, test, and optimize relational database solutions using SQL Server and Azure SQL, including T-SQL queries, stored procedures, and data models.
• Improve database performance and scalability through indexing and query tuning.
• Develop and maintain scalable ETL/ELT processes to integrate data across cloud platforms.
• Build data pipelines using Azure SQL, Databricks, Spark, Python, and PySpark.
• Design and implement relational and dimensional data models, including SCD patterns.
• Support AI/ML initiatives by developing data pipelines and feature datasets.
• Collaborate with data science teams to operationalize models using Spark/ML services.
• Participate in design reviews, code reviews, and Agile ceremonies.
• Partner with developers, data engineers, BI teams to deliver integrated solutions.
• Troubleshoot production issues and implement sustainable resolutions.
• Adhere to data governance, security, and quality standards.

Skills

SQL/Azure SQL

T-SQL

Python

Databricks/Spark

Data warehousing/ETL

Azure Cloud

AI/ML

Analytical skills

Communication skills

US work authorization

Education

BACHELOR OF COMPUTER SCIENCE

Tools

Databricks

Apache Spark

Azure SQL

PySpark

.NET/C#/Angular

Job description

Job Description

Must Have Technical/Functional Skills

• Experience developing and supporting database solutions using SQL Server or Azure SQL required.
• Strong proficiency in T-SQL, including query development, performance tuning, and optimization required.
• Hands-on experience using Python for data processing, analytics, or data engineering workflows required.
• Experience with Databricks, Apache Spark, or similar distributed data processing platforms required.
• Understanding of data warehousing concepts, dimensional modeling, and ETL/ELT pipelines required.
• Experience working in Azure cloud environments required.
• Experience with .Net, C#, .Net Core, Angular and AI/ML preferred.
• Strong analytical, problem-solving, and written and verbal communication skills.
• You must be authorized to work in the United States without sponsorship now and in the future.

Roles & Responsibilities

• Design, build, test, and optimize relational database solutions using SQL Server and Azure SQL, including T-SQL queries, stored procedures, and data models.
• Improve database performance, reliability, and scalability through indexing strategies, query tuning, and optimization techniques.
• Develop and maintain scalable Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes to integrate data across cloud-based platforms.
• Build and support data pipelines and workflows using Azure SQL, Databricks, Apache Spark, Python, and PySpark.
• Design and implement relational and dimensional data models, including Slowly Changing Dimension (SCD) patterns.
• Support AI/ML initiatives by developing and maintaining data pipelines and feature datasets used for model training and analytics.
• Utilize Python to enable data preparation, analytics workflows, and experimentation for machine learning use cases.
• Collaborate with data science teams to operationalize models using Spark, ML frameworks, or cloud-based ML services.
• Participate in design discussions, code reviews, and Agile ceremonies to ensure high-quality and maintainable solutions.
• Partner with application developers, data engineers, BI teams, and analytics partners to deliver integrated solutions.
• Troubleshoot production issues, conduct root cause analysis, and implement sustainable resolutions.
• Adhere to data governance, security, and quality standards to ensure compliance and data integrity.

Salary Range: $120,000 -$130,000 year

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.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Qualifications:

BACHELOR OF COMPUTER SCIENCE