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 requirements
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
Apply info ->
To apply for this job, please visit the application page
