Senior Data Engineer

Senior Data EngineerWe are seeking an experienced AWS Data Engineer with expertise in ETL processes, AWS Lambda, Redshift, and proficiency in Python and PySpark. This role requires hands-on experience with cloud-based architecture, data engineering, and working with large-scale data processing systems. The ideal candidate will play a critical role in building and maintaining scalable, efficient, and secure ETL pipelines within the AWS ecosystem.Key Responsibilities:Design, develop, and maintain robust ETL workflows to extract, transform, and load data from various sources to AWS Redshift and other cloud-based systems.Leverage AWS Lambda to build serverless computing solutions for real-time data processing and automation.Work with AWS data storage and processing services, including S3, Redshift, Athena, and Glue, to support data processing pipelines.Utilize Python and PySpark to create and optimize data transformation logic and analytical queries.Collaborate with cross-functional teams to understand data requirements and provide efficient data solutions.Monitor and optimize cloud-based infrastructure for performance, reliability, and cost efficiency.Troubleshoot and resolve data pipeline issues, ensuring minimal downtime and high data accuracy.Implement automation and monitoring tools to enhance reliability.Required Skills and Qualifications:Proven experience working with AWS services, including Lambda, Redshift, S3, Athena, Glue, and CloudWatch.Strong knowledge and hands-on experience with Python and PySpark for data transformation and processing.Expertise in building and optimizing ETL pipelines in a cloud environment.In-depth understanding of relational databases, data warehousing, and performance tuning in Redshift.Strong problem-solving and troubleshooting skills.Familiarity with infrastructure as code tools like AWS CloudFormation.Experience with version control (e.g., Git) and CI/CD pipelines.Solid understanding of data security, data privacy, and compliance frameworks.Ability to work in an agile, fast-paced environment.Skills: Digital: Python~Digital: Amazon Web Service (AWS) Cloud Computing~Digital: PySpark~Core JavaExperience Required: 10 & AboveAbout the companyAvance Consulting is a global leader in innovative talent solutions for diverse industries. Since 2007, we have been serving nearly a third of Fortune 500 companies and most of the top 100 technology companies worldwide.Our team of 700+ experts offers Engineering Services, Information Technology, Digital and Executive Search solutions from our offices in North America, UK, Europe and APAC.We understand the local markets and cultures and tailor our services to meet the needs of our clients. Our clients value our flexibility and agility, which enable us to deliver high-quality results at any scale across the globe.This allows us to work with numerous industries at varying scale across the globe while ensuring the excellent service standard that our clients have come to expect.At Avance you can learn new skills and technologies, have more advancement opportunities and career growth, being a part of our productive atmosphere, and a positive reinforcement culture.