Analyst, ETL Development

Title: Analyst, ETL Development Reports to: Director of Health Data Integration Classification: Individual Contributor Location: Boston (Hybrid) Job Description Revision: V 1.0; 11.18.2025 Organization Summary Community Care Cooperative (C3) is a 501(c)(3) non‑profit, Accountable Care Organization (ACO) governed by Federally Qualified Health Centers (FQHCs). Founded in 2016 with 9 health centers, C3 serves hundreds of thousands of beneficiaries nationwide. C3 innovates through partnerships and programs to improve the health of members and communities. Job Summary The ETL Developer/ Data Analyst works closely with the Director of Health Data Integration, Director of Technology, Director of Analytics, and other C3 team members. The analyst designs, develops, and supports data pipelines and analytics solutions that ensure accurate, timely, and compliant data integration across clinical, operational, and payer systems. A strong healthcare data background, especially with HIPAA 834 enrollment files, claims/encounter data, and FQHC reporting, is essential. Customer‑service orientation and collaboration with internal departments and FQHC partners are key. Responsibilities ETL Development & Data Integration: Design, build, and maintain ETL workflows to ingest, transform, validate, and load healthcare data from multiple sources. Develop robust pipelines for processing 834 enrollment files, ensuring accurate member eligibility and plan data. Integrate and process data relevant to FQHC reporting and population health analytics. Maintain and optimize ETL processes within enterprise data warehouses, data lakes, and reporting environments. Data Analysis & Quality Assurance: Analyze enrollment, eligibility, encounter, and claims data to identify discrepancies, trends, and quality issues. Perform data validation, reconciliation, and root‑cause analysis for data integration problems. Create data mapping documents, data dictionaries, and technical specifications. Collaboration & Stakeholder Support: Work with clinical, operational, billing, and IT teams to understand data needs and support reporting initiatives. Collaborate with payer partners, clearinghouses, and vendors on data transmission, troubleshooting, and compliance. Support FQHC reporting requirements, including UDS data submissions and payer quality measure programs. Operational Support: Monitor scheduled ETL jobs and resolve runtime issues or failures. Provide production support, documentation, and version control for all ETL processes. Ensure compliance with HIPAA, data governance, and organizational security policies. Required Skills 3–5+ years of experience in ETL development, data engineering, or data analytics. Hands‑on experience processing 834 enrollment files (parsing, transforming, validating). Strong understanding of FQHC data needs, including UDS reporting, encounters, quality measures, and patient demographic workflows. Proficiency in SQL (e.g., T‑SQL, PL/SQL, PostgreSQL). Experience with ETL tools such as SSIS, Informatica, Talend, Matillion, or similar. Familiarity with healthcare data formats including 837, 835, CCD/C‑CDA, or HL7. Experience with data warehousing concepts, dimensional modeling, and relational database design. Strong analytical, troubleshooting, and problem‑solving skills. Ability to create clear documentation and communicate technical concepts to non‑technical stakeholders. Working knowledge of HIPAA, PHI handling, and healthcare data compliance standards. Must be able to remain in a stationary position 50–75% of the time. Desired Other Skills Familiarity with MassHealth ACO Program. Experience in FQHC environments, community health centers, or value‑based care organizations. Familiarity with EHR systems common to FQHCs (eClinicalWorks, NextGen, OCHIN Epic, etc.). Exposure to modern data stack tools (dbt, Snowflake, Azure Data Factory, AWS Glue, Databricks, etc.). Experience automating workflows using Python, PowerShell, or other scripting languages. Knowledge of payer data requirements and enrollment/eligibility reconciliation processes. Experience with anti‑racism activities, and/or lived experience with racism, is highly preferred. Qualifications Bachelor’s degree required. In compliance with Infection Control practices per Mass.gov recommendations, we require all employees to be vaccinated consistent with applicable law. #J-18808-Ljbffr SupportFinity™