Job Data Engineer ChurnZero Integration at Remote

Hope you are doing well

Please find the Job Description (JD) below.

Location US Remote

Work Time Zone EST

Role Overview:

We are seeking an experienced Data Engineer to support the migration of applicable Power BI reporting and customer-success workflows to ChurnZero. The role requires strong Azure data engineering, SQL, PySpark, API integration, data validation, and production-support skills.

Project Overview:

The current platform uses Azure Data Factory and Azure Synapse to process healthcare and customer data into Parquet and Delta files in Azure Data Lake. The project will move required Power BI transformations into the Azure data-processing layer and build secure, reliable integrations that load customer data into ChurnZero. The engineer will collaborate with Customer Success, business, security, vendor, and Offshore delivery teams.

Responsibilities:

• Design and maintain integrations between Azure Data Lake and ChurnZero using REST APIs, CSV imports, or approved integration methods.
• Analyze existing Power BI transformations and migrate applicable logic to SQL, PySpark, Synapse notebooks, or ADF pipelines.
• Map source data to ChurnZero accounts, contacts, attributes, events, custom fields, and custom tables.
• Build incremental, restartable, and duplicate-safe pipelines with API batching, retries, error handling, logging, monitoring, and reconciliation.
• Perform source-to-target validation including row counts, duplicates, required fields, NULL handling, and date formatting.
• Support ChurnZero dashboards, segments, ChurnScores, Plays, Journeys, and alerts; monitor and troubleshoot production pipelines across ADF, Synapse, Spark, ADLS, and ChurnZero.
• Protect healthcare and customer data according to HIPAA, security, and privacy requirements; coordinate testing, deployments, production support, and maintain mappings, data-flow diagrams, runbooks, and support documentation.

Must have skills:

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field, or equivalent experience; 8+ years in data engineering, ETL/ELT, integration, or production data operations.
• Strong hands-on experience with Azure Data Factory, ADLS Gen2, Azure Synapse/Synapse Spark, Key Vault, SQL, Python, PySpark, Spark SQL, and Bash.
• Experience processing Parquet and Delta Lake data and building incremental ETL/ELT pipelines.
• Experience with REST APIs including authentication, JSON, HTTP, pagination, batching, retries, and error handling.
• Experience analyzing Power BI data models, Power Query transformations, or DAX calculations; strong data-validation, reconciliation, troubleshooting, and production-support skills.
• Experience with Git, Azure DevOps, CI/CD, monitoring/logging, Onshore-Offshore teams, clear technical documentation, and strong written/verbal communication.

Good to have :

• Experience implementing/administering ChurnZero or another customer-success platform such as Gainsight, Totango, or Planhat; familiarity with ChurnZero accounts, contacts, events, custom fields/tables, segments, dashboards, and ChurnScores.
• Healthcare payer, Medicare Advantage, provider, member, quality, or claims-data experience; HIPAA/PHI/PII knowledge; exposure to Dynamics 365, Salesforce, HubSpot, Databricks, Azure Functions, Logic Apps, or API Management.