Senior Data Engineer - IICS & Redshift

Compassx; United States; Hybrid; USD 200,579,000 - 343,849,000; Full time

Job summary

CompassX is a boutique data and technology consulting firm helping clients move data into actionable insights. This role is a short-term, project-based engagement for an experienced independent contractor, focused on building and maintaining ETL/ELT pipelines and data models in a pharma context.

You’ll work with IICS, Amazon Redshift, SQL, Python, and Power BI, collaborating with stakeholders while delivering high-quality data solutions and maintainable pipelines in an agile environment.

Qualifications

• Hands-on data integration and warehousing experience in a pharma or life sciences context preferred.
• Experience with IICS (Informatica Intelligent Cloud Services) for data integration.
• Strong SQL and ETL/ELT design skills.

Responsibilities

• 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.
• Collaborate with client stakeholders and the CompassX team to translate technical work into business context.

Skills

Strong communication

Problem solving

Self-directed

Tools

IICS

Amazon Redshift

Power BI

Python

SQL

AWS

Veeva

Job description

CompassX is a boutique data and technology consulting firm helping clients move data into actionable insights. This role is a short-term, project-based engagement for an experienced independent contractor, focused on building and maintaining ETL/ELT pipelines and data models in a pharma context.

You’ll work with IICS, Amazon Redshift, SQL, Python, and Power BI, collaborating with stakeholders while delivering high-quality data solutions and maintainable pipelines in an agile environment.