Senior Data Engineer (IICS & Redshift) (Independent Contractor)

What You'll Do

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

What You'll Bring

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