Job Summary

#

#CA-FT

Housed within the UC Davis Health Information Technology (IT) Division in partnership with the School of Medicine and the Clinical and Translational Science Center Biomedical Informatics Program (CTSC), this organization provides data management, enterprise database support, computing infrastructure, and technology support services to UC Davis’ nationally recognized business and research initiatives. The Data Systems Analyst 4 (DSA4) is a Senior Database Developer / Programmer / IT Architect, possesses advanced knowledge, skills, and experience which can be applied to major projects. This position plays a strategic role in creating a research technology environment that will impact the UC Davis enterprise, along with awarded statewide and national projects.

Apply By Date: November 13, 2024. Interviews and recruitment process may occur at any time.

For full consideration, applicants are encouraged to upload license, certification and/or educational degree if required of the position.

Minimum Qualifications

Bachelor of Science degree
Minimum 5 years of experience in the analysis, retrieval and management of clinical data from a healthcare software system
Minimum 3 year experience maintaining and supporting clinical systems such as Clinical Trials Management Systems, Biorepositories, Electronic Data Capture Systems, Faculty Profile Management Systems, or Investigation Drug Management Systems
Minimum 2 year of experience working with standardized healthcare codes (e.g., ICD, COT, LOINC, SNOMED).
Minimum 4 year experience with various programming languages and software such as SQL, MySQL, Oracle, stored procedures, Python, Tableau, Business Objects
Familiar with the use of secure file sharing such as SFTP, and understanding of best practices in data management, data security, and data privacy within clinical systems
Familiar with electronic health record systems, such as EPIC
Familiar with data integration, data repository design, and management of enterprise data repository systems
Working knowledge of Extract, Transform and Load (ETL) applications
Experience in the design, development of enterprise data marts with high availability/scalability/performance
Experience with integrating complicated data from very disparate sources
Experience with PL/SQL and SQL
Experience working with data analytics
Proficient in computer science algorithms and data structures
Ability to analyze research data management workflow and apply software or procedural solutions
Experience with installation, configuration, maintenance, and trouble-shooting of computer operating systems
Demonstrated experience with data interface engines in a healthcare environment
Demonstrated organization skills and flexibility to manage multiple tasks independently and meet deadlines
Experience working as a responsible team member with excellent communication and customer service skills necessary to effectively contribute to a creative group
Experience using logic and flow diagrams to describe the function processes of a system
Demonstrated writing skills needed to translate system processes and associated manual processes into clear instructions and explanations

Preferred Qualifications

Master of Science degree or 10+ years of experience
EPIC knowledge and experience strongly preferred
Advanced experience working with relational database design, information and database modeling
Epic/Clarity skills are preferred, while this role will not be supporting that system directly
Experience with cyber or network security development
Business Intelligence experience; (i.e. Business Objects Suite)
Knowledge of HIPAA patient confidentiality and privacy regulations

Key Responsibilities

40% - Senior Database / Data Mart Architect
30% - Application, Software, and System Analysis and Development
20% - Database Administration
10% - Project Management

Department Overview

The UC Davis Health, Data Center of Excellence (DCOE) leads, manages, coordinates, administers, and implements major business and scientific technology projects and grants on a statewide and national level for the UC Davis Health. This organization is unique because: it not only requires its employees to have IT competency, but also scientific and business expertise in Biomedical Informatics. Project sponsors and partners that are served by this unit include internal and external Principal Investigators, pharmaceutical companies, governmental agencies, and a variety of commercial companies.

Department Specific Job Scope

A primary responsibility of the DSA4 is to architect, design, implement, and maintain a research data mart capable of supporting data retrievals and advanced analytics. The incumbent will also design and implement business intelligence solutions for aggregating data from multiple sources and producing time sensitive reports and dashboards. Major projects include support for research systems such as OMOP, Atlas, REDCap, and Tableau. This position will also design and implement data source acquisition, ETL (extract, transform, load) processes, and application development for a variety of complex projects. Work and decisions are reviewed in terms of meeting objectives when performed within the accepted parameters of UCD/UCDH policies and procedures and the general guidelines of the department. However, innovative solutions to application problems are discussed with and approved by the unit managers, particularly those that affect the accountability of the unit and coordination of work. Incumbent interacts with operating systems and data management systems, and has independent responsibility for clinical data warehousing applications related t assigned projects and associated grants; developing and maintaining interfaces with separate data systems; and provides specification development for each component of the project infrastructure. This position will work with Health System and Clinical and Translation Science Center data management applications, which may include PL\SQL, SQL, Java, Business Objects, various open-source applications, and select vendor and custom interface engines. This position could also serve as the lead project manager on specific projects.

POSITION INFORMATION

