What are the responsibilities and job description for the MAA Data Program Assistant position at Crisis Support Services of Alameda County?
Description
MAA (Medi-Cal Administrative Activities) is a service, funding, and reporting process between county organizations and the county of Alameda. Crisis Support Services participates in Medi-Cal Administrative Activities in our work via Crisis Services (connecting people in crisis with resources and services, like Medi-Cal), and Community Education programs (educating and destigmatizing conversations about mental health and suicide, promoting health services, like Medi-Cal).
The MAA Data Program Assistant is proficient with Microsoft Excel and Google Sheets, they are a data enthusiast and an exceptionally detail-oriented individual. They are strongly self-motivated and can complete projects with little supervision. The MAA Data Program Assistant will be responsible for completing the monthly reporting process of CSS MAA Activities to the County of Alameda as the county requires.
They will maintain the CSS internal MAA reporting process in an exceptionally organized manner, and communicate with their team and supervisor when they believe processes can be more efficient.
Key Responsibilities
Data Management :
- Create ISLs (Individual Staff Logs) using Google Drive, Google Sheets, Microsoft Excel, and Microsoft Word Mail Merge, for employees to sign via Adobe Sign.
- Use Google Sheets / EXCEL formulas to calculate employee weekly and daily hours for each month using data from employee timesheets and call logs.
- Create monthly departmental cover sheets including employee participation, weekly hours, and termination status.
- Notice and correct discrepancies or errors with Excel / Google Sheet formulas.
- Maintain an accurate reporting system containing thousands of data points.
- Data entry via Smartcare.
- Understand MAA labor codes.
- Develop strategies to improve labor reporting.
Signature & Record Management :
Keep track of recurrent missed participation.
Notify the employee’s supervisor after 2 missed signatures.
Other administrative and clerical duties as needed :
Skills, Knowledge and Expertise
Experience with complex sumifs formulas
Supervision / Direction Received
Month 1 - Month 2 - Training :
Supervisor to lead with the assistant learning the process.
Assistant to lead the entire process with supervision throughout.
Assistant to lead the entire process with supervision at project milestones.
Assistant to lead the entire process teaching the supervisor the process with minimal to no input from the supervisor.
Assistant responsible for completion of Monthly MAA Reporting with Supervisor overview at project completion - supervisor available at project milestones as needed.
Level of Decision-Making
Schedule
This is a part-time, non-exempt (20 hours per week) position and qualifies for up to 4 days of remote work per week. This role is 70% Remote Work, 30% on Site. Printing, In Office - Driving to MAA in Person - Occasional In-Person Meetings as needed.
Up to 7 evening / weekend day availability (annually) is required to attend agency events. Our office is located in North Oakland.
Founded in 1966, Crisis Support Services of Alameda County offers a broad range of counseling, education and prevention services in a safe environment. CSS’ 24-hour crisis hotline responds to more than 65,000 calls each year. Services include on-going therapy groups, school-based counseling, supportive services for seniors, suicide prevention for youth; and community education.
Crisis Support Services of Alameda County recognizes and understands the impact of trauma including the challenge of accessing supportive services. Our mission is to provide a welcoming and safe environment, rooted in the belief that through collaboration with clients at every stage of service healing is possible.
We invite you to learn more about our agency by exploring our website.
Salary : $29
