Senior Data Analyst

Salt Lake County, UT - USA

Hourly Salary: $ 32 - 54

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Job Description

Love data analysis and programming Come work for the Office of Reimbursement Coordinated Care and Audit (ORCA) in Medicaid as a Senior Data Analyst.

The analyst performs various tasks (e.g. research analyze develop statistical models) for the Medicaid programa source of medical assistance for Utahs vulnerable populations.For information about Utahs Medicaid program please clickhere.

This position requires programming experience with SQL advanced experience with MS Access and professional work experience with large relational databases.

A skills test will be administered to assess skills needed for this position prior to interviews being scheduled.

Preference may be given to those with a completed Masters degreein Business Administration Public Administration Mathematics Finance Accounting or a related field as determined by the hiring official.

Why work for the Utah Department of Health and Human Services In addition to the rich benefits the State of Utah offers the department offers:

On-site fitness center for a minimal membership fee
UTA Eco Pass at a discounted monthly rate
Teleworking opportunities with a minimum 2 office days per week (currently Mondays and Tuesdays)
On-site day care center at the Cannon Health Building with First Steps Day Care - contact for rates and availability or

For more information on the Utah Department of Health and Human Services please click here.

If offered this position your employment will be contingent upon passing a background check and review. There will be no cost to you for this check. This check will include fingerprinting which will be available at various DHHS locations for your convenience. Fingerprinting will be completed prior to your first day of employment. You may review the policy by clicking here.

Responsibilities

Performs statistical and/or actuarial analysis by applying appropriate protocols in analyzing data and reaching accurate conclusions.
Categorizes stratifies and assigns priorities to risk factors for covered clients.
Data mine multiple massive data sources and perform various analysis on the data subset.
Array the data in terms of demographics eligibility components age sex severity of illness etc. and use of data in conjunction with analysis of various services.
Provide statistical and accounting data to obtain federal approval for State of Utah waiver requests.
Conduct financial studies to assure reimbursement rates and methodologies conform to agency policy.
Determine provider reimbursement rates.
Establish capitation rates.
Forecast changes for implementation of new initiatives.
Maintain areas of the State Plan and Administrative Rules dealing with reimbursement including interfacing with federal officials to ensure compliance with federal regulations.
Ability to make detailed analysis summarize findings and communicate effectivelyto management and other staff.
Provide day-to-day monitoring and tracking of assigned reimbursement programs ensuring accurate payment of planned expenditures.

Qualifications

(includes knowledge skills and abilities required upon entry into position and trainable after entry into position)

create advanced SQL queries to extract categorize monitor manipulate and organize data for solving agency problems
utilize advanced skills in MS Access to create workflow programs and to import data and perform high level analyses.
utilize advanced skills in using MS Excel to obtain and/or import data and perform various data analyses
independently evaluate patterns in data to explain variances in utilization and practice patterns
perform advanced mathematical calculations to solve problems
procurement and/or administration of contracts grants or similar agreements
weigh the relative costs and benefits of a potential action
make a decision or solve a problem by using logic to identify key facts explore alternatives and propose quality solutions
use logic to analyze or identify underlying principles reasons or facts associated with information or data to draw conclusions
assess the operational impact of legislation or audit recommendations on services
understand principles theories and practices of the Medicaid/Medicare system
plan organize and prioritize time and workload in order to accomplish tasks and meet deadlines statistical sampling modeling and analysis techniques
compile code categorize calculate tabulate audit verify or process information or data
read interpret and apply laws rules regulations policies and/or procedures
compose and produce reports documents and related materials
communicate information and ideas clearly and concisely in writing; read and understand information presented in writing
develop and maintain applicable professional contacts resources and /or network
rate setting for services

Supplemental Information

EffectiveJuly 1 2021 State of Utah Employees must either reside in Utah or be in the process of relocating to within 30 days of their start date.
This position may currently be a hybrid of both in-office and remote work days. Please note a positions eligibility for remote work is established by agency management and is subject to change at their discretion at any time and for any reason.
Risks found in the typical office setting which is adequately lighted heated and ventilated e.g. safe use of office equipment avoiding trips and falls observing fire regulations etc.
Typically the employee may sit comfortably to perform the work; however there may be some walking; standing; bending; carrying light items; driving an automobile etc. Special physical demands are not required to perform the work.

Required Experience:

Senior IC

Job DescriptionLove data analysis and programming Come work for the Office of Reimbursement Coordinated Care and Audit (ORCA) in Medicaid as a Senior Data Analyst.The analyst performs various tasks (e.g. research analyze develop statistical models) for the Medicaid programa source of medical assista...