Senior Data Analyst

California Mental Health Services Authority
United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
$115,000.0 - $145,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis ArcGIS (Software) Big Data Health Informatics Data Dictionary Data Visualization Database Development R (Programming Language) Python (Programming Language) Power BI SQL Databases
+8 more
Tableau (Software) Advanced Reports Build Management Information Technology Data Analytics Data Pipelines Databricks Programming Languages

Job description

  • Design, develop, and maintain complex data models, dashboards, and reports that support organizational and program-level decision-making.
  • Extract, clean, and transform large datasets from multiple sources using SQL, Python, R, or similar tools to ensure data accuracy and integrity.
  • Conduct in-depth quantitative and qualitative analyses to identify trends, patterns, and insights relevant to behavioral health programs and operations.
  • Translate complex analytical findings into clear, concise summaries and visualizations for both technical and non-technical audiences.
  • Collaborate with program, operations, and leadership teams to understand data needs and deliver solutions that address key business questions.
  • Develop and maintain data documentation, including data dictionaries, methodology notes, and reporting specifications.
  • Monitor data quality and integrity across systems; identify discrepancies and work cross-functionally to resolve issues at the source.
  • Support the development and refinement of key performance indicators (KPIs) and metrics frameworks across departments.
  • Participate in the evaluation, implementation, and optimization of data tools, platforms, and pipelines.
  • Mentor junior analysts, providing guidance on analytical methods, tools, and best practices.
  • Stay current on trends in data analytics, health informatics, and public behavioral health to proactively identify opportunities to enhance analytical capabilities.
  • Report findings and escalate data quality or methodology concerns to leadership as needed.

Requirements

Requires a bachelor’s degree in healthcare, data science, computer science and/or a related field, and a minimum of four years of qualifying informatics and analytics experience, or an acceptable equivalent combination of education and experience. Master’s-level training preferred.

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

  • Experience architecting data models and pipelines that support multiple downstream analyses and visualizations, not just individual reports.
  • Ability to design and build advanced dashboarding and reporting solutions (e.g., Power BI) that translate complex data into clear, decision-ready insights for varied audiences.
  • Ability to interpret complex datasets and independently select and apply the right statistical techniques and coding languages for a given question.
  • Ability to proactively identify trends, patterns, and anomalies in data, and translate findings into actionable recommendations for leadership.
  • Ability to evaluate and prioritize potential data product use cases based on organizational impact and feasibility.
  • Advanced experience with data modeling, database development, and management, including evaluating tradeoffs across different technical approaches.
  • Ability to exercise independent judgment on ambiguous or competing priorities, and to adapt quickly to shifting demands.
  • Able to act with a high degree of emotional intelligence, including building trust and influence across teams.
  • Strong communication and management skills, including the ability to translate technical concepts for non-technical stakeholders.
  • Ability to identify confidential and sensitive information and handle according to security and compliance best practices

COMPUTER SKILLS -

Demonstrated advanced proficiency with SQL (querying, data modeling, and pipeline development) and Microsoft Power BI (advanced report and dashboard development) is required. Knowledge of additional visualization tools such as Tableau and ArcGIS Pro is preferred. Experience with data automation and analysis tools such as Excel, R, or Python is preferred.

Databricks experience highly preferred.

LANGUAGE SKILLS and MATHEMATICAL SKILLS - Demonstrate the ability to read, comprehend, and respond appropriately through written or verbal form; demonstrate tactfulness when communicating including internal communication with staff members of all levels; ability to communicate with a variety of audiences effectively. Ability to add, subtract, multiply, and divide in all measure units, using whole numbers, common fractions, and decimals.

REASONING - Demonstrate the ability to effectively apply common sense and follow through to daily tasks; demonstrate the ability to work with little or no supervision; demonstrate excellent analytical skills; demonstrate the ability to efficiently conduct research and ask appropriate probing questions to complete necessary tasks.

PHYSICAL DEMANDS - The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is frequently required to sit and stand; use phone and headset; use hands, arms, fingers to type; answer phones; write; use calculator; demonstrate strength to lift and carry materials weighing up to 20 pounds; demonstrate clear vision to read printed materials and a computer screen; hearing and speech to communicate in person and over the telephone; and drive a motor vehicle on public roads and highways.

SENSORY DEMANDS - The incumbent must spend long hours in intense concentration. The incumbent must also spend long hours on the computer entering information which requires attention to detail and high levels of accuracy.

MENTAL DEMANDS - There are a number of deadlines associated with this position, which may cause significant pressure. The incumbent must also deal with a wide variety of people on various issues.

REGULAR WORK SCHEDULE - Varies depending on business needs; however, company normal business hours are 8:00am to 5:00pm, Monday - Friday.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

5:14 min

Executing Databricks jobs with built-in Airflow operators

Alan Mazankiewicz · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

4:10 min

Assessing and implementing global neurodiversity and accessibility standards

Rudi Bauer Rudi Bauer +2 · Cappuccino with HR

8:27 min

Building generic custom operators for Databricks APIs

Alan Mazankiewicz · LIVE

Videos

See all

Related articles

See all