Analyst, ETL Development

Job Description

Title: Analyst, ETL Development

Reports to: Director of Health Data Integration

Classification: Individual Contributor

Location: Boston (Hybrid)

Job description revision number and date: 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). Our mission is to leverage the collective strengths

of FQHCs to improve the health and wellness of the people we serve. We are a fast-growing organization founded

in 2016 with 9 health centers and now serving hundreds of thousands of beneficiaries who receive primary care at

health centers and independent practices nationally. We are an innovative organization developing new

partnerships and programs to improve the health of members and communities, and to strengthen our health

center partners.

Job Summary:

The ETL Developer/ Data Analyst is a key member of the Technology team working closely with the Director of

Health Data Integration, Director of Technology, Director of Analytics, and other members of the C3 team. The

Analyst works collaboratively with all internal departments and with the Company’s FQHC partners to support the

vision, mission, and strategy of the organization.

The ETL Developer/Analyst will design, develop, and support data pipelines and analytics solutions that ensure

accurate, timely, and compliant data integration across clinical, operational, and payer systems. The Analyst should

have a strong healthcare data background, particularly in HIPAA 834 enrollment files, claims/encounter data, and

Federally Qualified Health Centers (FQHCs). The Analyst must also have a customer-service mentality, recognizing

the importance of both internal and external customers.

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 (nice to have)

• 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. **

Full-time

Hybrid remote