CalAIM & Program Data Analyst

Hope Solutions•Pleasant Hill, CA

About The Position

CALAIM & Program Data Analyst ABOUT US Founded in 1991, Hope Solutions, formerly Contra Costa Interfaith Housing, is a vibrant and socially responsive non-profit agency that provides permanent housing and vital support services to over 2,000 homeless or at-risk families and individuals in Contra Costa County. Over 40 faith-based communities support our work, although there are no religious requirements or affiliations to receive services. Are you seeking a new role that fully utilizes your talents and potential—while helping to make the world a better place? If so, please read on! What are you passionate about? At Hope Solutions— we envision a world in which everyone has a place to call home and the support of a strong community so that they can live with dignity and reach their full potential . We strive to be inclusive and responsive to community needs. We are committed to excellence and accomplish our work with integrity, respect, compassion , and humility. Hope Solution's mission is to heal the effects of poverty and homelessness by providing permanent housing and vital support services to highly vulnerable families and individuals. Could our mission be your mission? Learn more about us @ hopesolutions.org TEAM SNAPSHOT We're adding to our team of passionate folks—who are on a mission to help make the lives of others better—through services and support that lead to a higher quality of life for our clients. We'd like to learn more about you—apply for the role! What's our team like? Here's a snapshot of some of the folks at Hope Solutions who help advance our vision to achieve—secure housing and the dignity of self-sufficiency for the homeless and at-risk families and individuals in Contra Costa County. A FEW OF US... Deanne—Chief Executive Officer— Resides with her husband and three children. Enjoys hiking, camping, reading, cooking, and cheering at her kids' games. Alex—Chief Operating Officer— Lives with his wife, son, and dog (and loves when the grandkids visit!). MSW and macro social worker who enjoys reading, baseball (Go Giants!), cooking, hiking, jazz, and family time. Christina—Chief Financial Officer— Resides with her husband, son, two daughters, and their dog. MPA, Non-Profit Graduate Certificate, and 20+ years in finance; enjoys traveling and family time. Beth—Director of Clinical and Support Services— Resides with her sister and son. Licensed psychologist with 30+ years working with children and families; enjoys singing, cooking, gardening, and traveling. Bill—Vice President of Programs— Resides with his partner. Licensed Marriage and Family Therapist with 25+ years’ experience working with underserved populations, specialized training in somatic psychotherapy and end-of-life care; enjoys reading, gardening, and meditation. Cayla—Director of Evaluation & Learning — Resides with her husband and children. MBA in Business Analytics that thrives on spreadsheet analysis, dashboard creation, and reading. Debbie—Director of Development & External Relations— Resides with her husband, two teenagers, and a rescue mutt. Leads external relations and development with 20+ years in marketing and communications. Dominick—Director of Re-Entry Housing & Services— A fourth-generation San Francisco native and father of four, holds a B.S. in Criminal Justice and an M.A. in Leadership. In his free time, he enjoys music, travel, nature, cooking, and quarterly wine trips. Gessika — Director of Properties & Support Services —A Bay Area native and former frontline social worker, Gessika leads housing and support programs that promote long-term stability by addressing mental health, housing access, and systemic injustice. She brings over 15 years of nonprofit leadership and clinical social work experience, with expertise in trauma-informed care, program development, and advocating for frontline staff. Kristina—Director of Human Resources— With over 20 years of experience in HR, leadership, people management, and operations, she holds a Bachelor of Business Administration and is a SHRM-SCP certified professional. A Bay Area native and proud foodie, she lives with her child and enjoys spending time with her family, cycling, hiking, and keeping life light with laughter and fun. Mashal—Director of Housing & Support Services— Resides in the Bay Area. Daughter of Afghan refugees; enjoys weekends with her son, concerts, reading, and Sonoma Coast drives; former Program Manager for housing and care for chronically homeless adults with AIDS/HIV; co-chair for Hope Solutions' CARE Committee and board member. Tanya—Director of Rapid Re-Housing & Navigation— Resides with her husband, daughter, and two sons. Master's in Counseling Psychology with 15+ years serving underserved populations; enjoys music, comedy, movies, exercising, and basketball. WHO WE ARE LOOKING FOR: Hope Solutions seeks an energetic CalAIM & Program Data Analyst who is flexible and responsive to support the needs of our programs while possessing the skill set to collaborate with interdisciplinary team members. The CalAIM/Data Analyst is primarily involved in Hope Solutions CalAIM data and report submission, billing and authorization requests, and ensuring compliance and accuracy in the CalAIM program implementation. CalAIM & Program Data Analyst is also responsible for assisting in maintaining data quality between data systems, running reports to identify data quality gaps, entering data into HMIS and partner data systems, and informing data quality status to the Data Manager on a routine basis. Supervisory Responsibility : None

