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
