Senior Data Engineer — Cloud Pipelines & Analytics

ODAIA; Mississauga; On-site; CAD 80,000 - 100,000; Full time

Job summary

A prominent insurance organization in Mississauga is seeking a Data Engineer to design and develop enterprise-grade data pipelines, lead cloud migration initiatives, and ensure data quality and governance. The ideal candidate will have proficiency in SQL, Python, and experience with cloud platforms such as AWS or Azure. This role offers competitive pay, career growth opportunities, and a supportive work environment with flexible benefits.

Benefits

Flexible benefits

Work/life balance

Career development programs

Investment and retirement savings plans

Competitive pay

Qualifications

• Proven track record of delivering and maintaining data solutions in enterprise production environments.
• Demonstrated ability to work independently, take ownership, and drive projects to completion.
• Advanced proficiency in SQL, Python, and modern cloud-based data engineering frameworks.
• Hands-on experience with AWS, Azure, or Google Cloud Platform including native data services.
• Deep knowledge of Snowflake, BigQuery, Redshift, or similar enterprise data warehouses.
• Extensive experience with Apache Airflow, DBT, Talend, or comparable orchestration and transformation tools.
• Proven experience structuring data for Tableau, Power BI, or similar visualization platforms.
• Experience with version control, CI/CD pipelines, containerization, and infrastructure as code.
• Strong analytical thinking and troubleshooting skills with complex distributed systems.
• Excellent ability to translate technical concepts for diverse stakeholders.

Responsibilities

• Design, build, and deploy enterprise-grade data pipelines.
• Lead cloud data migration initiatives and architect cloud-based data infrastructure.
• Build and maintain ETL/ELT pipelines processing high-volume data.
• Design and develop RESTful APIs for data access and integration.
• Engineer data solutions that power real-time and batch analytics.
• Proactively identify and resolve performance bottlenecks.
• Provide technical mentorship and establish best practices.

Skills

Big Data Management

Cloud Computing

Database Development

Data Mining

Data Warehousing (DW)

ETL Processing

Quality Management

Requirements Analysis

Waterfall Model

Tools

SQL

Python

Apache Airflow

DBT

Tableau

Power BI

AWS

Azure

Google Cloud Platform

Snowflake

BigQuery

Redshift

Job description

A prominent insurance organization in Mississauga is seeking a Data Engineer to design and develop enterprise-grade data pipelines, lead cloud migration initiatives, and ensure data quality and governance. The ideal candidate will have proficiency in SQL, Python, and experience with cloud platforms such as AWS or Azure. This role offers competitive pay, career growth opportunities, and a supportive work environment with flexible benefits.