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: February 16, 2025 at 11:59pm. Selection activities may start 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
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
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.
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.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.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.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.
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
The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. 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 nondiscrimination policy.
Copyright 2024 Jobelephant.com Inc. All rights reserved.
UC Davis is the home of the Aggies — go-getters, change makers and problem solvers who make their mark at one of the top public universities in the United States. Since we first opened in 1908, we’ve been known for standout academics, sustainability and Aggie Pride as well as valuing the Northern California lifestyle. These themes are woven into our 100-plus-year history and our reputation for solving problems related to food, health, the environment and society.Our 5,300-acre campus is in the city of Davis, a vibrant college town of about 68,000 located in Yolo County. The state capital is 20 minutes away, and world-class destinations such as the San Francisco Bay Area, Lake Tahoe and the Napa Valley are within a two-hour drive.