Senior Data Engineer (IICS & Redshift) (Independent Contractor)
Senior Data Engineer (IICS & Redshift) (Independent Contractor)
CompassX GroupStraight from CompassX Group’s careers page. Apply on the company site — no recruiter, no middleman.
Senior Data Engineer (IICS & Redshift) (Independent Contractor)
Team: Data & AI
Location: Remote
Commitment: Contract
Workplace Type: remote
Salary:
The posted compensation range is provided for pay transparency purposes. Final compensation will be structured as an hourly rate or other contract-based arrangement and will be determined based on factors including experience, skills, qualifications, scope of work, engagement type, market conditions, and business needs.
Currently, this role will most likely be as an hourly independent contractor through to the end of the year (1099 basis)
This is a short-term, project-based engagement best suited to an experienced 1099 independent contractor whos comfortable moving fast in an ambiguous, fast-paced environment.
Youll be working within the clients data integration and warehousing stack, helping build and maintain pipelines that move and shape data for downstream reporting. Youll work closely with client-side stakeholders as well as the CompassX team, so clear communication and the ability to translate technical work into business context matters as much as the engineering itself. Youll collaborate closely with a small group of engineers and analysts, so the ability to work autonomously while staying tightly aligned with the team is essential.
What Youll Do
-
Design, build, and maintain scalable ETL/ELT pipelines using IICS to integrate data from source systems into the warehouse.
-
Integrate complex commercial datasets utilizing newly established API ingestion methods, alongside multiple manual data sources.
-
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.
What Youll Bring
-
Hands-on experience with IICS (Informatica Intelligent Cloud Services) for data integration.
-
Experience working with Amazon Redshift as a data warehouse platform.
-
Experience extracting and processing complex data sets via APIs.
-
Ability to onboard quickly and operate independently in a fast-paced, aggressive 12-week project timeline.
-
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 — accuracy and traceability are critical for this environment.
-
Bonus: familiarity with commercial pharma CRM and operations data sets.
Similar remote jobs
All Data Engineer jobs →
Broadvoice
Senior Program Manager, PMO


TrustedHousesitters
Senior Product Designer

Applaudo
Senior Data Engineer (GCP & Data Integration)
Discover More than 100,000 Hidden Remote Jobs Before Everyone Else
Unlock All Remote Jobs Today
Simple pricing. Big savings on Quarterly and Yearly.
Monthly Access
- Instant access to fresh remote jobs from 500+ companies
- New opportunities added hourly, often 3-7 days before anywhere else
- Advanced filtering by role type, stack, pay, and location
- Priority customer support
Yearly Access
- Everything in Monthly
- Save $169 (~74%) vs paying monthly
- Average job search takes ~6 months - get covered for the whole journey
- Less than the cost of one lunch per month for competitive advantage
- Equivalent to just ~$4.92/month