Lead Data Engineer
Summary
Iris Software is hiring a Lead Data Engineer to serve its Fortune 100 insurance client in Mississauga. Day to day, the lead designs and maintains scalable ETL/ELT pipelines and warehouse models using SQL, Python, Snowflake, dbt, and Airflow, ensuring data quality for enterprise analytics.
Iris's Fortune 100 direct client is looking for Lead Data Engineer.
Position: Lead Data Engineer
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.