Brillio is seeking a Senior Data Engineer to integrate Snowflake with Salesforce Health Cloud, enabling scalable, real-time data exchange and analytics across healthcare platforms. This role is crucial for building robust data pipelines, modeling healthcare data, and ensuring seamless ETL processes to support clinical, operational, and reporting needs.
Requirements
- 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
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.
Other
- 5+ years of experience in data engineering, preferably in healthcare or CRM integrations.
- Excellent problem-solving and communication skills.
- 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.
