Data Engineer (AWS, Snowflake, Pyspark, SQL)

Tata Consultancy Services Ltd

Auburn Hills, MI

JOB DETAILS
SALARY
$90,000–$110,000 Per Year
SKILLS
Access Control, Agile Programming Methodologies, Amazon Elastic Compute Cloud (EC2), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Apache, Cloud Computing, Cryptography, Customer Relations, Data Analysis, Data Management, Data Modeling, Data Science, Data Warehousing, Database Administration, Database Design, Database Extract Transform and Load (ETL), Develop and Maintain Customers, Dimensional Modeling, Electronic Medical Records, Git, Identify Issues, Information/Data Security (InfoSec), Legal, Loan Funding, Mentoring, Microsoft Windows Azure, Needs Assessment, Problem Solving Skills, Programming Languages, Python Programming/Scripting Language, SQL (Structured Query Language), Scrum Project Management and Software Development, Snowflake Schema, Source Code/Configuration Management (SCM), Sprint Planning, Star Schema, Student Loans, Time Management
LOCATION
Auburn Hills, MI
POSTED
30+ days ago

Must Have Technical/Functional Skills

  • Programming Languages: Proficient in SQL, Pyspark, Python
  • Data Pipeline & ETL: Proficiency in building ETL/ELT pipelines using tools like Apache Airflow, AWS EC2, EMR, S3, dbt, Azure Data factory
  • Database Management: Expertise in data warehousing solutions like Snowflake or Redshift, Databricks
  • Cloud Platforms: Working knowledge of cloud providers (AWS) is essential.
  • Data Modeling: Designing efficient schemas (star/snowflake) for dimensional modelling and semantic models for Visualization tools
  • Data Governance & Security: Implementing data encryption, masking, and role-based access control.
  • Problem-Solving & Troubleshooting: Identifying bottlenecks in data workflows and creating scalable, robust solutions.
  • Collaboration: Working with data scientists and analysts to understand business needs and deliver actionable data.
  • Version Control: Using tools like Git for managing code for data pipelines.

Roles & Responsibilities

  • Designing and implementing through data architecture strategies
  • Analyzing complex issues to create innovative solutions
  • Upholding standards in project deliverables
  • Developing a thorough understanding of the business environment
  • Managing and navigating complex scenarios effectively
  • Building and maintaining excellent client relationship
  • Enhancing personal brand and technical skills
  • Mentoring and guiding junior team members
  • Implementing end to end solutions catering to the business requirements

Generic Managerial Skills, If any

  • Track the deliverables assigned and deliver on time with great quality
  • Participation in Scrum calls and sprint planning and agile ceremonies
  • Offshore coordination

Base Salary Range: $90,000 - $110,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.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

#LI-SV2

#LI-KUMARAN

About the Company

T

Tata Consultancy Services Ltd