DBT Developer (Remote / EST hours)

A health services network is currently seeking an experienced professional to join their staff as their new DBT Developer. In this role, the DBT Developer will be responsible for developing, deploying and enhancing DBT models to improve data processing and standardization.

About the Opportunity:

• Setting: Remote


• Hours: EST

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, 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