Intermediate Python Developer - Data & ETL

Our client is Canada's largest retailer. They are looking for an Int. Python Developer to support data-driven initiatives through hands-on development in Python and SQL.

This involves working on data ingestion, transformation, validation, and database integration within a cloud-based data environment.

The ideal candidate has experience as a Python Developer or Data Engineer working with large-scale datasets and is comfortable building and maintaining in ETL workflows and data pipelines.

Duration: 6 Months, to start

Location: Brampton - 2 days/week onsite

Responsibilities:

• Develop and maintain data solutions using Python and SQL.
• Build and support ETL processes including:
• File ingestion
• Data cleansing and transformation
• Data validation
• Loading data into databases and APIs
• Connect to and interact with databases using Python (API clients, database connectors, data processing libraries)
• Query and analyze data in PostgreSQL and BigQuery
• Modify and optimize existing data scripts and contribute to new development
• Perform data reconciliation and troubleshooting across multiple data sources
• Support consent management and real-time data workflows
• Collaborate with stakeholders to understand data requirements and deliver scalable solutions

Must Have Skills:

• 5+ years of experience in Python Development or Data Engineering
• Strong Python for Data Manipulation, API Integration, and ETL Development
• Advanced SQL skills for querying, analysis, and troubleshooting
• Experience working in Cloud environments (GCP preferred: AWS or Azure acceptable)
• Experience building and maintaining ETL/Data Pipeline processes