Data Engineer – Snowflake & dbt
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- Experience: 5+ Years
- Posting language
- English
- Posted
Original job description
Data Engineer – Snowflake & dbt
Location: Toronto, Canada (Onsite)
Experience: 5+ Years
Interview Process: Face-to-Face (F2F) Interview Required
Job Overview
We are seeking an experienced Data Engineer with strong hands-on expertise in Snowflake and dbt to design, develop, and maintain scalable, high-performance data solutions. The ideal candidate will have strong SQL and ETL/ELT skills, with the ability to build reliable data pipelines and collaborate with business and technology teams.
Key Responsibilities & Skills
- Design, develop, and maintain scalable data solutions using Snowflake and dbt. (Must Have)
- Write and optimize complex SQL queries for data extraction, transformation, validation, and performance tuning.
- Apply strong knowledge of ETL/ELT processes, data integration, and data quality management.
- Translate business and technical requirements into scalable and reliable data solutions.
- Ensure data accuracy, consistency, reliability, and performance across data pipelines.
- Understand end-to-end data architecture, including data ingestion, transformation, storage, governance, and consumption.
- Work with data modeling, data warehousing, and reporting/analytics ecosystems.
Nice-to-Have Skills
- Python programming experience.
- Prior experience in the Property & Casualty (P&C) Insurance domain.
- Exposure to data governance, data modeling, and enterprise data architecture.
Important: This is a fully onsite position in Toronto, Canada, and candidates must be available for a face-to-face interview.
More about this job
Responsibilities
Design, develop, and maintain scalable data solutions and reliable pipelines using Snowflake and dbt. Optimize SQL and ensure data accuracy, consistency, quality, and performance across data workflows.
Requirements
Candidates need 5+ years of experience and strong hands-on expertise in Snowflake, dbt, SQL, and ETL/ELT processes. The role also requires the ability to translate business and technical requirements into scalable solutions; Python and P&C insurance experience are nice to have.
Skills
- Snowflake
- dbt
- SQL
- ETL/ELT
- Data Engineering
- Data Pipelines
- Data Integration
- Data Quality Management
- Data Architecture
- Data Modeling
- Data Warehousing
- Python
- Data Governance
- Performance Tuning
- Reporting and Analytics
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- Snowflake
- dbt
- SQL
- ETL/ELT
- Data Engineering
- Data Pipelines
- Data Integration
- Data Quality
- Data Architecture
- Data Ingestion
- Data Transformation
- Data Storage
- Data Governance
- Data Modeling
- Data Warehousing
- Reporting
- Analytics
- Python
- Performance Tuning
- Property and Casualty Insurance
- Toronto