UC Davis Health System
Data Systems Analyst 4
UC Davis Health System, Rancho Cordova, California, us, 95741
#
#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 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 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 PLSQL, 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.67Salary Frequency:
MonthlySalary Grade: Grade 25UC Job Title: DATA SYS ANL 4Number of Positions: 1Appointment Type: Staff: CareerPercentage of Time: 100Shift Hours: M-F 8am-5pmLocation: UCDHAS Building (HSP165)
Rancho CordovaUnion Representation: 99 - Non-Represented (PPSM)Benefits Eligible:
YesHybrid/Remote/Onsite: This position is hybrid (mix of on-site and remote work)This position is not an H-1B visa opportunityBenefits
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 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.
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
Apply for Job
UC Davis Campus CareersSign InNew User
#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 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 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 PLSQL, 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.67Salary Frequency:
MonthlySalary Grade: Grade 25UC Job Title: DATA SYS ANL 4Number of Positions: 1Appointment Type: Staff: CareerPercentage of Time: 100Shift Hours: M-F 8am-5pmLocation: UCDHAS Building (HSP165)
Rancho CordovaUnion Representation: 99 - Non-Represented (PPSM)Benefits Eligible:
YesHybrid/Remote/Onsite: This position is hybrid (mix of on-site and remote work)This position is not an H-1B visa opportunityBenefits
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 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.
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
Apply for Job
UC Davis Campus CareersSign InNew User