Job Description

Payroll Title:
DATA SYS ANL 4
Department:
PHSO - IS
Salary Range
Commensurate with Experience
Worksite:
Towne Centre Drive
Appointment Type:
Career
Appointment Percent:
100%
Union:
Uncovered
Total Openings:
1
Work Schedule:
Days, 8 hrs/day, Monday-Friday

As a federally-funded institution, UC San Diego Health maintains a marijuana and drug free campus. New employees are subject to drug screening.

#109949 Value Based Care Data Architect

Initial Review Date: Tue 8/24/2021

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 before they will be allowed on campus or in a facility or office. For more information visit: https://ucnet.universityofcalifornia.edu/news/2021/07/ucs-covid-19-vaccine-policy.html

Special Selection Applicants: Apply by 07/02/2021. Eligible Special Selection clients should contact their Disability Counselor for assistance.

The title, description and preferred qualifications of this posting have been updated as of 8/4/21.

This position will remain open until filled.

DESCRIPTION

UC San Diego Health is seeking a Value Based Care Data Architect responsible for architecting, developing, and optimizing the Value Based Care team’s database schema(s).
The database schema(s) span all aspects of healthcare data and operations including but not limited to, patient experience, patient access, ambulatory, inpatient, home, post-acute care, revenue cycle, customer service, market data, digital health, capitation, and other types of data.

The three operational objectives are to develop a platform for Analytics-as-a-Service (AaaS) products, instantiate a highly custom and rapidly developing business into database schema(s), and enable agile and consistent reporting by automatically materializing common query and transformation functions. The technical requirements are that the schema(s) be highly performant and consistent (i.e., governed) across databases, reporting products, and workflows.This position is part of a collaborative data team with business analysts, data source developers, data visualization developers, and ETL developers. Familiarity with developing custom data models from Ambulatory (e.g., clinical encounters, clinical episodes), Tapestry (e.g., referrals and claims), and Healthy Planet (e.g., registry) data is strongly preferred.
The Value Based Care Data Architect reports to the Value Based Care Analytics Manager in the Information Services department.

Organizational Context

UC San Diego Health’s Value Based Care programs aim to advance the Quintuple Aim- the simultaneous improvement of patient outcomes, patient experience, health equity, provider experience, and reduction of cost of care. Insightful and timely analytics directly drives clinical and operational population health efforts to achieve all five outcomes in a program scalable in the community across county lines.

Technical Skills

Ideal candidates will be highly experienced in:

  • Autonomously designing, maintaining (e.g., data integrity and governance), and optimizing complex data models across multiple databases and schemas using highly performant SQL functions based on operational and technical objectives.
  • Developing custom data models purpose-built for operational and technical objectives such as Analytics-as-a-Services (AaaS), performing clinical and business functions, or agile and consistent analytics.
  • Developing data models facilitating non-SQL advanced analytics (e.g., R or Python)
  • Developing data models in a cloud-based environment (e.g., AWS)
  • Developing and automating multi-step stored procedures with audit code to track data source integrity and performance.
  • Optimization of SQL code to meet department guidelines on system performance using techniques like Common Table Expressions (CTE) and executing functions.
  • Development in a data warehouse environment collaborating with ETL developers on incorporating external data from stage tables and optimizing cross-database query performance.
  • Developing detailed test plans validating their data sources to comparable data sources, reference measures, or previously validated reports.
  • Performing and participating in peer code reviews.

Data Systems Analyst

Involves technical acumen for planning, designing, developing, implementing and administering data-based systems that acquire, prepare, store and provide access to data and metadata. Maintains and optimizes systems and migrates data and systems as needed. Ensures integrity and completeness of data and workflow, manages and / or develops data practices, databases and information systems as well as guidelines, dictionaries, registries and / or services. May include interpretation of scientific research data artifacts as well as mediation across science and technology domains and long-term data care. As information architect and data steward, designs systems, data products and / or data production processes while focusing on data curation, data exchange, data security, data integrity and information environments. (Re)evaluates frameworks, strategies, standards and standards-making activities. May involve work with a project-level data repository, a center or an archive.

Level 4

Having significant experience, applies advanced data / information management concepts and campus / medical center / OP objectives to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Selects methods and techniques to obtain desired results

Key Responsibilities

  • Develops full data / information documentation for highly complex small and medium-size projects.
  • Plans and conducts data analysis efforts for highly complex small and medium sized projects that may include managing partnerships between multiple institutions. Establishes or maintains information documentation standards such as data naming standards and value domain descriptions. Schedules and conducts analysis sessions. Documents ownership, custody and access requirements for data subject areas.
  • Coordinates reviews of data models and data definitions. Develops both conceptual and detailed data models for projects. Develops dimensional models for data subject areas. Creates and manages workflows (including ETL, data curation and others).
  • Initiates and designs for diverse date and data systems. Initiates, designs and implements detailed interfaces between computer systems. Initiates, designs, executes and sustains metadata for collections of digital objects.
  • Other duties as assigned.

MINIMUM QUALIFICATIONS

  • Nine (9) years of related operational experience, education/training working with Operational experience working with population health management programs (e.g., enrollment, capitation, ambulatory, care management, social determinants of health, ambulatory quality) and technical experience developing SQL based reports OR a Bachelor’s Degree in related area plus five (5) years of related operational experience/training working with Operational experience working with population health management programs (e.g., enrollment, capitation, ambulatory, care management, social determinants of health, ambulatory quality) and technical experience developing SQL based reports.

  • Professional experience and proven success performing clinical workflows, user interface optimization, clinical decision support, rules development, data integration and mining, clinical ontologies and adoption of technology.

PREFERRED QUALIFICATIONS

  • Certification, knowledge, and experience working with clinical and revenue cycle Epic data especially Caboodle but definitely Epic Clarity.
  • Experience in clinical, revenue cycle, or managed care operations.
  • Experienced architecting highly complex automated schemas (50+ tables/views).
  • Experienced with developing Analytics-as-a-Services (AaaS) products.
  • Experienced working autonomously in a data architecture role, working directly with clinical or business operations.
  • Expert experience in multiple Epic data models such as Ambulatory, Referrals, Tapestry, etc.
  • A high level of proficiency in SQL programming is required and experience in creating views, stored procedures/automation, and SSIS.
  • Comfortable working on a highly collaborative team with operations and technical resources
  • Familiarity with Agile development, Software Development Life Cycles (SDLC) , Product Development Life Cycles (PDLC), and waterfall implementation methodologies
  • Developing data models facilitating non-SQL advanced analytics (e.g., R or Python).
  • Developing data models in a cloud-based environment (e.g., AWS).
  • Developing and automating multi-step stored procedures with audit code to track data source integrity and performance.
  • Optimization of SQL code to meet department guidelines on system performance using techniques like Common Table Expressions (CTE) and executing functions.
  • Performing and participating in peer code reviews.

SPECIAL CONDITIONS

  • Must be willing to work various hours and locations based on business needs.
  • Employment is subject to a criminal background check and pre-employment physical.

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

UC San Diego Health is the only academic health system in the San Diego region, providing leading-edge care in patient care, biomedical research, education, and community service. Our facilities include two university hospitals, a National Cancer Institute-designated Comprehensive Cancer Center, Shiley Eye Institute, Sulpizio Cardiovascular Center, and several outpatient clinics. UC San Diego Medical Center in Hillcrest is a designated Level I Trauma Center and has the only Burn Center in the county. We invite you to join our dynamic 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.

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: http://www-hr.ucsd.edu/saa/nondiscr.html

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

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