> Markdown version of [/jobs/ext/4299257-lead-data-engineer](https://www.wearedevelopers.com/jobs/ext/4299257-lead-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data Engineer

- **Company:** OPEN CONVERSATION LLC
- **Location:** Atlanta, GA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Adaptable Database Systems, Continuous Integration, Data Profiling, Python (Programming Language), Performance Tuning, Freeform SQL, Macros, Sql Optimization, Snowflake, Data Pipelines
- **Published:** October 6, 2026
- **Apply:** https://www.careerjet.com/jobad/us7dc1973cc13f6943ac0bf588d6dd3193

## About the Role

* Advanced SQL CTEs, complex joins, analytic & window functions
 * Snowflake query & warehouse performance optimization
 * DBT advanced models, macros, packages & custom materializations
 * Python intermediate or higher
 * Data Profiling keys, cardinality, data types, precision, scale & skew
 * Data Quality & Testing Frameworks
 * CI/CD for DBT deployments
 * Data Modeling
 * Healthcare/Payer experience

## Description

Interested candidates are required to include their LinkedIn URL, email address, and cell phone number along with their resume when submitting their profile.
Mandatory Requirements

 * DBT
 * Snowflake
 * Advanced SQL
 * Python
 * Data Modeling
 * CI/CD
 * Healthcare Domain Experience

Roles & Responsibilities

 * Design and implement scalable data models and data pipelines aligned with business requirements.
 * Develop complex DBT models using advanced features, including macros, packages, and custom materializations.
 * Work extensively with Snowflake for query and warehouse performance optimization.
 * Develop and optimize complex SQL queries using CTEs, complex joins, analytic and window functions.
 * Perform data profiling, including analysis of keys, cardinality, data types, precision, scale, and data skew.
 * Implement and support data quality and testing frameworks.
 * Support CI/CD processes for DBT deployments.
 * Develop and maintain data models supporting healthcare and payer-related data requirements.
 * Collaborate with business and technical teams to translate requirements into scalable data solutions.