Data Systems Manager

UCSF•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 position applies advanced data and information management concepts alongside UCSF and San Francisco VA researchers to support operational and research projects. It is responsible for designing, developing, and maintaining databases for research projects, including subject recruitment and follow-up; developing and maintaining online Power BI dashboards; and administering research application and storage servers for multiple principal investigators. The role resolves complex issues through in-depth evaluation and selection of appropriate methods. In collaboration with the Northern California Institute for Research and Education (NCIRE) and the VA Information Technology group, the Data Systems Manager establishes and upholds data security practices, manages user permissions and data access, and complies with VA privacy and security guidelines and Information Security Office standards. Additional 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 supports data documentation, modeling, analysis, integration, workflows, interfaces, metadata, and research study websites. The position is based in an interdisciplinary health policy research setting at UCSF, working with researchers and partner organizations to improve health and healthcare through evidence, policy, and practice.

Requirements

Bachelor's degree in a related area and/or equivalent experience or training.
At least 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 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, including the ability to communicate technical information to technical and non-technical personnel at different organizational levels.
Service orientation skills.
Ability to work independently and as part of a team; self-motivated, with strong organizational skills.
Advanced problem-solving skills, ability to learn effectively, and ability to 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.
Significant experience in a clinical research environment, including Microsoft and SQL database development and Windows server maintenance.
Strong analytical and dashboarding skills.

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; 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 collections of digital objects.
Consult with NCIRE and the VA IT group on 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; troubleshoot related issues.
Oversee data entry, management, and storage to maximize database effectiveness.
Perform routine application and data quality assurance.
Train and assist end users.
Administer secure applications and storage servers for multiple 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 issues.
Manage and develop official research study websites.
Develop new research data collection and storage tools.
Develop and maintain online Power BI dashboards for operational data and reporting.