Senior Data Engineer – IICS, Redshift

CompassX Group

. Design, build, and maintain ETL/ELT pipelines using IICS to integrate data from source systems into the warehouse .

Posted 9/19/2026contractRemote • United StatesSenior💰 $60 - $75 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining ETL/ELT pipelines using IICS and Amazon Redshift, with strong SQL and Python skills for data transformation and automation. Proven ability to build Power BI data models and ensure data quality in a pharma environment through effective collaboration with stakeholders.

Highest-signal resume keywords

IICS (Informatica Intelligent Cloud Services)Amazon RedshiftSQLPythonPower BI Data Modeling

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL/ELT Pipeline DesignData IntegrationData Quality ChecksData Validation LogicData Modeling Best Practices

Soft Skills

Strong Communication SkillsCollaboration with StakeholdersAutonomous Work

Tools & Technologies

Power BIAWSOracle EBSOracle Cloud

Industry Keywords

PharmaLife SciencesData Infrastructure

Tech Stack

Tools & technologies

Amazon RedshiftAWSCloudETLInformaticaOraclePythonReactSQL

About the role

Key responsibilities & impact

Design, build, and maintain ETL/ELT pipelines using IICS to integrate data from source systems into the warehouse
Develop and optimize data models and structures within Amazon Redshift
Write production-quality SQL and Python to transform, validate, and automate data workflows
Build and support Power BI data models that feed reporting and dashboards for business stakeholders
Implement data quality checks and validation logic to ensure accuracy and traceability across pipelines
Document data flows, models, and pipeline logic to support handoff and long-term maintainability
Work closely with client-side stakeholders as well as the CompassX team, translating technical work into business context
Collaborate with a small group of engineers and analysts, working autonomously while staying tightly aligned with the team
Build and enhance a custom React application integrated with Oracle EBS or Oracle Cloud backend systems

Requirements

What you’ll need

Hands-on experience with IICS (Informatica Intelligent Cloud Services) for data integration
Experience working with Amazon Redshift as a data warehouse platform
Strong SQL skills and solid grounding in ETL/ELT pipeline design
Proficiency in Python for data engineering workflows
Experience building Power BI data models, ideally including a strong grasp of data modeling best practices for reporting layers
Comfort working with cloud-based data infrastructure (AWS preferred, given the Redshift environment)
An eye for data quality and validation — this is a pharma environment, so accuracy and traceability matter
Strong communication skills, with experience collaborating directly with client stakeholders
Bonus: familiarity with Veeva, particularly in a pharma or life sciences context
Ability to work independently in a senior-level contract role
Independent contractor engagement through the end of the year on a 1099 basis