Salary or Pay Range: $8,283.33 - $16,366.67
Salary Frequency: Monthly
Salary Grade: Grade 25
UC Job Title: DATA SYS ANL 4
Number of Positions: 1
Appointment Type: Staff: Career
Percentage of Time: 100
Shift Hours: M-F 8am-5pm
Location: UCDHAS Building (HSP165) Rancho Cordova
Union Representation: 99 - Non-Represented (PPSM)
Benefits Eligible: Yes
Hybrid/Remote/Onsite: This position is hybrid (mix of on-site and remote work)
This position is not an H-1B visa opportunity

Benefits

Outstanding benefits and perks are among the many rewards of working for the University of California. UC Davis offers a full range of benefits, resources and programs to help you bring your best self to work, as well as to help you and your family achieve your health, wellness, financial and career goals. Learn more about the benefits below and eligibility rules by visiting either our handy Benefits Summary for UC Davis Health Employees or Benefits Summary for UC Davis Employees and our Benefits Page.

If you are represented by a union, benefits are negotiated between the University of California (UC) and your union and finalized in a contract. Read your bargaining unit's employment contract, stay abreast of current negotiations and learn about collective bargaining at UC: https://ucnet.universityofcalifornia.edu/labor/bargaining-units/index.html

High quality and low-cost medical plans to choose from to fit your family’s needs
UC pays for Dental and Vision insurance premiums for you and your family
Extensive leave benefits including Pregnancy and Parental Leave, Family & Medical Leave
Paid Holidays annually as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
Paid Time Off/Vacation/Sick Time as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
Continuing Education (CE) allowance and Education Reimbursement Program as stipulated in the UC Davis Health Policies or Collective Bargaining Agreement
Access to free professional development courses and learning opportunities for personal and professional growth
WorkLife and Wellness programs and resources
On-site Employee Assistance Program including access to free mental health services
Supplemental insurance offered including additional life, short/long term disability, pet insurance and legal coverage
Public Service Loan Forgiveness (PSFL) Qualified Employer & Student Loan Repayment Assistance Program for qualified roles
Retirement benefit options for eligible roles including Pension and other Retirement Saving Plans. More information on our retirement benefits can be found here
UC Davis cares about building a community, which is why we provide resources to enhance diversity, equity and inclusion as well as Employee Resource Groups (ERGs) to support our staff

Physical Demands

Standing - Frequent 3 to 6 Hours
Walking - Frequent 3 to 6 Hours
Sitting - Frequent 3 to 6 Hours
Lifting/Carrying 0-25 Lbs - Occasional Up to 3 Hours
Pushing/Pulling 0-25 Lbs - Occasional Up to 3 Hours
Bending/Stooping - Occasional Up to 3 Hours
Squatting/Kneeling - Occasional Up to 3 Hours
Keyboard use/repetitive motion - Occasional Up to 3 Hours

Mental Demands

Sustained attention and concentration - Frequent 3 to 6 Hours
Complex problem solving/reasoning - Frequent 3 to 6 Hours
Ability to organize & prioritize - Frequent 3 to 6 Hours
Communication skills - Frequent 3 to 6 Hours
Numerical skills - Occasional Up to 3 Hours
Constant Interaction - Occasional Up to 3 Hours
Customer/Patient Contact - Occasional Up to 3 Hours
Multiple Concurrent Tasks - Frequent 3 to 6 Hours

Special Requirements

This is a critical position, as defined by UC policy and local procedures, and as such, employment is contingent upon successful completion of background check(s), including but not limited to criminal record history background check(s)
This position is designated as a mandated reporter under CANRA and UC policy, and employment is contingent on compliance with applicable policies, procedures and training requirements

Diversity, Equity, Inclusion and Belonging

At UC Davis, we’re solving life’s most urgent challenges to bring a fuller, healthier, and more resilient world within reach. We grow from every challenge we take on and we don’t just maintain - we improve. We recognize that creating an inclusive and intellectually vibrant organization means understanding and valuing both our individual differences and our common ground. The most comprehensive solutions come from the most diverse minds and you belong here. As you consider joining UC Davis, please explore our Principles of Community, our Clinical Strategic Plan and strategic vision for research and education, and our latest efforts to outgrow the expected. The University of California, Davis is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.

For the University of California’s Affirmative Action Policy, please visit: https://policy.ucop.edu/doc/4010393/PPSM-20

For the University of California’s Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination

Because we want you to be seen, our recruiting process at UC Davis fosters authenticity, diversity, and inclusion. Studies have shown that some people may not apply to jobs unless they meet every single qualification. Each unique role at UC Davis has a set of requirements and you could be perfect for this role, or you could be perfect for the next role! Don’t meet all the requirements? We still encourage you to apply! #YouBelongHere

CA-FT

University of California, Davis

New Jobs

Data Systems Analyst 4