Design and build high-performance SQL and Python data pipelines across PostgreSQL, BigQuery, Snowflake, and MongoDB. Implement RisingWave streaming and Kafka architectures, orchestrate workflows with Airflow on GCP, enforce data quality, deploy CI/CD for pipelines, and mentor teammates while collaborating with business stakeholders.
Charger logistics Inc. is a world- class asset-based carrier with locations across North America. With over 20 years of experience providing the best logistics solutions, Charger logistics has transformed into a world-class transport provider and continue to grow.
Charger logistics invests time and support into its employees to provide them with the room to learn and grow their expertise and work their way up. We are seeking a Data Engineer with expertise in SQL, Python, DBT and RisingWave to join our modern data team.
Responsibilities:
- Design high-performance SQL pipelines across PostgreSQL, BigQuery, Snowflake, and MongoDB.
- Develop Python applications for data ingestion, transformation, and automation.
- Implement RisingWave streaming pipelines for real-time analytics.
- Build Apache Kafka architectures for high-throughput data processing.
- Orchestrate workflows using Apache Airflow on Google Cloud Platform.
- Optimize queries and implement data quality checks across multiple platforms.
- Mentor team members and collaborate with business stakeholders.
- Deploy CI/CD workflows using Git for reliable pipeline management.
Requirements
Required Qualifications:
- Bachelor's degree in Computer Science, Engineering, or related field.
- 5+ years of data engineering experience with SQL, Python, and RisingWave.
- Must have AlloyDB and CDC experience (DataStream/Debezium)
- Expert DBT skills across Big Query, Snowflake and AlloyDB.
- Expert SQL skills: CTEs, window functions, optimization across PostgreSQL, BigQuery, Snowflake.
- Advanced Python: pandas, sqlalchemy, API integration, streaming data processing.
- Production experience with Apache Kafka, Apache Airflow, and Google Cloud Platform.
- Experience with MongoDB, dimensional modeling, and both batch/streaming ETL pipelines.
- Strong Git and collaborative development experience.
Technical Skills:
- Core: SQL (advanced), Python, RisingWave (required).
- Cloud: Google Cloud Platform, BigQuery, GCP native services.
- Streaming: Apache Kafka, real-time data processing.
- Orchestration: Apache Airflow (production experience).
- Databases: PostgreSQL, Snowflake, MongoDB.
- Tools: Git, Docker, CI/CD pipelines.
Preferred Qualifications:
- GCP certifications, Terraform/CloudFormation experience.
- previous experience with RisingWave is strongly preferred
- Data visualization tools (Looker, Tableau, Power BI).
- DataOps and analytics engineering best practices.
- ClickHouse experience is preferred
What You'll Build:
- Scalable SQL pipelines across multiple database systems.
- Python-based ETL/ELT solutions spanning cloud and on-premise.
- Real-time streaming pipelines using RisingWave and Kafka.
- GCP-native data solutions with automated quality checks.
- Airflow-orchestrated workflows with CI/CD deployment.
Benefits
- Competitive Salary
- Healthcare Benefits Package
- Career Growth
Charger Logistics Brampton, Ontario, CAN Office
25 Production Road, Brampton, Ontario, Canada, L6T4N8
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Principal Data Engineer, you will design and implement LLM, AI-powered security data platforms, mentor engineers, and drive the adoption of data solutions across teams.
Top Skills:
AirflowAWSBigQueryDaskDockerFlinkGCPKafkaKubeflowKubernetesLangchainLlamaindexMlflowMlops ToolsOciPulsarPythonSagemakerSnowflakeSparkVertex Ai
Artificial Intelligence • Information Technology • Internet of Things • Social Impact • Software
Build and maintain integrations and data pipelines connecting client databases, APIs, and SaaS tools. Extract, clean, transform, and move messy real-world data to feed retrieval and agentic AI systems, apply security and privacy best practices, and document reproducible integrations.
Top Skills:
AiderAPIsClaude CodeCursorData PipelinesETLFirebaseGitGitGithub CopilotMakeMcpN8NNode.jsNotionPostgresPythonSQLSupabaseWebhooksWindsurfZapier
Fintech • Insurance • Financial Services
Design, build, and maintain complex data models, ETL pipelines, ingestion workflows, metadata and lineage. Perform data profiling, quality checks, documentation, and collaborate with stakeholders to support testing, deployment, and governance across platforms.
Top Skills:
AzureAzure SynapseData LakeDatabricksETLPysparkPython
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