Requirements

At least one year of experience working with HMIS data systems.
Program administrative knowledge of CalAIM Community Supports and Enhanced Care Management.
Bachelor’s degree or related coursework in qualitative and quantitative analysis, organizational development or program and project management.
Familiarity with program/data analysis reporting requirements
Ability to meet deadlines.
Organized with rigorous attention to detail.
Strong proficiency with basic technology and thorough proficiency with Microsoft Office Word, Excel, and PowerPoint.
Ability to work with minimal supervision.
Minimal travel as required for the work, primarily for meetings
Friendliness and positive attitude with excellent customer services skills
Hope Solutions requires all staff members to either be fully vaccinated (including a booster within six months of the last vaccination) or complete weekly testing.
Must have an operational vehicle, auto insurance, and valid driver's license.
Must pass LiveScan screening and TB test.
Must have own transportation and auto insurance.

Responsibilities

Works with Director of Evaluation and Learning, Data Manager, Program Managers, and other direct service staff members to coordinate CalAIM Community Support and ECM programs and services throughout the organization.
Submit Community Support Medi-Cal referrals to the Contra Costa Health Plan (CCHP).
Conduct follow-up to ensure authorizations are received and approved for service.
Prepare and submit monthly and quarterly reporting of CalAIM to CCHP.
Ensure all CalAIM billing and reporting is completed accurately and timely.
Complete reconciliation of all billing for CalAIM programs.
Manage the agency’s CalAIM training and implementation for staff across the organization.
Submit corrections and appeals on denied claims and rejected invoices.
Review various reports in Apricot to ensure data accuracy across all programs.
Perform routine audits of HMIS and internal data sources to ensure continuous data quality improvement is taking place within every Hope Solutions’ program.
Identify missing data and inconsistencies in recorded data by working with various other data sources.
Report data variations and non-compliance to the Data Manager to ensure that information is reported and corrected.
Data entry for clients who are in HMIS and need to be migrated to Apricot on a weekly/monthly basis.
Possesses a superior knowledge of HMIS and the Apricot database, both the front end and back end, and is a ‘super user’ and backup trainer for all staff.
Other data entry projects as assigned by the Data Manager.
Awareness of and aptitude to understand, respect, and adapt to cultural and identity-based differences within group environments appropriately and effectively.
Knowledge of and commitment to concepts and issues tied to social justice, diversity, equity, and inclusion, and belonging.
Experience fostering and reinforcing an environment that values unique experiences, cultures, and personal humility.
Participate in and complete our new employee onboarding process, which includes reading and discussing a short chapter in the book, The Color of Law.
Professionally represent Hope Solutions in all circumstances.
Comply with all legal/ethical professional guidelines for maintaining consumer confidentiality, adhering to HIPAA guidelines, protecting consumer rights, advocating on consumers’ behalf, and assuring consumer safety.
Comply with all local, state, and federal regulations and Hope Solutions policies and procedures.
Attend all required meetings, including but not limited to Hope Solutions staff meetings and linkage meetings with other agencies.
Perform other duties and responsibilities as assigned.
Attend all required meetings, including but not limited to Hope Solutions staff meetings and linkage meetings with other agencies.
Perform other duties and responsibilities as assigned.