Data Engineer (AWS, Snowflake, Pyspark, SQL)
Role summary
We are seeking a Data Engineer with expertise in AWS, Snowflake, PySpark, and SQL to join our team. The role involves designing, building, and maintaining robust data pipelines and warehousing solutions. You will be responsible for ETL/ELT processes, data modeling, and ensuring data governance and security. Collaboration with data scientists and analysts is key to delivering actionable insights. This position requires strong problem-solving skills and the ability to work effectively in an Agile environment. The role also includes mentoring junior team members and coordinating with offshore teams.
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
Location
Auburn Hills, MI
Job Function
TECHNOLOGY
Role
Engineer
Job Id
403650
Desired Skills
AWS
Salary Range
$90,000-$110,000 a year
Desired Candidate Profile
Qualifications : BACHELOR OF COMPUTER SCIENCE