Job Description

Payroll Title:
Hiring Salary Range
$83,250.00- $107,100.00 / Year
La Jolla
Appointment Type:
Appointment Percent:
Total Openings:
Work Schedule:
Days, 8 hour shifts, Monday - Friday

#120312 Business Intelligence Analyst - Hybrid/Remote

Extended Deadline: Mon 2/13/2023

UC San Diego values equity, diversity, and inclusion. If you are interested in being part of our team, possess the needed licensure and certifications, and feel that you have most of the qualifications and/or transferable skills for a job opening, we strongly encourage you to apply.

For the safety and well-being of the entire university community, the University of California requires, with few exceptions, that all students, faculty and staff be vaccinated against the COVID-19 virus and influenza before they will be allowed on campus or in a facility or office. For more information visit: Flu Vaccine Mandate / COVID Vaccine Policy

UCSD Layoff from Career Appointment: Apply by 11/29/2022 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor.

Special Selection Applicants: Apply by 12/8/2022. Eligible Special Selection clients should contact their Disability Counselor for assistance.

Placement within the salary range is determined by internal equity, relevant qualifications, and collective bargaining agreements (when applicable).

This position offers a hybrid work arrangement, which includes a combination of onsite in La Jolla and remote work.


The Department of Orthopaedic Surgery is a vibrant and growing Orthopaedic Surgery Department of 48 full-time faculty and 50 voluntary faculty, 4 physicians on MSP contracts, 32 trainees, and 34 staff that supports and participates in the academic, clinical, and research mission of UC San Diego. The Department generates over $12M in clinical revenue, and $5M (NIH & other) in research grants and contracts, with total annual expenditures exceeding $30M. The Department is a comprehensive orthopaedic group located in San Diego that offers a full spectrum of musculoskeletal clinical care, specializing in foot and ankle, hand, joint reconstruction, physical medicine and rehabilitation, spine, sports, and trauma. Research expertise includes advancements in muscle metabolism and physiology, neuromuscular bioengineering, intervertebral disc, and musculoskeletal physiology and epidemiology.

Incumbent serves as Business Intelligence & Data Systems Analyst for the Department of Orthopaedic Surgery. This position plays an integral role in providing strategic and tactical data analysis, mining, and reporting for multi-divisional and mission usage. Incumbent applies advanced Oracle Financial Cloud (OFC), EPIC, Tableau, Clarity Clinical Data Warehouse, Cadence, RED Cap, Research, and other data modeling/information management concepts with understanding of UC San Diego campus, central office, Health System and Physician Group to resolve highly complex Business Intelligence initiatives where technical analyses of data modeling, reporting or business requirements are required across the academic, clinical, and research missions.

This position provides technical project management and high level data analytic support. Incumbent is responsible for collecting customer BI requirements, developing related reporting solutions, coordinating testing and overseeing related reporting validation in Oracle Financial Cloud, Tableau, EPIC, Cadence, and other valid systems. Positions facilitates meetings among both internal and external entities to discuss report requirements, data modeling for the report, and report solution consultation. Incumbent will research, compile, analyze and visualize performance and operational data to senior leadership across the Department that will aid in developing recommendations for short term and long-term business strategies. Incumbent designs, creates, and maintains divisional queries to be integrated into a business intelligence platform.

In collaboration with Health System, Physician Group and/or other Campus Departments, incumbent also provides consultation regarding best practices in data management, analytics, visualization, and business intelligence. Incumbent studies internal and external data and employ data mining, predictive modeling, dashboard development, and/or statistical analysis techniques to provide information, knowledge coordination, and tools that support multiple functional areas. Position manages clouds and/or servers to maintain a secure network.

