Build and maintain IICS ETL/ELT pipelines, develop Amazon Redshift data models, and use SQL and Python for data transformation and automation. Create Power BI reporting models, implement data quality checks, document pipelines, and collaborate with client stakeholders and engineering teams. The role requires autonomous work, strong communication, and the ability to translate technical solutions into business context, with bonus value for Veeva or life sciences experience.
CompassX is a boutique business and technology consulting firm. We help Fortune 500 and high-growth clients deliver their most strategic initiatives, from enterprise transformations to digital and data-driven projects. With over 15 years of proven results, we’ve expanded across industries including financial services, pharmaceuticals, aerospace, consumer products, and quick service restaurants.
We are honored to be recognized as a three-time winner of Consulting Magazine’s Best Boutique Firms to Work For, and previously recognized as a “Best Place to Work” in Southern California and one of INC.’s 5000 fastest-growing private companies in the U.S.
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
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.
Similar Jobs
Artificial Intelligence • Big Data • Cloud • Security • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Owns and accelerates Nasuni’s strategic partnership with SHI and one additional national partner. Responsibilities include joint business planning, executive alignment, partner relationship development, pipeline and revenue growth, field activation, co-marketing, enablement, forecasting, Salesforce reporting, and AI-enabled workflow improvement. The role requires influencing distributed teams without formal authority, managing national partner strategy, supporting major deals, and creating repeatable programs across commercial, enterprise, and strategic segments. Travel is approximately 30–50%, with remote work preferred near Austin or New Jersey.
Top Skills:
Ai-Enabled ToolsCloudCRMCybersecurityData InfrastructureSaaSSalesforceStorage
Automotive • Professional Services • Software • Consulting • Energy • Chemical • Renewable Energy
Senior Data Scientist responsible for partnering with business leaders to frame ambiguous problems, deliver statistical and machine learning solutions, communicate insights, and drive measurable adoption. The role includes end-to-end analytical ownership, stakeholder influence, executive communication, Agile backlog management, cross-functional collaboration with engineering and technology teams, mentorship, governance, and improving analytics maturity.
Top Skills:
Azure DevopsExcelPower BIPythonRSalesforceSQLTableau
Fintech • Professional Services • Sales • Financial Services
Closes personal loan sales from warm leads, manages up to 20 active transactions, identifies customer needs, explains loan solutions, and exceeds sales and performance targets. The role requires inside sales experience, strong closing ability, CRM proficiency, and availability for an eight-hour shift including one weekend day. It offers remote or hybrid work in Texas and Florida with base pay, uncapped commissions, incentives, and benefits.
Top Skills:
CRMSalesforce
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
