What are the responsibilities and job description for the Snowflake with Salesforce Health Cloud position at NAM Info Inc?
Job Role: Snowflake with Salesforce Health Cloud
Job Type: Contract
Job Location: Dallas OR St Louis OR New York (Remote need to go to office if required)
Role Overview
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 built in DBT.
- 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, Databricks 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.