Senior AWS Data Engineer – ETL & Data Warehouse (Redshift)

Compensation & LocationLocation: Torrance, CAPay Range: $63.00 – $70.00 per hour (based on experience and internal equity)Schedule: Full-time, contract; long-term opportunityWork Type: 4 days per week on-site (Fridays remote)Benefits: Health, Vision, Dental, Life Insurance, 401k, Continuing and on-demand education📍 Must be willing to work onsite in Torrance, CA (LA County)✅ Sponsorship is available for this role‼️ ONLY W2 – NO CORP to CORP – NO 3rd PartiesPosition OverviewWe are seeking a Senior AWS Data Engineer to design, build, and optimize scalable data pipelines and cloud-based data platforms within an enterprise environment.This role will focus on ETL/ELT development, serverless architecture, and data warehouse optimization using AWS services such as Glue, Lambda, Redshift, and DMS, supporting business intelligence and data-driven initiatives.Key ResponsibilitiesData Engineering & Pipeline Development• Design and implement scalable ETL/ELT pipelines using AWS Glue with PySpark for large-scale data processing• Develop and maintain server-less integrations using AWS Lambda for event-driven workflows• Implement data ingestion and integration pipelines across multiple systemsData Warehouse & Analytics• Design, develop, and optimize Amazon Redshift data warehouse solutions• Perform performance tuning, build stored procedures, and support advanced SQL analytics• Analyze data quality, transformation logic, and query performanceCloud Architecture & Integrations• Implement secure vendor file transfer and ingestion solutions using AWS Transfer Family• Design and execute database migration and replication pipelines using AWS DMS• Build orchestration workflows using Apache Airflow or similar toolsCollaboration, Compliance & Support• Collaborate with enterprise architecture, security, and compliance teams to meet SOX and regulatory requirements• Guide development teams on AWS best practices for performance, scalability, and cost optimization• Troubleshoot production data pipelines and resolve integration issues across AWS services• Support BI environments and data platform operationsRequired Qualifications• Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or related field (or equivalent experience)• 10+ years of experience building data platforms or data engineering solutions• 8+ years of hands-on experience with AWS cloud services• Strong experience with AWS Glue and PySpark for ETL processing• Hands-on experience developing serverless applications using AWS Lambda• Deep experience with Amazon Redshift, including performance tuning and SQL analytics• Experience implementing workflow orchestration using Apache Airflow or similar tools• Experience with AWS DMS for data migration and replication• Strong SQL skills with experience writing complex queries• Knowledge of AWS security, IAM policies, encryption, and compliance standards• Strong troubleshooting, problem-solving, and analytical skillsPreferred Qualifications• Experience working in financial services or regulated environments• Experience implementing secure vendor integrations using AWS Transfer Family• 3+ years of Big 4 consulting experience• Stable work history within large enterprise organizations