Job Description
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. **