Sr Salesforce Health Cloud Data Engineer

Cook Systems offers a role focused on secure, end-to-end health data integration. As a Senior Salesforce Health Cloud Data Engineer, you will design and implement ETL jobs and data integrations across the full software lifecycle, collaborating with Salesforce Architects and Application Development teams to enable bidirectional data movement using Salesforce Data Loader and Azure tools, all while upholding HIPAA, privacy, and federal security requirements. The position emphasizes collaboration, governance, and delivering reliable data flows, with remote work options and a strong benefits package to support health and financial security.

Responsibilities

• Collaborate with Salesforce Architects to model data for Salesforce repositories in line with solution architecture.
• Maintain data integrity and accuracy within the Health Cloud application.
• Ingest, validate, and process incoming data, applying business rules and integrating within Salesforce.
• Develop and coordinate unit and integration test plans; execute testing and assess results.
• Design, implement, and optimize code for Salesforce data integration with third-party applications.
• Apply changes and provide user and system support post-implementation.
• Identify opportunities for improvement and advocate data-driven changes.
• Resolve critical data issues while ensuring alignment with security policies.

Requirements

• Bachelor's degree in Business Administration, Computer Science, Mathematics, Engineering, or related field, or equivalent database development experience.
• U.S. Citizenship with the ability to receive a favorable DoD background investigation.
• 5+ years of experience in a Data Engineering role.
• 2+ years of experience with Azure.
• 3+ years of experience developing data integration source code in SQL or equivalent.
• Experience in ETL with both structured and semi-structured data.
• Experience gathering business requirements from cross-functional teams.
• Familiarity with SDLC processes and DevOps.
• Preferred: 2+ years of experience with Databricks, Python, Data Governance, Azure Data Factory, Microsoft SSIS, SQL Server, and Snowflake in Azure Cloud.

Technologies

• Salesforce Health Cloud
• Salesforce Data Loader
• Azure
• Databricks
• Python
• Azure Data Factory
• Microsoft SSIS
• SQL Server
• Snowflake in Azure Cloud
• SQL

Benefits

• Health insurance
• Life, critical illness, and accident insurance
• Flexible Spending Account and Daycare FSA
• Health Gap Insurance
• 401(k) plan

Working Conditions

• Works non-standard hours as required
• Standard office environment with less than 10% travel
• Extensive computer work with prolonged periods of sitting
• Remote work eligible under TriWest telecommuting policy with periodic in-office attendance as needed

Why Work With Us

• Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, with dental and vision coverage included, plus access to a nationwide provider network.
• Peace of Mind: Life, critical illness, and accident insurance through Unum to support your family.
• Flexibility for Life: Flexible Spending Account and Daycare FSA through Navia to manage healthcare and dependent-care costs.
• Extra Protection When You Need It: Health Gap Insurance through Sun Life for unexpected costs.
• Your Future Starts Now: 401(k) plan through The Standard, eligibility after six months to start saving for tomorrow.