✦Role summaryAI-generated
This Lead Data Engineer will design, develop, and maintain ETL/ELT pipelines using IICS and Snowflake for Healthcare and Life Sciences data. They will build scalable data models and transformations, leveraging SQL, Python, and modern data platform fundamentals to support commercial, patient, clinical, or real-world data use cases.
About this role
Consultant
Primary Skills
ETL Fundamentals, SQL, SQL (Basic + Advanced), Alation, Talend, Python, Data Warehousing, IICS, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
ETL Specialization: Senior Data Engineer
Job requirements
Job Title: Data Engineer – IICS & Snowflake (Healthcare / Life Sciences) Role Summary We are seeking an experienced Data Engineer with strong expertise in Informatica Intelligent Cloud Services (IICS) and Snowflake, along with domain knowledge in Healthcare & Life Sciences (HLS). The ideal candidate will design, build, and optimize scalable data pipelines supporting commercial, patient, clinical, or real-world data use cases. Key Responsibilities Design, develop, and maintain ETL/ELT pipelines using IICS Build scalable data models and transformations in Snowflake Implement data ingestion from structured and semi-structured sources (S3, APIs, flat files, etc.) Optimize Snowflake performance (clustering, micro-partitions, query tuning) Work with HLS datasets (claims, patient data, CRM, commercial sales, specialty pharmacy, etc.) Ensure data quality, governance, and compliance (HIPAA/GxP awareness preferred) Collaborate with business stakeholders for requirement gathering and solution design Support production deployments, troubleshooting, and performance tuning Implement CI/CD and version control best practices Required Skills Technical: 4–8+ years of experience in Data Engineering Strong hands-on experience with Informatica IICS (CAI/CDI/MDM preferred) Strong Snowflake experience (SQL, performance tuning, data modeling) Advanced SQL and data transformation expertise Experience with cloud platforms (AWS/Azure preferred) Understanding of data warehousing concepts (SCD, Star/Snowflake schema) Experience handling large datasets and performance optimization Familiarity with APIs, JSON, XML, and semi-structured data Domain (HLS): Experience working in Healthcare or Life Sciences domain Understanding of: Claims data (Komodo, IQVIA, Symphony, etc.) Specialty pharmacy / Patient Support Programs (PSP) CRM (Veeva/SFDC) Commercial sales analytics Regulatory/compliance requirementsSimilar open roles
On-siteStaffData Engineer
On-siteJuniorData Engineer
HybridSeniorData Engineer
$135k – $150k USD
On-siteSeniorData Engineer
SK
Shaqeeq Khan·Built this board, coached engineers from Netflix, Google, IBM, Amazon. 100+ grads placed.
CV ReviewLive One on One CallsStrategy