RESEARCH DATA ANALYST II

California Department of State Hospitals

Sacramento (CA)

Hybrid

USD 74,000 - 93,000

Full time

8 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

The California Department of State Hospitals in Sacramento is seeking a Research Data Analyst II to perform complex data and statistical analysis across facility areas. You will collect, compile, and interpret data, identify trends, validate inputs, and prepare technical reports for management.

You will use Excel, Power BI, SQL, SAS, Tableau and other tools, collaborating with Sacramento-based staff and external stakeholders to support department objectives and special projects.

Qualifications

  • Strong skills in Excel, Power Query, Power Pivot, Visio, Word, Outlook, Teams.
  • Experience with SQL, SAS, Tableau and Power BI.

Responsibilities

  • Research and perform complex data and statistical analysis on a wide range of treatment facility areas, including patient referral data, pending placement trends, patient admission and discharge data, patient length of stay, patient demographics, and facility bed capacity/utilization reporting.
  • Collect, compile, analyze, and interpret qualitative and quantitative data; identify trends and anomalies; research and summarize findings with narrative and summary tables; validate data inputs and point potential adjustments; prepare and present technical reports to management.
  • Collaborate and coordinate with Sacramento-based staff, facility-based staff, county partners, and external stakeholders.

Skills

Statistical analysis
Data research

Tools

Excel
Power Query
Power Pivot
Visio
Word
Outlook
Teams
SQL
SAS
Tableau
Power BI

Job description

Position Details

Job Code #: JC-539187

Position #(s): 461-535-5731-709

Working Title: RESEARCH DATA ANALYST II

Classification: RESEARCH DATA ANALYST II

$6,647.00 - $8,325.00 A

New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.

# of Positions: 1

Work Location: Sacramento County

Telework: Hybrid

Job Type: 12 Month Limited Term - Full Time

Job Description And Duties
  • This limited term position may be extended up to 24 months and has the possibility of becoming permanent.***

Under general supervision of the Research Data Supervisor Il in the Research, Evaluation and Data Insights Division, the Research Data Analyst ll will research and perform complex data and statistical analysis on a wide range of treatment facility areas, including, but not limited to, patient referral data, pending placement trends, patient admission and discharge data, patient length of stay, patient demographics, and facility bed capacity/utilization reporting. The incumbent will collect, compile, analyze, and interpret qualitative and quantitative data; identify trends and anomalies; research and summarize findings with narrative and summary tables; validate data inputs and point potential adjustments; prepare and present technical reports to management. The research and data collection functions of this unit are used to provide regular reporting of program data to support Department objectives and proposals, formulate data driven responses to external entities, and to assist in special projects within the Division and Department. All research projects require regular collaboration and coordination with Sacramento-based staff, facility-based staff, county partners, and external stakeholders.

This function requires advanced use of Microsoft Excel, Power Query, Power Pivot, Visio, Word, Outlook, Teams, and Word. This function also has a potential need for the use of additional software meant to store, extract, analyze, and visualize data. This software may include SQL, SAS, Tableau and Power BI.

You will find additional information about the job in the Duty Statement.

Department Information

The mission of the Department of State Hospitals is to provide evaluation and treatment in a safe and responsible manner, seeking innovation and excellence in hospital operations, across a continuum of care and settings.

Department of State Hospitals

1215 O Street, MS 17

Sacramento, CA 95814

DSH-Sacramento is in a new modern, sustainable and innovative 11 story office building located at 1215 "O" Street, Sacramento, California. Some of the amenities of the new building include the following:

  • First-floor retail space (separate access from 12th Street)
  • Café with multiple vendors available to the public
  • Outdoor seating with pedestrian walkways
  • Large, shared conference room on the first floor with a maximum capacity of 162 individuals
  • An employee fitness center with a yoga studio, cardio equipment and weights
  • Plaza area with a kitchenette on each floor
  • Lactation rooms
  • More conference rooms and collaborative working spaces available throughout the building – small, medium and large
  • Shared Terrace space on the 10th floor with indoor/outdoor seating and views of the Capitol
  • Mobile computer equipment, cloud-based technology and Wi‑Fi for all staff

Department Website: https://www.dsh.ca.gov

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

INFORMATION TECHNOLOGY SPECIALIST II
INFORMATION TECHNOLOGY SPECIALIST II

California Department of State Hospitals • Sacramento (CA)

Hybrid
USD 96,000 - 129,000
STAFF SERVICES ANALYST
STAFF SERVICES ANALYST

California Department of State Hospitals • Sacramento (CA)

Hybrid
USD 43,088 - 70,040
Employee fitness center
Café with multiple vendors
Outdoor seating area
Hybrid Research Data Analyst II - Data Insights
Hybrid Research Data Analyst II - Data Insights

California Department of State Hospitals • Sacramento (CA)

Hybrid
USD 74,000 - 93,000
Senior Health Care Financing Data Specialist II (Hybrid Option)
Senior Health Care Financing Data Specialist II (Hybrid Option)

California Department of Health Care Services • Sacramento (CA)

Hybrid
USD 85,000 - 107,000
Continuous training
Diversity, Equity & Inclusion programs
Employee Assistance Program (EAP)
+1
ANALYST II
ANALYST II

California Department of State Hospitals • California

Hybrid
USD 67,000 - 84,000
HEALTH PROGRAM MANAGER I
HEALTH PROGRAM MANAGER I

California Department of State Hospitals • Sacramento (CA)

Hybrid
USD 80,039 - 99,435
Employee fitness center
Café with multiple vendors
Collaborative working spaces
Research Data Specialist III
Research Data Specialist III

California Department of Health Care Services • Sacramento (CA)

Hybrid
USD 94,000 - 121,000
Medical Insurance
Paid Holidays
Retirement Program
+1
RESEARCH DATA SPECIALIST III
RESEARCH DATA SPECIALIST III

Department of Health Care Services • California

Hybrid
USD 94,000 - 121,000
Medical, dental, and vision insurance
Paid holidays and vacation
Retirement program
+1
ANALYST II
ANALYST II

California Department of State Hospitals • Fresno (CA)

Hybrid
USD 67,000 - 84,000
RESEARCH DATA SUPERVISOR I
RESEARCH DATA SUPERVISOR I

California Department of Developmental Services • Sacramento (CA)

Hybrid
USD 84,000 - 104,000
Medical, Dental & Vision Insurance
Retirement benefits