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 program a source of medical assistance for Utahs vulnerable populations. For information about Utahs Medicaid program please click here.
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 degree in 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 problemsutilize 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 analysesindependently evaluate patterns in data to explain variances in utilization and practice patternsperform advanced mathematical calculations to solve problemsprocurement and / or administration of contracts grants or similar agreementsweigh the relative costs and benefits of a potential actionmake a decision or solve a problem by using logic to identify key facts explore alternatives and propose quality solutionsuse logic to analyze or identify underlying principles reasons or facts associated with information or data to draw conclusionsassess the operational impact of legislation or audit recommendations on servicesunderstand principles theories and practices of the Medicaid / Medicare systemplan organize and prioritize time and workload in order to accomplish tasks and meet deadlines statistical sampling modeling and analysis techniquescompile code categorize calculate tabulate audit verify or process information or dataread interpret and apply laws rules regulations policies and / or procedurescompose and produce reports documents and related materialscommunicate information and ideas clearly and concisely in writing; read and understand information presented in writingdevelop and maintain applicable professional contacts resources and / or networkrate setting for servicesSupplemental Information
Effective July 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
Key Skills
Databases,Data Analytics,Microsoft Access,SQL,Power BI,R,Tableau,Data Management,Data Mining,SAS,Data Analysis Skills,Analytics
Employment Type : Full-Time
Experience : years
Vacancy : 1
Hourly Salary Salary : 32 - 54