Maintain data quality across all platforms (e.g., TheraPlatform to SalesMate) by duplicating, standardizing, and tagging Lead Care Manager (LCM) notes for efficient retrieval.
Perform regular data audits to identify missing or incomplete entries and resolve discrepancies directly with care teams.
Oversee member profile integrity, ensuring active/inactive statuses, discharge reasons, service end dates, and transitions are correctly documented for audit readiness.
Troubleshoot and resolve system data errors, integrity issues, and user access problems promptly.
Manage all health plan compliance submissions, executing monthly and quarterly transmission of required files (ECM RTF, OTF) to all contracted health plans.
Gather, validate, and consolidate data from multiple internal systems, ensuring accuracy of member demographics, service dates, and adherence to specific health plan formatting requirements.
Conduct recurring eligibility checks to confirm members remain qualified for ECM, Medi-Cal, and other service programs, updating member statuses promptly to ensure accurate resource allocation.
Document all requalification activities in compliance with audit standards and payer expectations.
Compile and distribute weekly leadership reports on key member statuses (active, pending, closed cases) and track trends such as outreach completion and engagement levels.
Translate raw data into actionable insights that enable executive leadership and multiple stakeholders (department heads, sales teams) to make timely, data-driven decisions.
Produce recurring weekly and monthly operational reports to monitor organizational performance, service utilization, and program engagement rates.
Support Program Expansion by aggregating demographic, economic, and healthcare utilization data to identify new regions for community-based program placement.
Research and curate a calendar of community events, conferences, and networking opportunities, assessing their strategic value based on target populations and potential partnerships.
Track outcomes and engagement metrics post-event to evaluate return on investment and guide future outreach planning.
Support evolving priorities by assisting with data system implementations, migrations, workflow redesigns, and supporting new staff training in data procedures.
Requirements
Bachelor's degree in Data Management, Information Systems, or a related field preferred or equivalent 3-5 years of demonstrated experience.
Minimum of 3 years of professional experience in data administration, reporting, or compliance.
Minimum of 3 years of experience within the healthcare or business services industry, preferred.
Expert proficiency with SQL and complex database query tools.
Experience in Monday.com, SalesMate, Google Workplace (i.e., sheets, docs, presentation is a plus)
Direct experience with TheraPlatform and SalesMate is strongly preferred.
Proficiency in the Google Workspace platform (Docs, Sheets, Drive).
Strong analytical, organizational, and problem-solving skills, with keen attention to detail.
Ability to communicate technical concepts clearly and effectively with all levels of leadership.
Compliance Knowledge: Familiarity with Medi-Cal, ECM, CalAIM, and health plan compliance processes is required.
Additional Skills Required: Administration and data administration tasks, Excel spreadsheets, Excel formulas, Microsoft Suite. Also, must be tech-savvy and have the ability to work on multiple tasks at once, meet reporting deadlines.
Benefits
160 Hours of Paid Time Off (PTO)
12 Paid Holidays per year, including your birthday and one floating holiday after 1 year of employment
4 Paid Volunteer Hours per Month to support causes you care about
Bereavement Leave, including Fur Baby Bereavement
90% Employer-paid Employee-Only Medical Benefits
Flexible Spending Account (FSA)
Short-Term & Long-Term Disability | AD&D
Employee Assistance Program (EAP)
401(k) with Company Match
Monthly Stipend
Opportunities for professional development and internal growth
Employee Discounts via Great Work Perks and Perks at Work
Quarterly In-Person Events
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.