Community Care Cooperative (C3) · 3 hours ago
Analyst, ETL Development
Boston, MA
Full-time
Hybrid
Mid Level
$103K/yr - $126K/yr
3+ years expCommunity Care Cooperative (C3) is a non-profit Accountable Care Organization focused on improving health and wellness through partnerships with Federally Qualified Health Centers. The ETL Developer/Data Analyst will design, develop, and support data pipelines and analytics solutions to ensure accurate data integration across clinical, operational, and payer systems.
Health CareHospitalNon ProfitSocial
Responsibilities
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
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
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
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
Qualification
Required
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
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
Preferred
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
Company
Community Care Cooperative (C3)
Community Care Cooperative (C3) exists to deliver great health care to all by offering a series of health plans uniquely tailored to meet each individual’s medical needs, no matter what road they are on in their healthcare journey.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Jenny Carney
Chief Operating Officer
Recent News
2023-12-05
Company data provided by crunchbase