Senior Data Analyst

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 program, a source of medical assistance for Utah's vulnerable populations. For information about Utah's 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 Master's degree in Business Administration, Public Administration, Mathematics, Finance, Accounting or a related field as determined by the hiring official.Note: as of April 8, 2024, DHHS employees will be working a hybrid schedule, which includes 2 office days per week and 3 telework days.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 beginning 04/2024.• On-site day care center at the Cannon Health Building with First Steps Day Care - contact for rates and availability, 801-538-6996For 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.Example of Duties• 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 effectively to 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 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 position's 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.