Data Systems Analyst 3

#CA-FT

The Data Systems Analyst 3 is an experienced Information Technology Professional; responsible for investigating, designing, and implementing data systems in preparation for assigned projects and/or for use within clinical research. This position is responsible for the maintenance and support of applications and tools such as Clinical Trials Management Systems (REDCap, OnCore), Biorepositories (FreezerWorks, LIMS Systems), Faculty Profile Management Systems (Elsevier Pure), Investigational Drug Management Systems, and more. The Data Systems Analyst 3 also manages data source acquisition, ETL (extract, transform, and load) processes, and application development for a variety of projects.

This position creates and supports reports for multiple clinical data systems including Epic/Clarity, REDCap, SQL, and Oracle databases. A degree in Health Informatics, Public Health, or Computer Science is preferred. Work and decisions are reviewed in terms of meeting objectives when performed within the accepted parameters of UCD/UCDHS 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 REDCap, J2EE, Java, Oracle, SQL Server, various open-source applications, and select vendor and custom interface engines. This position also serves as the lead project manager on specific projects.

Apply By Date: February 21, 2025 at 11:59pm. Selection activities may start at any time.

Minimum Qualifications- For full consideration, applicants are encouraged to upload license and/or certification if required of the position

• Bachelor's degree in Bioinformatics, Health Informatics, Public Health, Computer Information systems, or equivalent education and experience.
• Minimum 5 years of experience in the analysis, retrieval and management of clinical data from a healthcare software system
• Minimum 1 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 1 year of experience working with standardized healthcare codes (e.g., ICD, COT, LOINC, SNOMED).
• Minimum 1 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
• Maintenance and support of Clinical Trials Management Systems, Biorepositories , Faculty Profile Management Systems, Investigational Drug Management Systems, or other clinical system.
• Analyzing and evaluating specifications; and then designing and creating custom SQL code to meet objectives. o SQL, PL/SQL, SAS, or MySQL o Data integration, data repository design, and management of enterprise data repository systems. o Extract, Transform, and Load (ETL)
• Writing Stored Procedures. o Electronic health record systems, such as EPIC
• Data management, data security and privacy within clinical systems
• Developing and designing technical requirements appropriate to the business needs and objectives.
• Experienced in developing reporting and analytics for internal and external use in a business unit.
• View Creation /Report Writing
• Writing skills needed to translate system processes and associated manual processes into clear instructions and explanations.
• Demonstrated organizational skills and flexibility to manage multiple tasks and meet deadlines.
• Developing innovative coding solutions and design requirements to resolve complex business issues.
• Interpersonal, verbal and written communication skills to clearly and effectively interact with a diverse group of individuals to secure and/or provide information to clarify situations, resolve problems, and negotiate services and/or agreements.

Preferred Qualifications

• Data interface engines in an enterprise environmento Clinical ontologies and semanticso Past experience developing, implementing and supporting data warehouses.
• REDCapo LINUX / UNIX Operating Systemo Relational Database Design and Theoryo Medical Terminologieso Working knowledge and application of HIPAA

Key Responsibilities

• 50% - Application, Software, and System Analysis and Development
• 20% - Project Management
• 20% - Database (Data Warehouse) Administration
• 10% - User Support, Training, and Other Duties

Department Overview

The UC Davis Health, Research IT Unit coordinates and implements clinical studies, technology grants, and technology projects with Principal Investigators, university partners, pharmaceutical companies, governmental agencies, and a variety of commercial companies. 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 unit provides enterprise database support, computing infrastructure, and technology support services to UC Davis' nationally recognized business and research initiatives.

POSITION INFORMATION

• Salary or Pay Range: $3,176.25 - $5,858.24
• Salary Frequency: Biweekly
• Salary Grade: Grade 23
• UC Job Title: DATA SYS ANL 3
• Number of Positions: 1
• Appointment Type: Staff: Career
• Percentage of Time: 100
• Shift Hours: M-F 8am-5pm
• Location: UCDHAS Building (HSP165)
• 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
• 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

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.

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