We are seeking a skilled and adaptable BI Analyst with a hybrid background in Salesforce Health Cloud and Informatica to join our analytics and infrastructure team. This role requires a hands-on professional comfortable bridging business intelligence, ETL workflows, and infrastructure-level troubleshooting across cloud platforms.
Project overview:
This role supports the OAPI/Pharma business line by managing data integrations between Salesforce Health Cloud and Informatica, ensuring seamless data flow between systems. You’ll troubleshoot virtual machine access via SSH, facilitate migration of outputs into Airflow, and support AWS infrastructure while interfacing with Google Cloud-hosted systems. The position plays a key role in enabling actionable insights and operational stability across complex, cross-platform data ecosystems.
Requirements:
* Strong experience with Salesforce Health Cloud
* Hands-on experience with Informatica PowerCenter or Informatica Cloud
* Solid understanding of data extraction, transformation, and loading (ETL) processes
* Proficiency in SSH and managing/troubleshooting virtual machine environments
* Familiarity with orchestration tools such as Apache Airflow
* Experience with AWS services (e.g., S3, EC2, RDS)
* Understanding of cloud-based environments (Google Cloud Platform experience a plus)
* Ability to collaborate across infrastructure, data engineering, and business teams
* Experience supporting pharmaceutical or life sciences data workflows is a plus
Responsibilities:
* Manage and optimize data flows between Salesforce Health Cloud and Informatica
* Perform infrastructure-level troubleshooting using SSH and virtual machine access
* Ensure high-quality data migration and integration into Airflow-managed pipelines
* Support AWS-based data operations and contribute to multi-cloud data management
* Collaborate with infrastructure and application teams to maintain seamless operations
* Analyze and validate data transformations to support downstream business reporting
* Serve as a key point of contact for troubleshooting across BI, ETL, and cloud systems
Why this position:
This role offers a unique opportunity to work at the intersection of data analytics, infrastructure, and healthcare. You’ll engage with modern cloud platforms and ETL technologies while supporting a mission-driven pharmaceutical business. It’s an ideal position for a BI Analyst who enjoys problem-solving across platforms, building resilient data workflows, and making a real-world impact in health-related outcomes.