Senior Data Engineer — ETL Pipelines & Redshift Analytics

CompassX Group; United States; On-site; USD 120,000 - 170,000; Full time

Job summary

CompassX Group is a boutique data and tech consultancy seeking a short-term 1099 contractor to design, implement, and optimize data pipelines using IICS, with Redshift as the data warehouse and Power BI for dashboards. You will translate technical work into business context while collaborating with a small team.

You’ll build scalable ETL/ELT processes, ensure data quality, and document data flows for long-term maintenance in a pharma-focused environment.

Qualifications

• Hands-on experience with IICS for data integration.
• Experience 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 for reporting layers.

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.

Skills

SQL

Python

Data modeling

Data quality

Communication

Tools

IICS

Amazon Redshift

AWS

Power BI

Job description

CompassX Group is a boutique data and tech consultancy seeking a short-term 1099 contractor to design, implement, and optimize data pipelines using IICS, with Redshift as the data warehouse and Power BI for dashboards. You will translate technical work into business context while collaborating with a small team.

You’ll build scalable ETL/ELT processes, ensure data quality, and document data flows for long-term maintenance in a pharma-focused environment.