Location: Davis,CA, USA
Job Summary 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 degreeMinimum 5 years of experience in the analysis, retrieval and management of clinical data from a healthcare software systemMinimum 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 SystemsMinimum 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 ObjectsFamiliar 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 systemsFamiliar with electronic health record systems, such as EPICFamiliar with data integration, data repository design, and management of enterprise data repository systems * Working knowledge of Extract, Transform and Load (ETL) applicationsExperience in the design, development of enterprise data marts with high availability/scalability/performanceExperience with integrating complicated data from very disparate sources* Experience with PL/SQL and SQLExperience working with data analytics* Proficient in computer science algorithms and data structuresAbility to analyze research data management workflow and apply software or procedural solutionsExperience with installation, configuration, maintenance, and trouble-shooting of computer operating systemsDemonstrated experience with data interface engines in a healthcare environmentDemonstrated organization skills and flexibility to manage multiple tasks independently and meet deadlinesExperience working as a responsible team member with excellent communication and customer service skills necessary to effectively contribute to a creative groupExperience using logic and flow diagrams to describe the function processes of a systemDemonstrated writing skills needed to translate system processes and associated manual processes into clear instructions and explanationsPreferred Qualifications Master of Science degree or 10+ years of experienceEPIC knowledge and experience strongly preferredAdvanced experience working with relational database design, information and database modelingEpic/Clarity skills are preferred, while this role will not be supporting that system directlyExperience with cyber or network security development* Business Intelligence experience; (i.e. Business Objects Suite)Knowledge of HIPAA patient confidentiality and privacy regulationsKey Responsibilities 40% - Senior Database / Data Mart Architect30% - Application, Software, and System Analysis and Development20% - Database Administration10% - Project ManagementDepartment 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 to 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.Physical Demands Standing - Frequent 3 to 6 HoursWalking - Frequent 3 to 6 HoursSitting - Frequent 3 to 6 HoursLifting/Carrying 0-25 Lbs - Occasional Up to 3 HoursPushing/Pulling 0-25 Lbs - Occasional Up to 3 HoursBending/Stooping - Occasional Up to 3 HoursSquatting/Kneeling - Occasional Up to 3 HoursKeyboard use/repetitive motion - Occasional Up to 3 HoursMental Demands Sustained attention and concentration - Frequent 3 to 6 HoursComplex problem solving/reasoning - Frequent 3 to 6 HoursAbility to organize & prioritize - Frequent 3 to 6 HoursCommunication skills - Frequent 3 to 6 HoursNumerical skills - Occasional Up to 3 HoursConstant Interaction - Occasional Up to 3 HoursCustomer/Patient Contact - Occasional Up to 3 HoursMultiple Concurrent Tasks - Frequent 3 to 6 HoursSpecial 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 requirementsDiversity, 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.#J-18808-Ljbffr