Data Systems Analyst IV-Pharmacy Administration-FT Day Shift

University of California, Irvine; Orange (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

University of California, Irvine seeks a data analytics professional to design and maintain enterprise reporting solutions using SQL, SSIS/SSRS, Tableau, and Epic reporting tools.

You will collaborate with a multidisciplinary team to deliver high-quality analytics, regulatory metrics, and clinical/operational reporting within UCI Health's Enterprise Data and Analytics Department. Experience with Epic EHR and data governance is a plus.

Qualifications

• Bachelor’s degree in Computer Science or related field or equivalent work experience.
• 3+ years of SQL experience.
• 3+ years of experience with MS SQL Server or Oracle and reporting tools (SSRS, Tableau).
• 3+ years of data analytics using relational databases.
• Excellent written and verbal English communication.

Skills

SQL

Data analytics

SSRS

Tableau

MS SQL/Oracle

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 systems, UCI Health is home to the only National Cancer Institute-designated comprehensive cancer center based 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 Angles 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 electronic 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.

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+ years of experience with SQL
• 3+ years of experience with MS SQL server or Oracle as well as reporting tools such as SSRS, Tableau, etc
• 3+ year of data analytics experience using relational databases

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