Data Systems Manager

University of California, San Francisco•San Francisco, CA

About The Position

The UCSF Institute for Health Policy Studies, in conjunction with the San Francisco Veterans Administration, seeks an experienced Data Systems Manager to support the San Francisco VA Center for Healthcare Improvement and Medical Effectiveness (CHIME) VA Data Core. The incumbent applies advanced data and information management concepts alongside UCSF and San Francisco VA researchers to support operational and research projects. The position designs, develops, and maintains databases for research activities, including subject recruitment and follow-up; develops and maintains online Power BI dashboards; and administers and maintains research application and storage servers for multiple principal investigators. The role resolves complex data and systems issues, establishes data security practices with NCIRE and VA Information Technology, and manages permissions and access in compliance with VA privacy and security guidelines and Information Security Office standards. Other work includes data quality assurance, end-user training and support, installation and licensing of server-based statistical applications, and developing data collection and storage tools. The role also involves data documentation and modeling, analysis planning, workflow management, system interfaces, metadata, research websites, and ongoing maintenance of operational and research databases. The Philip R. Lee Institute for Health Policy Studies at UCSF is an interdisciplinary research institute focused on improving health and transforming healthcare through evidence, policy, and practice. Its mission emphasizes comprehensive and equitable approaches to complex societal health challenges, access to high-quality and affordable healthcare, and the use of unbiased research to inform decision-making.

Requirements

Bachelor's degree in a related area and/or equivalent experience or training.
Minimum of 5 years of related experience.
Ability to prepare complex data models independently.
Ability to understand and model complex knowledge-intensive processes, such as scholarly and research processes.
Experience in data integration and specification of data services.
Proven modeling and information design skills.
Good negotiation and influencing skills.
Familiarity with highly complex logical data design and data mapping or data conversion.
Familiarity with complex data quality and governance issues and requirements.
Advanced knowledge of data management systems, practices, and standards.
Thorough knowledge of relevant rules and regulations.
Ability to work with people from diverse backgrounds.
Effective communication and interpersonal skills.
Service orientation skills.
Ability to communicate technical information to technical and non-technical personnel at various organizational levels.
Ability to work independently and as part of a team; self-motivated.
Strong organizational skills.
Advanced problem-solving skills.
Ability to learn effectively and meet deadlines.
Advanced analytical and design skills, including the ability to abstract information requirements from real-world processes and understand information flows in computer systems.
Ability to represent relevant information in abstract models.
Critical thinking skills and attention to detail.

Responsibilities

Develop full data and information documentation for highly complex small- and medium-sized projects.
Plan and conduct data analysis for complex projects, including projects involving partnerships between multiple institutions.
Establish or maintain information documentation standards, including data naming standards and value domain descriptions.
Schedule and conduct analysis sessions, and document data ownership, custody, and access requirements.
Coordinate reviews of data models and data definitions; develop conceptual, detailed, and dimensional data models.
Create and manage workflows, including ETL and data curation.
Initiate and design diverse data and data systems, detailed interfaces between computer systems, and metadata for digital object collections.
Consult with NCIRE and the VA IT group to determine data security best practices.
Design databases for subject recruitment, follow-up, and related activities.
Design, implement, and maintain research and operational databases, including error and logic verification, and troubleshoot issues.
Oversee database-based data entry, management, and storage.
Perform routine application and data quality assurance.
Train and assist end users.
Administer secure applications and storage servers for several research principal investigators.
Manage security, user permissions, and data access in accordance with VA privacy and security guidelines.
Install server-based statistical applications and manage related licensing and accessibility.
Manage and develop official research study websites.
Initiate programming of new data collection and storage tools.