Sr Salesforce Health Cloud Data Engineer

In Dallas with remote flexibility, Cook Systems is seeking a Senior Salesforce Health Cloud Data Engineer to design and build ETL jobs and cross-system data integrations across the full development lifecycle. The role partners with Salesforce Architects and Application Development teams to ensure bidirectional data movement using Salesforce Data Loader and Azure tools, while upholding HIPAA privacy and federal security policies.

Responsibilities

• Collaborate with Salesforce Architects to design data models for Salesforce repositories aligned with the overall solution architecture.
• Maintain data integrity and accuracy within the Salesforce HealthCloud environment.
• Ingest, validate, and process incoming data, applying business rules and integrating within Salesforce.
• Develop and coordinate unit and integration test plans; perform testing and evaluate results.
• Design, implement, and maintain code for Salesforce data integration activities with third-party applications.
• Deploy changes and provide post-implementation user and system support.
• Identify opportunities for data-driven improvements and advocate for beneficial changes.
• Identify, analyze, and resolve critical data issues while ensuring compliance with security policies.

Requirements

• Bachelor's degree in Business Administration, Computer Science, Mathematics, Engineering, or a related field, or equivalent database development experience.
• U.S. Citizenship with the ability to obtain 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 an equivalent language.
• Experience with ETL involving structured and semi-structured data.
• Experience gathering business requirements from cross-functional teams.
• Familiarity with SDLC processes and DevOps practices.
• 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, Salesforce
• Azure, Databricks, Python
• Azure Data Factory, Microsoft SSIS, SQL Server, Snowflake, SQL

Benefits

• 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 large provider network for quality care.
• Peace of Mind: Life, critical illness, and accident insurance through Unum.
• Flexibility for Life: Flexible Spending Account and Daycare FSA through Navia to help manage healthcare and dependent-care expenses.
• Extra Protection When You Need It: Health Gap Insurance through Sun Life.
• Your Future Starts Now: 401(k) plan through The Standard, eligible after six months.

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 per TriWest telecommuting policy with periodic office attendance as needed.