We are seeking a skilled DBT Python Developer with experience in healthcare payer data. The ideal candidate will have a strong background in DBT, Python and SQL scripting. You will be responsible for developing, deploying and enhancing DBT models to improve data processing and standardization.
This role is 100% REMOTE.
Responsibilities:
- Remodel and enhance existing DBT models to improve data processing and standardization. Develop new DBT ETL pipelines as additional payers are brought on.
- Work with payer data including claims, eligibility, appetition, and premium data.
- Transform data from multiple payers like Aetna, BCBS, Humana, and Anthem into standardized tables (member data, standardized claims data).
- Utilize DBT for ETL processes, ensuring data is correctly processed and loaded into the internal data warehouse (SQL Server).
- Work closely with the team managing Apache Airflow and Python scripting to ensure seamless integration and data flow.
- Fix bugs and perform root cause analysis for issues like Claim Paid totals aren’t correct, membership counts aren’t correct, or patient matching/MPI issues.
Qualifications:
- Experience developing DBT models with healthcare payer data, including claims, eligibility, and premium data.
- Proficiency in DBT, Python, and SQL scripting.
- Strong understanding of ETL pipeline development and management.
- Familiarity with Apache Airflow for managing workflows.
