Pharmacy Claims Technician - Pharmacy Admin - FT Day Shift

UC Irvine; California (MO); On-site; USD 110,000 - 140,000; Full time

Job summary

UCI Health is seeking a data analytics professional to create and maintain enterprise reporting for pharmacy health data. You will work in a multidisciplinary team within the Enterprise Data and Analytics Department to deliver high quality reports and analytics across outpatient pharmacy operations.

Responsibilities include building dashboards, quality metrics, and regulatory reports using Crystal Reports, SSIS, SSRS, Tableau, and Epic tools.

Qualifications

• Bachelor’s Degree in Computer Science or related field.
• Experience with Epic Reporting Workbench and Epic EHR.
• 3+ years of data analytics in outpatient or retail pharmacies.
• Strong SQL and query tuning skills.
• Experience with Crystal Reports, SSIS, SSRS, Tableau.

Responsibilities

• Create and maintain enterprise reporting and analytics solutions using pharmacy health data.
• Collaborate with multi-disciplinary developers and institutions within UC Health.
• Deliver high quality reports and analytic solutions including quality metrics and regulatory reports.
• Support outpatient pharmacy reporting and operational analytics.

Skills

Data analytics

SQL

Communication

Teamwork

Healthcare analytics

EPIC EHR knowledge

Education

Bachelor’s Degree in Computer Science or related field

Tools

Crystal Reports

SSIS

SSRS

Tableau

Epic Reporting Workbench

Epic Radar

Enterprise Data Warehouse

Job description

Who We Are

UCI Health is 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 includes UCI 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 system, UCI Health is home to the only National Cancer Institute‑designated comprehensive cancer center in the county, the region’s only American College of Surgeons‑verified Level I adult and Level II pediatric trauma center, American College of Emergency Physicians Gold Level 1 Geriatric Emergency Department, and a nationally recognized regional burn center verified by the American Burn Association. Powered by UC 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.

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+ years 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 (949) 824‑0500, 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