In addition to other responsibilities this position may participate in the tracking, reporting, quality assurance, and billing efforts for CalAIM, a Medi-Cal waiver program. They will be on a team of analysts who will be providing data collection, analytic, and billing support for CalAIM services tracking and Medi-Cal billing while simultaneously building dashboards and providing regular descriptive analyses

Hourly rate 42.59-57.40

ESSENTIAL FUNCTIONS

               Reporting and Analysis

• Assists department stakeholders to define data needs and requirements to ensure data science projects meet business needs at the community, regional, divisional, departmental, or county-wide level

• Uses statistical programming languages and packages, computer scripting languages, and/or domain-specific languages to digest, manipulate, prepare, augment, evaluate, analyze, summarize, and visualize data

• Conducts end-to-end predictive data modeling projects that include basic exploratory data analysis, model selection, deployment of models into production environments, and visualization of findings

• Performs data management and manipulation, including the writing of data queries of departmental databases, data cleaning, and joining of multiple and disparate data sets

• Extracts and organizes data and applies quality-control techniques to ensure the accuracy and completeness of all data; researches source documents and coordinates with others to resolve missing or conflicting data and other anomalies

• Ensures regular reporting occurs within specified deadlines

• Regularly creates deliverables for special projects and assignments, such as ad-hoc department reporting and program analyses

• Creates documentation for the processes and procedures used for reporting and analyses

              Tool Development and Maintenance

• Collaborates with other department subject matter experts to understand, identify, and select available and relevant sources of data for use cases, including internal and external data sources

• Helps refine program management practices through the creation of new reporting and analytical tools

• Helps to design, build, and maintain analytical support tools to be used within the Department of Health Services, by housing and service providers, and by other external stakeholders

                Project Support:

• Collaborates with data administrators and other IT staff to develop data pipelines and ensure the availability of quality data

• Convenes and facilitates discussions with stakeholders to design and implement tools and reports

• Manages the design, development, implementation and maintenance of reports, dashboards and analysis tools

                Program and Provider Support

• Works with program staff to understand the implications of analyses and to ensure that findings are actionable and support data-driven program, policy, and operational decision- making.

• Assists in coordinating with various functional teams to develop and implement products, services, tools, or business process changes resulting from the analysis.

• Provides regular analyses of the impact of changes in management practices and policies

• Designs program reports, analyzes performance, and provides resulting analyses to stakeholders

JOB QUALIFICATIONS

Education/Experience

Option I:  A Bachelor's degree from an accredited college or university in a field of applied research such as Data Science, Machine Learning, Mathematics, Statistics, Business Analytics, Psychology, or Public Health that included 12 semester or 18 quarter units of coursework in data science, predictive analytics, quantitative research methods, or statistical analysis -AND- Two (2) years of experience in the application of techniques of machine learning, predictive analytics, data management, and hypothesis-driven data analysis to complex experimental designs leading to actionable findings and recommendations -OR- A Master's or Doctoral degree from an accredited college or university in a field of applied research such as Data Science, Machine Learning, Mathematics, Statistics, Business Analytics, Psychology, or Public Health.

Option II:  Four (4) years of experience with responsibility for planning, designing, conducting, and evaluating research projects involving the application of techniques of machine learning, predictive analytics, data management, and/or hypothesis-driven data analysis to complex experimental designs leading to actionable findings and recommendations.

Certificates/Licenses/Clearances

 Other Skills, Knowledge, and Abilities

• Proficiency in Python, SQL, or R for statistical analysis, data transformation, and predictive modeling.
• Familiarity with distributed computing environments such as Databricks, including experience using Spark to manipulate large datasets efficiently.
• Ability to develop and maintain parameterized notebooks and contribute to version-controlled workflows using GitHub.
• Understanding of Bronze, Silver, and Gold data architecture in Databricks and how to build modular, production-ready pipelines.
• Ability to work within a CI/CD-enabled analytics environment, including structured promotion of code and datasets from development to production.
• Familiarity with Unity Catalog, including experience navigating table-level access permissions and data governance standards (e.g., RBAC, PHI/PII handling).
• Experience creating interactive dashboards and visualizations using tools like Tableau or Databricks SQL.
• Strong attention to data quality, validation, and documentation, including working with unstructured or semi-structured data from external systems.
• Comfort working collaboratively in cross-functional teams that include program staff, engineers, and other analysts in a highly dynamic, service-oriented setting
• Ability to translate analytic results into clear narratives and actionable recommendations for non-technical audiences.

PHYSICAL DEMANDS

Stand                                      Frequently

Walk                                        Frequently

Sit                                             Frequently

Reach Outward                       Occasionally

Reach Above Shoulder           Occasionally

Climb, Crawl, Kneel, Bend     Occasionally

Lift / Carry                                 Occasionally- Up to 15 lbs

Push/Pull                                 Occasionally up to 15 lbs

See                                          Constantly

Taste/ Smell                            Not Applicable