Remote Jobs RockRemote Jobs Rock

Data Specialist - R01565207

📅 May 12
Informatica IICSSnowflakeSQLETL/ELT
Apply Now

📜 Description

  • Design, develop, and maintain ETL/ELT pipelines using IICS.
  • Build scalable data models and transformations in Snowflake.
  • Ingest structured and semi-structured data from sources such as S3, APIs, and flat files.
  • Optimize Snowflake performance through clustering, micro-partitions, and query tuning.
  • Work with healthcare and life sciences datasets, including claims, patient, CRM, and commercial sales data.
  • Support data quality, governance, production deployments, troubleshooting, and CI/CD practices.

🛠️ Requirements

  • 4–8+ years of experience in data engineering.
  • Strong hands-on experience with Informatica IICS and Snowflake.
  • Advanced SQL and data transformation expertise.
  • Experience with cloud platforms such as AWS or Azure and data warehousing concepts, including SCD and star/snowflake schemas.
  • Experience handling large datasets and optimizing performance.
  • Familiarity with APIs, JSON, XML, and semi-structured data.
  • Healthcare or life sciences domain experience, including claims, specialty pharmacy, patient support programs, CRM, or commercial sales analytics.
  • Understanding of regulatory and compliance requirements; HIPAA/GxP awareness preferred.
Full job description
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
  • Trusted by Remote Workers