Brillio is looking to integrate Snowflake with Salesforce Health Cloud to enable scalable, real-time data exchange and analytics across healthcare platforms, supporting clinical, operational, and reporting needs.
Requirements
- 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 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
- Deep SQL, stored procedure and materialized view experience.
- Knowledge of real-time data sync, identity resolution, and multi-object updates in Salesforce
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
- Monitor pipeline performance and troubleshoot issues across environments.
Other
- 5+ years of experience in data engineering, preferably in healthcare or CRM integrations.
- Familiarity with the Health Care Industry, HIPAA and PII data management
- Understanding of healthcare data domains including eligibility, claims, care plans, and provider networks
- Excellent problem-solving and communication skills.
- Background in business process consulting or enterprise data strategy.
