Lead Data Engineer

Job summary

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.

Job details

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.

What you’ll do

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.

Listed skills

• SQL · Preferred
• Communication · Preferred
• Troubleshooting · Preferred
• Root Cause Analysis · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• 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

Job areas

• Data & Analytics
• Technology
• Software
• Engineering

More jobs from Iris Software Inc.