Applies skills and experience as a seasoned business analytics professional to projects of medium size at all levels of complexity, or to portions of large, multidimensional projects.


  • 7 years of related experience, education/training, OR a Bachelor's degree in related area plus 3 years of related experience/training.

  • Thorough knowledge of business intelligence functions, analytics, industry standards and best practices. Experienced with full Business Intelligence (BI) development lifecycle including requirements generation and accelerated development approaches, and report documentation. Fluency in information technologies, including high level of proficiency and understanding with data mapping, data mining and statistical software. Proven statistical and data analysis skills

  • Thorough knowledge of relevant internal databases, BI applications and tools. Ability to produce high-quality reports and documentation. Proven ability to use dashboard intelligence platforms (i.e., IBM Cognos, Tableau Desktop, Tableau Server), enterprise performance management software, and other analytical technologies. Demonstrated experience with complex spreadsheets, tables, graphs, and PowerPoint slides.

  • Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop and effective solutions. Extensive demonstrated experience mining data from multiple sources and databases using SQL, Access, pivot tables and other query tools.

  • Detail oriented, with ability to manage time and organize competing priorities.

  • Strong written and verbal communication skills with the ability to convey complex information in a clear, concise manner. Experience composing and documenting complex technical processes as well as user issues and their resolution. Demonstrated skill in presenting data and providing the analytical interpretation necessary for leadership to make well-educated decisions, scope required projects, and determine appropriate solutions.

  • Strong interpersonal skills for effective collaboration with a broad range of professional and technical staff. Demonstrated skill in presenting data and providing the analytical interpretation necessary for leadership to make well-educated decisions, scope required projects, and determine appropriate solutions.

  • Proven ability to serve as a technical resource providing advice and counsel on business intelligence issues. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. Demonstrated ability to independently exercise initiative, mature judgment and follow-up to resolve problems. Inclusive follow-through and timely completion of assignments is expected.

  • Familiarity with complex logical data design, data mapping or data conversion. Proven modeling, information design and dimensional modeling. Familiarity with highly complex data quality and governance issues and requirements

  • Proven experience with (PL)SQL. Knowledge of Microsoft Access or similar Relational Database Management Systems (RDMS) including experience with Structured Query Language (SQL) coding, data model design and building to group, analyze, and transform data.

  • Demonstrated ability to download, manipulate, analyze and report large amounts of complex data from various Campus, Health System, Health Sciences, Physician Group, and Departmental sources using standard programs and tools.

  • Strong analytics experience including predictive analytics and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.

  • Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.

  • Strong knowledge of data management systems, practices and standards. Experience in data integration and the specification of data services.


  • Advanced degree in Business, Computer or Information Science, Statistics, Predictive Analytics, or related field.

  • Bachelor's Degree in Business Administration, Analytics, Statistics, Economics, Educational Administration or an allied field and two years of experience in administrative analysis or operations research; or an equivalent combination of education and experience.


  • Employment is subject to a criminal background check.

  • Occasional weekends and/or evenings may be required.

Pay Transparency Act Full Salary Range: $63,400 - $142,800 Annually

The University of California, San Diego is required to provide a reasonable estimate of the compensation range for this role. This range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary offers are determined based on final candidate qualifications and experience. The full salary range for this position is defined as the Full Pay Range. The budgeted salary or hourly range that the University reasonably expects to pay for this position defined as the Expected Pay Scale. Placement within the Expected Pay Scale is determined by internal equity, relevant qualifications, and collective bargaining agreements (when applicable).

Job offer is contingent on successful engagement in the UC COVID-19 Vaccination program (fully vaccinated with documented proof or approved exception/deferral).

If applicable, life-support certifications (BLS, NRP, ACLS, etc.) must include hands-on practice and in-person skills assessment; online-only certification is not acceptable.

UC San Diego Health Sciences is comprised of our School of Medicine, Skaggs School of Pharmacy and Pharmaceutical Sciences, The Herbert Wertheim School of Public Health and Human Longevity Science, and our Student Health and Well-Being Department. We have long been at the forefront of translational - or "bench-to-bedside" - research, transforming patient care through discovery and innovation leading to new drugs and technologies. Translational research is carried out every day in the hundreds of clinical trials of promising new therapies offered through UC San Diego Health, and in the drive of our researchers and clinician-scientists who are committed to having a significant impact on patient care. We invite you to join our team!

Applications/Resumes are accepted for current job openings only. For full consideration on any job, applications must be received prior to the initial closing date. If a job has an extended deadline, applications/resumes will be considered during the extension period; however, a job may be filled before the extended date is reached.

To foster the best possible working and learning environment, UC San Diego strives to cultivate a rich and diverse environment, inclusive and supportive of all students, faculty, staff and visitors. For more information, please visit UC San Diego Principles of Community.

UC San Diego Health is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age, protected veteran status, gender identity or sexual orientation. For the complete University of California nondiscrimination and affirmative action policy see:

UC San Diego is a smoke and tobacco free environment. Please visit for more information.

UC San Diego Health maintains a marijuana and drug free environment. Employees may be subject to drug screening.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online