This is a short-term, project-based engagement best suited to an experienced 1099 independent contractor who's comfortable moving fast in an ambiguous, fast-paced environment.
You'll be working within the client's data integration and warehousing stack, helping build and maintain pipelines that move and shape data for downstream reporting. You'll 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. You'll 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 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
Skills Required
- 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 experience with ETL/ELT pipeline design
- Proficiency in Python for data engineering workflows
- Experience building Power BI data models and applying reporting-layer data modeling best practices
- Comfort working with cloud-based data infrastructure
- Strong attention to data quality, validation, accuracy, and traceability
- Strong communication skills and experience collaborating directly with client stakeholders
- Ability to work autonomously in an ambiguous, fast-paced project environment
- Familiarity with Veeva, preferably in a pharmaceutical or life sciences context
- Experience with AWS
What We Do
CompassX is a local-model consulting firm headquartered in SoCal. Founded in 2009, our core delivery focus is on Project Leadership and the flawless execution of our clients’ projects and strategic initiatives. Our team members have unfettered access to a leadership team who truly cares & listens, and the ability to customize their consulting career journey. You will have the opportunity to use your experience, creativity, and passion to put your mark on building the next great consulting firm! Join us and give yourself a chance to love consulting again.
