ETL Developer

Job Description

• Design, build, test, and maintain ETL pipelines in Databricks for healthcare data ingestion and transformation.

• Use SQL, Spark SQL, and PySpark to process, map, and transform large healthcare datasets. Review client data dictionaries and mapping requirements to accurately ingest and structure incoming data.

• Perform data quality and validation checks, troubleshoot ingestion issues, and create extracts for downstream reporting and analytics.

• Develop and maintain API integrations while working with medical claims, pharmacy claims, EHR, eligibility, behavioral health, and population health data.

Skills and Requirements

• Strong experience with Databricks-based ETL development, including data ingestion and pipeline design.
• Strong SQL, Spark SQL, and PySpark skills for transforming and processing large datasets.
• Hands-on experience with healthcare data, including medical claims, pharmacy claims, EHR, and eligibility data.
• Experience with data quality and validation, including reconciliation, troubleshooting, and resolving data issues.
• Experience with API integrations, data extracts, and client data dictionaries/source-to-target mappings.
• Experience supporting Population Health Management programs.
• Experience working with behavioral health data.
• Experience with justice-involved/correctional healthcare populations, particularly data related to individuals transitioning from correctional facilities back into community-based healthcare.
• Experience working with multiple healthcare data sources and integrating them into a centralized data platform.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].