Zócalo Health is looking to transition from fee-for-service to value-based care for the Latino community in the U.S. This requires ensuring the accuracy and timeliness of data shared with Medicaid health plan partners, which is crucial for performance accountability, care quality, and business growth.
Requirements
- Proficiency with Google Sheets or Excel (vlookups, pivots, QA techniques)
- Experience working with EHR or care-management data
- Basic SQL or ability to learn data tooling over time
- Experience with Athena or other clinical systems
Responsibilities
- Own data reconciliation and reporting workflows needed to submit accurate RTF/OTF files to Medicaid health plans
- Gather, validate, and prepare data from multiple sources (EHR, eligibility files, outreach tracking sheets, care coordination documentation)
- Identify missing or inconsistent fields and partner with Operations to resolve issues
- Track submission schedules, confirmation receipts, and errors requiring follow-up
- Maintain documentation including version control, change logs, SOPs, and reporting calendars
- Monitor metrics such as outreach outcomes, data completeness, and submission acceptance rates
- Collaborate with Product/Data teams to translate today’s manual workflows into future automation
Other
- 2–4 years of experience working with healthcare data in an operations or reporting capacity
- Strong attention to detail — able to catch errors before they reach the payer
- Excellent communication skills to collaborate with Operations and cross-functional teams
- Ability to thrive in a fast-moving startup environment with evolving processes
- Experience with Medicaid or managed care reporting processes (such as return file submissions or encounter data validation) is a plus, but not required.
- Familiarity with Medicaid, Medi-Cal, or managed care reporting requirements
- Understanding of value-based care performance reporting
