Job Title: Senior Data Engineer Snowflake to Health Cloud Integration
We are seeking a seasoned Senior Data Engineer to lead the integration of Snowflake with Salesforce Health Cloud enabling scalable real-time data exchange and analytics across healthcare platforms. This role is pivotal in building robust data pipelines modeling healthcare data and ensuring seamless ETL processes that support clinical operational and reporting needs.
Key Responsibilities
Architect and implement ETL/ELT pipelines to ingest and transform data from Snowflake to SFDC Health Cloud.
Design and maintain data models that support payer and provider analytics including Portico Excelys and Amisys structures
Leverage DBT for transformation workflows and documentation of data lineage.
Design and implement Snowflake clusters using Terraform
Use Pandas and Python for data wrangling preprocessing and validation.
Collaborate with cross-functional teams to align integration efforts with business goals including real-time sync and batch processing
Ensure data quality governance and compliance with healthcare regulations.
Monitor pipeline performance and troubleshoot issues across environments.
Contribute to platform scalability and observability using tools like MuleSoft Informatica and Salesforce APIs
Required Qualifications
5 years of experience in data engineering preferably in healthcare or CRM integrations.
Hands-on experience with Snowflake DBT and Pandas.
Strong SQL and Python skills.
Experience with Salesforce Health Cloud data structures and APIs.
Familiarity with the Health Care Industry HIPAA and PII data management
Familiarity with integration platforms such as MuleSoft Informatica or custom Snowflake connectors
Experience with Master Data Management solutions and Data Management concepts. Entity resolution splits merges data lineage
Understanding of healthcare data domains including eligibility claims care plans and provider networks
Excellent problem-solving and communication skills.
Preferred Qualifications
Deep SQL stored procedure and materialized view experience.
Knowledge of real-time data sync identity resolution and multi-object updates in Salesforce
Background in business process consulting or enterprise data strategy.
- AS#01