Pharmacy Claims Analyst - Pharmacy Admin - FT Day Shift

University of California - Irvine Health; Orange (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

UCI Health in Orange County seeks a data analytics professional to build and maintain enterprise reporting solutions using pharmacy health data. You will join a multidisciplinary team and leverage Crystal Reports, SSIS, SSRS, Tableau, Epic Reporting Workbench, Epic Radar and the EDW to deliver operational and clinical insights for outpatient pharmacies.

The role requires 3+ years in healthcare analytics, strong English communication, and the ability to tune queries and collaborate across the

Qualifications

• Bachelor's degree in Computer Science or related field.
• 3+ years of data analytics experience in outpatient or retail pharmacies.
• Excellent written and verbal communication in English.
• Ability to perform basic performance tuning to optimize queries.
• Ability to collaborate with teams across the health system.

Responsibilities

• Create and maintain enterprise reporting and analytics solutions using pharmacy health data.
• Work with a multidisciplinary team of developers within the Enterprise Data and Analytics Department.
• Deliver high quality reports and analytic solutions for outpatient pharmacies using Crystal Reports, SSIS, SSRS, Tableau, Epic tools and the EDW.

Skills

Data analytics

English communication

Query tuning

Cross-functional collaboration

Healthcare analytics

Education

Bachelor's Degree in Computer Science or related field

Tools

Crystal Reports

SSIS

SSRS

Tableau

Epic Reporting Workbench

Epic Radar

Enterprise Data Warehouse

EPIC EHR

Job description

Who We Are

UCI Healthis one of California's largest academic health systems and the clinical enterprise of the University of California, Irvine. Established on July 1, 1976, UCI Health has grown into a 1,461-bed health system that includesUCI Health - Orange,UCI Health - Irvine, four Community Network hospitals and a growing network of ambulatory care centers across Orange and Los Angeles counties.

As Orange County's only academic health systems, UCI Health is home to the onlyNational Cancer Institute-designated comprehensive cancer centerbased in the county, the region's only American College of Surgeons-verifiedLevel I adult and Level II pediatric trauma center, American College of Emergency Physicians Gold Level 1 GeriatricEmergency Departmentand a nationally recognizedregional burn centerverified by the American Burn Association. Powered byUC Irvine, UCI Health serves 5.6 million people across Orange County, western Riverside County and southeast Los Angeles County through excellence in patient care, research and medical education.

Your Role on the Team

Position Summary:

The incumbent will be responsible for creating and maintaining enterprise reporting and analytics solutions using pharmacy health data. The incumbent will work on a multidisciplinary team of developers within the Enterprise Data and Analytics Department and will collaborate with other institutions across the University of California Health. The incumbent will use UCI Health software such as Crystal Reports, SSIS, SSRS, Tableau, Epic Reporting Workbench, Epic Radar, and the enterprise data warehouse to deliver high quality reports and analytic solutions. This includes quality metrics, regulatory requirements, and general clinical/operational reporting for outpatient pharmacies.

What It Takes to be Successful

Required Qualifications:

• Must possess the skill, knowledge and ability essential to the successful performance of assigned duties
• Must demonstrate customer service skills appropriate to the job
• Excellent written and verbal communication skills in English
• Bachelor's Degree in Computer Science or related field and/or combination of education and equivalent work experience
• Ability to perform basic performance tuning to optimize queries to meet user needs
• Ability to maintain a work pace appropriate to the workload
• Ability to establish and maintain effective working relationships across the Health System
• 3+ year of data analytics experience in outpatient or retail pharmacies

Preferred Qualifications:

• Knowledge of University and medical center organizations, policies, procedures and forms
• Experience utilizing Lean concepts including visibility walls, problem solving A3's, and Gemba rounding principles
• Experience using Collibra or similar Data Governance platform
• Experience in software development life cycle
• Experience developing and maintaining technical documentation within a centralized code repository
• Clarity Beaker Certification
• 5+ years of healthcare analytics experience
• 5+ years of experience working with EPIC EHR
• 5+ years of experience with SSRS, SSIS, Crystal Reports, and Tableau
• 5+ Years of experience with quality metric reporting
• 3+ years of experience working with healthcare quality metrics

Total Rewards

We offer a wealth of benefits to make working at UCI even more rewarding. These benefits may include medical insurance, sick and vacation time, retirement savings plans, and access to a number of discounts and perks. Please utilize the links listed here to learn more about our compensation practices and benefits.

Conditions of Employment:

The University of California, Irvine (UCI) seeks to provide a safe and healthy environment for the entire UCI community. As part of this commitment, all applicants who accept an offer of employment must comply with the following conditions of employment:

• Background Check and Live Scan
• Employment Misconduct*
• Legal Right to Work in the United States
• Vaccination Policies
• Smoking and Tobacco Policy
• Drug Free Environment

*Misconduct Disclosure Requirement: As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegations or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

The following additional conditions may apply, some of which are dependent upon business unit or job specific requirements.

• California Child Abuse and Neglect Reporting Act
• E-Verify
• Pre-Placement Health Evaluation

Details of each policy may be reviewed by visiting the following page: https://hr.uci.edu/new-hire/conditions-of-employment.php

Closing Statement:

The University of California is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC Anti-Discrimination Policy.

We are committed to attracting and retaining a diverse workforce along with honoring unique experiences, perspectives, and identities.

Together, our community strives to create and maintain working and learning environments that are inclusive, equitable, and welcoming.

UCI provides reasonable accommodations for applicants with disabilities upon request.

For more information, please contact UCI's Employee Experience Center (EEC) at [e-mail] or at [phone], Monday - Friday from 8:30 a.m. - 5:00 p.m.

Consideration for Work Authorization Sponsorship

Must be able to provide proof of work authorization