CalAIM & Program Data Analyst

CALAIM & Program Data Analyst

ABOUT US

Founded in 1991 Hope Solutions formerly Contra Costa Interfaith Housing is avibrantandsocially responsive non-profit agency that provides permanent housing and vital support services to over 2000 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 potentialwhile helping to make the world a better place If so please read on!

What are you passionate about

At Hope Solutionswe 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 Solutions mission is to heal the effects of povertyandhomelessness by providing permanent housing and vital support services to highly vulnerable families and individuals.

Could our mission be your mission

Learn more about us @

TEAM SNAPSHOT

Were adding to our team of passionate folkswho are on a mission to help make the lives of others betterthrough services and support that lead to a higher quality of life for our clients.

Wed like to learn more about youapply for the role! Whats our team like

Heres a snapshot of some of the folks at Hope Solutions who help advance our vision to achievesecure housing and the dignity of self-sufficiency for the homeless and at-risk families and individuals in Contra Costa County.

A FEW OF US...

DeanneChief Executive OfficerResides with her husband and three children. Enjoys hiking camping reading cooking and cheering at her kids games.

AlexChief Operating OfficerLives 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.

ChristinaChief Financial OfficerResides with her husband son two daughters and their dog. MPA Non-Profit Graduate Certificate and 20 years in finance; enjoys traveling and family time.

BethDirector of Clinical and Support ServicesResides with her sister and son. Licensed psychologist with 30 years working with children and families; enjoys singing cooking gardening and traveling.

BillVice President of ProgramsResides 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.

CaylaDirector of Evaluation & Learning Resides with her husband and children. MBA in Business Analytics that thrives on spreadsheet analysis dashboard creation and reading.

DebbieDirector of Development & External RelationsResides with her husband two teenagers and a rescue mutt. Leads external relations and development with 20 years in marketing and communications.

DominickDirector of Re-Entry Housing & ServicesA fourth-generation San Francisco native and father of four holds a B.S. in Criminal Justice and an M.A. in his free time he enjoys music travel nature cooking and quarterly wine trips.

GessikaDirector of Properties & Support ServicesA 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.

KristinaDirector of Human ResourcesWith 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.

MashalDirector of Housing & Support ServicesResides 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.

TanyaDirector of Rapid Re-Housing & NavigationResides with her husband daughter and two sons. Masters 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

WHAT WILL YOU DO:

CalAIM Administrator:

• 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 agencys CalAIM training and implementation for staff across the organization.
• Submit corrections and appeals on denied claims and rejected invoices.

Data Quality:

• 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.

Cultural Responsiveness:

• 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 inclusionand 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.

Organizational/Administrative Responsibilities:

• Professionally represent Hope Solutions in all circumstances.
• Comply withall legal/ethical professional guidelines formaintainingconsumer confidentiality adhering to HIPAA guidelines protecting consumer rights advocating on consumers behalf and assuring consumer safety.
• Comply withall 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.

Position Qualifications:

• At least one year of experience working with HMIS data systems.
• Program administrative knowledge of CalAIM Community Supports and Enhanced Care Management.
• Bachelors 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 drivers license.
• Must pass LiveScan screening and TB test.
• Must have own transportation and auto insurance.

Physical Qualifications:

• The physical demands described here represent those that an employee must meet to perform the essential functions of this job accommodations may enable individuals with disabilities to perform the essential functions.
• While performing the duties of this job the employee is regularlyrequired to sit at their desk for an extended period use hands to finger forcomputer keyboard input handle or feel objects tools or controls; and reach with hands and arms.
• The employee frequently is required to talk or hear.
• The employee must frequently lift and move up to 10 pounds and occasionally lift and move up to 25 pounds.
• Specific vision abilities required by this job include close vision.
• Mobility to use standard office equipment including computer vision to read printed materials a computer screen and hearing and speech to communicate in person and over the telephone.

Compensation & Benefits:

• Flexible dynamic work environment.
• 100% premium paid for employee Kaiser health and dental care.
• Matched 403b retirement savings.
• 11 paid holidays plus 3 floating holidays.
• Ability to accrue 2-4 weeks vacation depending on tenure.
• Life insurance and Employee Assistance Program.

We are an equal-opportunity employer. If youre a good fit we want to meet you!

* Please be advised that we are unable to provide sponsorship for this position. The nature of the work at Hope Solutions does not qualify us to support sponsorship. Only candidates authorized to work in the USA without the need for sponsorship will be considered.

Required Experience:

Senior IC