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

Build and enhance a custom React application integrated with Oracle EBS or Oracle Cloud backend systems. This is a senior-level contract role for someone who can work independently, collaborate with client stakeholders, and deliver quickly.

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

Our consultants say CompassX is a place where they can truly find their own path. As part of a smaller firm, they see the impact of their work, have an identity, and know their voice matters. They value the freedom to take the reins of their careers, shape their client work, and maintain a direct line to leadership.

With CompassX’s focus on serving local Southern California clients, consultants not only build lasting relationships but also see the results of their work in the communities where they live.

At CompassX, you won’t just follow a path - you’ll create one.

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)