Back to results

Lead Data Engineer

  • Mississauga, ON, Canada

Contract

Applications open in a new tab.

Job details

Job type
Contract
Apply by
Experience
5-8 years of hands-on experience as a Data Engineer with strong expertise in SQL and Python for data processing, transformation, and analytics.
Posting language
English
Posted

Original job description

Iris's Fortune 100 direct client is looking for Lead Data Engineer. Please find below Job description and share me your updated resume at Saurav.upadhyay@irissoftware.com .

Position: Lead Data Engineer

Location: Mississauga Ontario

Key Responsibilities:

  • 5-8 years of hands-on experience as a Data Engineer with strong expertise in SQL and Python for data processing, transformation, and analytics.
  • Mandatory experience working in the Insurance domain, with a solid understanding of insurance data, reporting, and business processes.
  • Extensive experience with cloud-based data platforms, preferably Snowflake, including data ingestion, transformation, and optimization.
  • Design, develop, and maintain scalable ETL/ELT pipelines to support enterprise-wide data integration and analytics initiatives.
  • Strong experience in developing and optimizing Stored Procedures, Tasks, and dbt models for efficient data transformation workflows.
  • Expertise in data warehouse design, dimensional modeling, and implementing scalable data architecture solutions.
  • Hands-on experience with workflow orchestration tools such as Airflow or equivalent platforms for scheduling and monitoring data pipelines.
  • Build and support high-performance, reliable, and secure data solutions that meet business and regulatory requirements.
  • Collaborate closely with Data Architects, Business Analysts, and stakeholders to understand requirements and deliver data-driven solutions.
  • Perform data quality validation, troubleshooting, and root cause analysis to ensure data accuracy and consistency across systems.
  • Strong analytical and problem-solving skills with the ability to identify opportunities for process improvement and automation.
  • Excellent communication and cross-functional collaboration skills, with the ability to effectively engage technical teams and business stakeholders across large-scale programs.

About Iris Software Inc.

With 4,000+ associates and offices in India, U.S.A. and Canada, Iris Software delivers technology services and solutions that help clients complete fast, far-reaching digital transformations and achieve their business goals. A strategic partner to Fortune 500 and other top companies in financial services and many other industries, Iris provides a value-driven approach - a unique blend of highly-skilled specialists, software engineering expertise, cutting-edge technology, and flexible engagement models. High customer satisfaction has translated into long-standing relationships and preferred-partner status with many of our clients, who rely on our 30+ years of technical and domain expertise to future-proof their enterprises. Associates of Iris work on mission-critical applications supported by a workplace culture that has won numerous awards in the last few years, including Certified Great Place to Work in India; Top 25 GPW in IT & IT-BPM; Ambition Box Best Place to Work, #3 in IT/ITES; and Top Workplace NJ-USA.

More about this job

Responsibilities

Design, develop, and maintain scalable data pipelines and cloud-based data solutions, including Snowflake transformations, stored procedures, tasks, and dbt models. Collaborate with architects, analysts, and stakeholders to deliver secure, reliable data solutions and ensure data quality, accuracy, and regulatory compliance.

Requirements

Requires 5–8 years of hands-on data engineering experience, strong SQL and Python skills, and mandatory experience in the insurance domain. Candidates should have experience with Snowflake or similar cloud data platforms, ETL/ELT, data modeling, dbt, and Airflow or equivalent orchestration tools, along with strong analytical and communication skills.

Skills

  • SQL
  • Python
  • Insurance Domain Knowledge
  • Snowflake
  • ETL/ELT Pipelines
  • Stored Procedures
  • Tasks
  • dbt
  • Data Warehouse Design
  • Dimensional Modeling
  • Data Architecture
  • Airflow
  • Data Quality Validation
  • Troubleshooting
  • Root Cause Analysis
  • Communication

Visa sponsorship

Not detected in the job text

Hiring contact email

Saurav.upadhyay@irissoftware.com

Categories

  • Data & Analytics
  • Technology
  • Software
  • Engineering

Keywords

  • Data Engineering
  • SQL
  • Python
  • Insurance
  • Insurance Data
  • Snowflake
  • Cloud Data Platforms
  • Data Ingestion
  • Data Transformation
  • ETL
  • ELT
  • Data Pipelines
  • Stored Procedures
  • Tasks
  • dbt
  • Data Warehousing
  • Dimensional Modeling
  • Data Architecture
  • Airflow
  • Workflow Orchestration
  • Data Quality
  • Data Integration
  • Analytics
  • Regulatory Requirements
  • Root Cause Analysis

Report this job