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 Bachelors 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 Masters 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
- A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions.
- Successful clearing through the Live Scan and the Health Clearance process with the County of Los Angeles
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
Not Applicable Not required for essential functions
Occasionally (0 - 2 hrs/day)
Frequently (2 - 5 hrs/day)
Constantly (5 hrs/day)
WORK ENVIRONMENT
General Office Setting Indoors Temperature Controlled
EEOC STATEMENT
It is the policy of Heluna Health to provide equal employment opportunities to all employees and applicants without regard to age (40 and over) national origin or ancestry race color religion sex gender sexual orientation pregnancy or perceived pregnancy reproductive health decision making physical or mental disability medical condition (including cancer or a record or history of cancer) AIDS or HIV genetic information or characteristics veteran status or military service.
Required Experience:
IC