Senior Data Engineer – IICS, Redshift
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Data Engineer building IICS, Redshift, SQL, and Python data pipelines for CompassX’s consulting clients. Supporting Power BI reporting, data quality, and pharma-sector stakeholder delivery.
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
- 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:
- 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
Similar Jobs
Data Architect
Azure Data Architect designing enterprise-scale Azure, Snowflake, and dbt data platforms for EXL. Defining architecture standards, modernization strategies, and analytics solutions.
Senior Staff Data Engineer
Senior Staff Data Engineer building scalable data infrastructure for SonderMind’s digital mental health platform. Leading pipelines, architecture, reliability, and compliance for analytics, ML, and clinical outcomes.
Mid Level Data Engineer
Mid-level Data Engineer building reliable pipelines, data models, and infrastructure for Satalia’s data science, optimization, and AI projects. Fully remote from Greece.
Data Engineer II
Data Engineer II building Kafka, Spark, and dbt data platforms for Mrsool's on-demand delivery business. Developing reliable pipelines, models, warehouses, and analytics datasets.
Lead Data Engineer
Lead Data Engineer building University of the Cumberlands’ Snowflake lakehouse and analytics infrastructure. Leading architecture, pipelines, governance, and the data engineering team.
Junior Data Engineer, MarTech Specialist – Mobile Apps
Junior Data Engineer supporting mobile app tracking, attribution, and data pipelines at Customlytics, a DACH app marketing agency. Maintaining dashboards and marketing integrations for client campaigns.
Senior Software Engineer, Data Platform
Senior Data Engineer architecting G-P’s AI-native Databricks platform. Building scalable data frameworks and streaming systems for G-P’s global employment SaaS platform.
Financial Data Engineer, AI/LLM
Financial Data Engineer building stock-market data infrastructure for Binance’s blockchain ecosystem. Developing Flink pipelines and reliable datasets for trading products and AI applications.
Senior Product Manager – Data Platform, Web3
Senior Product Manager owning Trust Wallet’s global Web3 data platform roadmap. Leading on-chain data ingestion, token data governance, and analytics products.
Associate Director, Site Engineering – Data Center Construction
Associate Director managing RFIs, design coordination, and governance for Turner & Townsend’s large-scale data center construction programs. Supporting multidisciplinary teams, reporting, and issue resolution.
Data Engineer
Data Engineer diseñando pipelines y arquitecturas de datos AWS para ARKHO, especializada en transformación digital, analítica, machine learning y servicios gestionados.
Data Engineer
Data Engineer managing pipelines, databases, and data quality for MVM, a government services provider. Developing reports, schemas, mappings, and data models for organizational operations.
Mid-Level Data Engineer
Data Engineer building AI/ML data pipelines and analytics for a Navy IT command. Designing secure, scalable data systems supporting national-security missions.
Senior AWS Data Engineer
Senior AWS Data Engineer developing scalable, reusable data platforms with Python and AWS. Debugging pipelines and delivering solutions for multi-country business environments.
GCP Data Engineer – Freelance
GCP Data Engineer designing and optimizing GCP data ecosystems for client projects. Building pipelines, data architectures, and solutions using BigQuery, Airflow, SQL, and Python.
Senior Data Engineer
Senior Data Engineer building AWS data pipelines and services for a sports-tech platform. Processing AI-generated performance data into scalable metrics, rankings, and talent insights.
Senior Data Platform Engineer – Azure, Databricks, Terraform
Senior Data Platform Engineer automating secure Azure-Databricks platforms for banking clients. Building Terraform infrastructure, Airflow orchestration, and cloud data synchronization pipelines.
Intern, Data Engineer
Data Engineer Intern supporting Acxiom’s cloud data platforms, ETL pipelines, and AI-driven workflows. Gaining hands-on experience with SQL, Python, Spark, and cloud services.
Staff Data Engineer
Staff Data Engineer setting direction for Eve’s Snowflake and dbt data platform. Building secure, reliable infrastructure for AI-powered plaintiff law firm workflows.
Senior Data Engineer
Senior Data Engineer building pipelines, governance, and reliability for Eve’s AI-native legal technology platform. Owning Snowflake, dbt, Terraform, and ingestion infrastructure.