AWS Data Engineer- Redshift, ETL, Python
Long Term contract
Toronto, ON - Hybrid
Key Responsibilities:
- Develop, and optimize complex SQL queries and stored procedures for high-performance data processing and transformation.
- Build and maintain scalable ETL/ELT pipelines on AWS using services such as Glue, Lambda, S3, Athena, Redshift, Kafka, Airflow, and Step Functions.
- Implement and maintain data integration solutions from various data sources into a centralized data lake or data warehouse.
- Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver reliable solutions.
- Monitor and troubleshoot data pipelines to ensure data accuracy, timeliness, and reliability.
- Apply data governance and security best practices in all development work.
Skills Required: Expert-level proficiency in SQL, including performance tuning, writing complex joins, and stored procedures in databases.
- Experience with AWS Data Engineering tools
- AWS Glue
- Amazon Redshift
- AWS Lambda
- Amazon S3
- Athena
- Kafka
- Step Functions
- Experience with data modeling, ETL orchestration, and data pipeline development in AWS.
- Familiarity with version control systems (e.g., Git) and CI/CD for data workflows.
- Airflow
- Experience with Python and PySpark
Pay: $45.00-$50.00 per hour
Work Location: Hybrid remote in Toronto, ON (Toronto District)
