*Job Summary* We are seeking a highly skilled and motivated Data Engineer to design, develop, and maintain scalable data pipelines and cloud-based data solutions on AWS. The ideal candidate will have experience building ETL/ELT processes, managing large datasets, optimizing data warehouses, and developing serverless data integration solutions. The role requires strong programming skills in Python, experience with AWS analytics services, and the ability to work closely with business stakeholders, and data analysts. *Key Responsibilities* * Design, build, and maintain automated ETL/ELT pipelines using AWS Glue, orchestrated via EventBridge (scheduled rules and event-driven triggers) * Provision, configure, and manage EC2 instances for data processing tasks that fall outside Glue's scope (custom scripts, scheduled jobs, batch workloads). * Build and manage serverless data processing workflows using AWS Lambda and AWS Glue. * Develop Python applications for data extraction, transformation, validation, and loading. * Create and optimize SQL queries against Amazon Athena and Amazon Redshift for reporting and analytics. * Monitor, troubleshoot, and optimize data pipelines to ensure reliability and performance. * Implement data quality checks, validation, and error handling throughout the data lifecycle. * Reduce Athena costs through partitioning, columnar formats (Parquet), and query …