Data Engineer
- Montreal, QC, Canada
$65 to $70 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $65 to $70 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Pay Range: CAD 65-70/hr
Required Technical Skills
- Strong hands-on experience in Python programming, including Pandas, NumPy, and data processing libraries.
- Strong experience with PySpark for distributed data processing and large-scale data transformation.
- Extensive knowledge of SQL, including complex queries, joins, CTEs, window functions, and query optimization.
- Hands-on experience in ETL/ELT development, data integration, data migration, and pipeline orchestration.
- Strong experience with Snowflake, including Snowflake SQL, virtual warehouses, stages, streams, tasks, and Snowpipe.
- Good understanding of relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL.
- Experience in data warehousing concepts, dimensional modeling, fact and dimension tables, and schema design.
- Understanding of batch processing, incremental loads, data validation, and error handling.
- Experience with Git, version control, debugging, and code deployment.
Preferred Skills
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Knowledge of AWS S3, Azure Data Lake, or similar cloud storage solutions.
- Experience with Apache Spark, Databricks, Apache Airflow, or Azure Data Factory.
- Understanding of CI/CD pipelines and automated deployment processes.
- Exposure to Kafka, real-time data processing, and streaming architectures.
- Knowledge of data governance, metadata management, and data lineage.
More about this job
Responsibilities
Develop and maintain data processing and transformation solutions using Python, PySpark, SQL, and Snowflake. Build and orchestrate ETL/ELT pipelines, support data integration and migration, and implement data warehousing, validation, and error-handling practices.
Requirements
Requires strong hands-on experience with Python data-processing libraries, PySpark, complex SQL, ETL/ELT development, and Snowflake. Candidates should also understand relational databases, data warehousing and dimensional modeling, batch and incremental processing, and version control; cloud, orchestration, CI/CD, streaming, and data governance experience are preferred.
Skills
- Python
- Pandas
- NumPy
- PySpark
- SQL
- ETL/ELT Development
- Data Integration
- Data Migration
- Pipeline Orchestration
- Snowflake
- Data Warehousing
- Dimensional Modeling
- Batch Processing
- Git
- Cloud Platforms
- Apache Airflow
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- Python
- Pandas
- NumPy
- PySpark
- SQL
- ETL/ELT
- Data Integration
- Data Migration
- Pipeline Orchestration
- Snowflake
- Snowflake SQL
- Virtual Warehouses
- Stages
- Streams
- Tasks
- Snowpipe
- SQL Server
- Oracle
- PostgreSQL
- MySQL
- Data Warehousing
- Dimensional Modeling
- Fact And Dimension Tables
- Batch Processing
- Incremental Loads
- Git
- AWS
- Azure
- Google Cloud Platform
- Apache Spark