Managed Care Data Analyst
ARUP Laboratories | Salt Lake City, UT, 84112, USPosted a month ago
Description
Overview
We are University of Utah Health. As a patient-focused organization, University of Utah Health exists to enhance the health and well-being of people through patient care, research and education. Success in this mission requires a culture of collaboration, excellence, leadership, and respect. University of Utah Health seeks staff that are committed to the values of compassion, collaboration, innovation, responsibility, diversity, integrity, quality and trust that are integral to our mission. EO/AA
Overview:
This position for use in Health Plans Departments only.
This position is responsible for the collection, compilation, and input of data; analyzing and summarizing data; the development and/or preparation of reports; validation of reports to ensure accuracy and completeness of data; and for presenting findings and/or recommendations to internal and external customers.
This position is not responsible for providing care to patients.
Benefits:
Save 50% on Tuition (Tuition reduced for eligible employees attending the University of Utah)
Health Coverage, Dental Coverage, Life Insurance
Retirement
Paid Time Off
11 Paid Holidays per year
Corporate Overview: The University of Utah is a Level 1 Trauma Center and is nationally ranked and recognized for our academic research, quality standards and overall patient experience. Our four hospitals and seventeen clinics provide excellence in our comprehensive services, medical advancement, and overall patient outcomes.
How to Apply:
Submit your application online at employment.utah.edu
Upload most recent updated resume with work history and experience, please include Month and Year in formatting.
Responsibilities
Collects and organizes data that is entered into databases.
Ensures the accuracy of data, analyzes conflicting data, and verifies and collects missing information.
Utilizes computer programs and software to analyze data, determines trends and changes in data.
Works with end users to determine report criteria and build reports as requested.
Provides timely and accurate reports to management, internal/external customers as required.
Learn data sources, how data is obtained and stored, and how to appropriately use data from different information sources.
Handles special projects and creates special reports with assistance or guidance from more senior staff as needed.
May assist in development and/or presentation of recommendations for a course of action based on the analysis of data.
May assist in audits of data and processes.
May work with systems or other departments as needed to pull SQL reports
Knowledge / Skills / Abilities
Ability to perform the essential functions as outlined above.
Excellent communication (both written and verbal) and interpersonal skills, including ability to present information to a variety of audiences with differing knowledge levels.
Demonstrated strong analytical and problem solving skills.
Ability to independently determine the type and nature of analysis to be used to obtain the desired information or results including data to be collected, analysis methods, presentation, and format and report structure, with assistance as needed.
Ability to organize and prioritize multiple projects,or reports, identify issues, obtain valid data, and create clear and understandable reports that reflect the data being sought, with assistance when needed.
Ability to work well alone or in a team setting.
Must be a self starter / self motivated.
Willingness to learn new programs, processes, and applicable analytic tools
Demonstrated knowledge of payers, payer systems, cost effective utilization management and care management programs
Qualifications
Qualifications Required
Bachelor's degree in a related field, or equivalency.
One years of direct experience collecting, organizing, validating and analyzing data, and in the development and presentation of clear and concise reports.
Experience working with Microsoft Excel pivot tables, charts, and advanced formulas and/or Microsoft Access.
Qualifications (Preferred)
Preferred
Knowledge of SQL queries, preferably in Oracle/MS SQL or other mainstream database.
Experience in health care, particularly claims data, and working knowledge of the health care industry, such as CPT/HCPCS, DRG and revenue codes and basic medical terminology.
Microsoft Visual Basic/VBA program development.
Experience and knowledge with insurance plans, auditing, and or compliance in a managed care setting or equivalent experience.
Working Conditions and Physical Demands
Employee must be able to meet the following requirements with or without an accommodation.
This is a sedentary position that may exert up to 10 pounds and may lift, carry, push, pull or otherwise move objects. This position involves sitting most of the time and is not exposed to adverse environmental conditions.
Physical Requirements
Sitting, Standing
Interested in this opportunity?
To inquire about this posting, email: careers@hsc.utah.edu
EEO Statement
University of Utah Health Hospitals and Clinics, a part of The University of Utah, values candidates who have experience working in settings with students from diverse backgrounds and possess a strong commitment to improving access to higher education for historically underrepresented students.
Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities and protected veterans are encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.
University of Utah Health Hospitals and Clinics, a part of The University of Utah, is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran's status. The University does not discriminate on the basis of sex in the education program or activity that it operates, as required by Title IX and 34 CFR part 106. The requirement not to discriminate in education programs or activities extends to admission and employment. Inquiries about the application of Title IX and its regulations may be referred to the Title IX Coordinator, to the Department of Education, Office for Civil Rights, or both.
To request a reasonable accommodation for a disability, please contact the University of Utah Health Hospitals and Clinics Human Resources office at 801-581-6500.If you or someone you know has experienced discrimination or sexual misconduct including sexual harassment, you may contact the Director/Title IX Coordinator in the Office of Equal Opportunity and Affirmative Action:
Sherrie Hayashi
Director/ Title IX Coordinator
Office of Equal Opportunity and Affirmative Action (OEO/AA)
383 University Street, Level 1 OEO Suite
Salt Lake City, UT 84112
801-581-8365
oeo@utah.edu
Online reports may be submitted at oeo.utah.edu/
For more information: https://www.utah.edu/nondiscrimination/
The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service, may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Hospitals and Clinics Human Resources at (801) 581-6500 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions. Please contact Utah Retirement Systems at (801) 366-7770 or (800) 695-4877 or Hospitals and Clinics Human Resources at (801) 581-6500 if you have questions regarding the post-retirement rules.
This position may require the successful completion of a criminal background check and/or drug screen.
Requisition Number 59063
Reg/Temp Regular
Employment Type Full-Time
Shift Day
Work Schedule Monday- Friday
Clinical/Non-Clinical Status Non-Clinical
Location Name University of Utah Health Plans
Workplace Set Up Remote
City Murray
State UT
Department UIP CST 01H UUHP CLINICAL OPRN
Category Information Technology
recblid pihs9sh2gfgds132yh6p1bazjbq3f1