Key skills
SQLETLELTData EngineeringAnalyticsBIRedshiftAirflowApache AirflowAWSServerlessLambdaIAMGluePerformance OptimizationCommunication
About this role
CALL US NOW for immediate consideration! Click Apply on Web or Apply Now to view our recruiter s contact info and reach out today, we d love to speak with you!
===
** We will NOT accept 3rd Party (C2C) Contractors **
===
JOB DETAILS:
Position:Data Engineer AWS & Cloud Data Platforms
Job Ref #:44416 - JIH5JP00004250
Duration:12+ Months (On-going Contract)
Location:HYBRID - Torrance, CA 90501
Pay Rate:$68.00 - $70.25 per hour (W2 ONLY)
HYBRID: Must be able to work ONSITE 4 days per week / HOURS: MON-FRI (40 Hours)
HIRING REQUIREMENTS:
** NOT accepting any 3rd Party C2C candidates for any reason**
** NOT accepting candidates willing to relocate (LOCAL CANDIDATES Only)**
** NOT accepting candidates who live more than 45 miles from Torrance**
RESPONSIBILITIES INCLUDE:
Design and implement scalable ETL/ELT pipelines using AWS Glue with PySpark for large-scale data processing.
Develop and maintain serverless integrations using AWS Lambda for event-driven processing and system integrations.
Design and optimize Amazon Redshift data warehouse solutions, including stored procedures, performance tuning, and advanced SQL analytics.
Lead implementation of vendor file transfer and ingestion solutions using AWS Transfer Family.
Implement database migration and replication pipelines using AWS Database Migration Service (DMS).
Design orchestration workflows using Apache Airflow or similar workflow orchestration tools.
Analyze data quality, transformation logic, and performance using SQL queries and data analysis techniques.
Guide Development team members on AWS best practices for data engineering, cost optimization, and performance optimization.
Collaborate with enterprise architecture, security, and compliance teams to ensure SOX and regulatory requirements are met.
Troubleshoot production data pipelines and integration issues across AWS services.
REQUIRED EXPERIENCE/SKILLS:
** Must have EXCELLENT written and Oral Communication skills **
** Must be able to interview in-person **
7+ years of experience building data platforms or data engineering solutions.
5+ years of hands-on experience with AWS cloud services.
Strong experience with AWS Glue using PySpark for large-scale ETL processing.
Hands-on experience developing serverless applications using AWS Lambda.
Deep experience with Amazon Redshift, including performance tuning, SQL analytics, and stored procedures.
Experience implementing workflow orchestration using Apache Airflow or similar orchestration tools.
Experience implementing secure vendor integrations using AWS Transfer Family.
Experience designing data migration and replication pipelines using AWS DMS.
Strong SQL skills and experience analyzing data using complex queries.
Knowledge of security, encryption, IAM policies, and compliance considerations in AWS environments.
Experience working in financial services or regulated environments preferred.
Strong troubleshooting, problem-solving, and data analysis capabilities.
EDUCATION: Bachelor s degree in Computer Science, Information Technology, Data Engineering, or equivalent experience.
==
==
Calance Consultant Benefits Offerings:
- EPO/PPO Medical Plans
- HMO/PPO Dental programs
- Vision - VSP (Vision Plan Summary)
- 401K Retirement vesting program (VOYA)
- Paid Bi-Weekly/Direct Deposit
- Flex Spending Plan
- Voluntary Life, AD&D, STD or LTD plans
===
** We will NOT accept 3rd Party (C2C) Contractors **
===
JOB DETAILS:
Position:Data Engineer AWS & Cloud Data Platforms
Job Ref #:44416 - JIH5JP00004250
Duration:12+ Months (On-going Contract)
Location:HYBRID - Torrance, CA 90501
Pay Rate:$68.00 - $70.25 per hour (W2 ONLY)
HYBRID: Must be able to work ONSITE 4 days per week / HOURS: MON-FRI (40 Hours)
HIRING REQUIREMENTS:
** NOT accepting any 3rd Party C2C candidates for any reason**
** NOT accepting candidates willing to relocate (LOCAL CANDIDATES Only)**
** NOT accepting candidates who live more than 45 miles from Torrance**
RESPONSIBILITIES INCLUDE:
Design and implement scalable ETL/ELT pipelines using AWS Glue with PySpark for large-scale data processing.
Develop and maintain serverless integrations using AWS Lambda for event-driven processing and system integrations.
Design and optimize Amazon Redshift data warehouse solutions, including stored procedures, performance tuning, and advanced SQL analytics.
Lead implementation of vendor file transfer and ingestion solutions using AWS Transfer Family.
Implement database migration and replication pipelines using AWS Database Migration Service (DMS).
Design orchestration workflows using Apache Airflow or similar workflow orchestration tools.
Analyze data quality, transformation logic, and performance using SQL queries and data analysis techniques.
Guide Development team members on AWS best practices for data engineering, cost optimization, and performance optimization.
Collaborate with enterprise architecture, security, and compliance teams to ensure SOX and regulatory requirements are met.
Troubleshoot production data pipelines and integration issues across AWS services.
REQUIRED EXPERIENCE/SKILLS:
** Must have EXCELLENT written and Oral Communication skills **
** Must be able to interview in-person **
7+ years of experience building data platforms or data engineering solutions.
5+ years of hands-on experience with AWS cloud services.
Strong experience with AWS Glue using PySpark for large-scale ETL processing.
Hands-on experience developing serverless applications using AWS Lambda.
Deep experience with Amazon Redshift, including performance tuning, SQL analytics, and stored procedures.
Experience implementing workflow orchestration using Apache Airflow or similar orchestration tools.
Experience implementing secure vendor integrations using AWS Transfer Family.
Experience designing data migration and replication pipelines using AWS DMS.
Strong SQL skills and experience analyzing data using complex queries.
Knowledge of security, encryption, IAM policies, and compliance considerations in AWS environments.
Experience working in financial services or regulated environments preferred.
Strong troubleshooting, problem-solving, and data analysis capabilities.
EDUCATION: Bachelor s degree in Computer Science, Information Technology, Data Engineering, or equivalent experience.
==
==
Calance Consultant Benefits Offerings:
- EPO/PPO Medical Plans
- HMO/PPO Dental programs
- Vision - VSP (Vision Plan Summary)
- 401K Retirement vesting program (VOYA)
- Paid Bi-Weekly/Direct Deposit
- Flex Spending Plan
- Voluntary Life, AD&D, STD or LTD plans